小说网站 搜小说 无限网 烟雨红尘 小说爱好者 免费小说 免费小说网站

AP模块NOTE修改API

--创建
AP_NOTES_PUB.Create_Note (
  p_api_version                 IN         NUMBER                            ,
  p_init_msg_list               IN         VARCHAR2 := FND_API.G_FALSE       ,
  p_commit                      IN         VARCHAR2 := FND_API.G_FALSE       ,
  x_return_status               OUT NOCOPY VARCHAR2                          ,
  x_msg_count                   OUT NOCOPY NUMBER                            ,
  x_msg_data                    OUT NOCOPY VARCHAR2                          ,
  p_source_object_code          IN         VARCHAR2                          ,
  p_source_object_id            IN         NUMBER                            ,
  p_note_type                   IN         VARCHAR2                          ,
  p_notes_detail                IN         VARCHAR2                          ,
  p_entered_by                  IN         NUMBER   := fnd_global.user_id    ,
  p_entered_date                IN         DATE     := sysdate               ,
  p_source_lang                 IN         VARCHAR2 := userenv('LANG')       ,
  p_creation_date               IN         DATE     := sysdate               ,
  p_created_by                  IN         NUMBER   := fnd_global.user_id    ,
  p_last_update_date            IN         DATE     := sysdate               ,
  p_last_updated_by             IN         NUMBER   := fnd_global.user_id    ,
  p_last_update_login           IN         NUMBER   := fnd_global.login_id
);
--删除
AP_NOTES_PUB.Delete_Notes (
  p_api_version                 IN         NUMBER                            ,
  p_init_msg_list               IN         VARCHAR2 := FND_API.G_FALSE       ,
  p_commit                      IN         VARCHAR2 := FND_API.G_FALSE       ,
  x_return_status               OUT NOCOPY VARCHAR2                          ,
  x_msg_count                   OUT NOCOPY NUMBER                            ,
  x_msg_data                    OUT NOCOPY VARCHAR2                          ,
  p_source_object_code          IN         VARCHAR2                          ,
  p_source_object_id            IN         NUMBER                            ,
  p_note_type                   IN         VARCHAR2 := G_ALL_NOTE_TYPES
);
--复制
AP_NOTES_PUB.Copy_Notes (
  p_api_version                 IN         NUMBER                            ,
  p_init_msg_list               IN         VARCHAR2 := FND_API.G_FALSE       ,
  p_commit                      IN         VARCHAR2 := FND_API.G_FALSE       ,
  x_return_status               OUT NOCOPY VARCHAR2                          ,
  x_msg_count                   OUT NOCOPY NUMBER                            ,
  x_msg_data                    OUT NOCOPY VARCHAR2                          ,
  p_old_source_object_code      IN         VARCHAR2                          ,
  p_old_source_object_id        IN         NUMBER                            ,
  p_new_source_object_code      IN         VARCHAR2                          ,
  p_new_source_object_id        IN         NUMBER
);

posted on 2013-12-06 20:17  王小航  阅读(171)  评论(0编辑  收藏  举报

导航