DBA Data[Home] [Help]

PACKAGE: APPS.ASG_CUSTOM_PUB

Source


1 PACKAGE ASG_CUSTOM_PUB AUTHID CURRENT_USER as
2 /* $Header: asgpcsts.pls 120.1 2005/08/12 02:50:39 saradhak noship $ */
3 
4 
5   G_PKG_NAME      CONSTANT VARCHAR2(30) := 'ASG_CUSTOM_PUB';
6   G_FILE_NAME     CONSTANT VARCHAR2(12) := 'asgpcstb.pls';
7   G_INS                      CONSTANT CHAR    := 'I';
8   G_UPD                      CONSTANT CHAR    := 'U';
9   G_DEL                      CONSTANT CHAR    := 'D';
10   G_ALL_USERS                CONSTANT NUMBER  := -999999;
11 
12 
13   PROCEDURE customize_pub_item(
14    p_api_version_number         IN      NUMBER,
15    p_init_msg_list              IN      VARCHAR2 :=FND_API.G_FALSE,
16    p_pub_item_name              IN VARCHAR2,
17    p_base_table_name           IN VARCHAR2,
18    p_primary_key_columns        IN VARCHAR2,
19    p_data_columns               IN VARCHAR2,
20    p_additional_filter          IN VARCHAR2,
21    x_msg_count                  OUT NOCOPY NUMBER,
22    x_return_status              OUT NOCOPY VARCHAR2,
23    x_error_message              OUT NOCOPY VARCHAR2
24                               );
25 
26   PROCEDURE mark_dirty (
27    p_api_version_number         IN      NUMBER,
28    p_init_msg_list              IN      VARCHAR2 :=FND_API.G_FALSE,
29    p_pub_item                   IN VARCHAR2,
30    p_accessList                 IN asg_download.access_list,
31    p_userid_list                IN asg_download.user_list,
32    p_dmlList                    IN asg_download.dml_list,
33    p_timestamp                  IN DATE,
34    x_return_status              OUT NOCOPY VARCHAR2
35                         );
36 
37   PROCEDURE mark_dirty (
38    p_api_version_number         IN      NUMBER,
39    p_init_msg_list              IN      VARCHAR2 :=FND_API.G_FALSE,
40    p_pub_item                   IN VARCHAR2,
41    p_accessList                 IN asg_download.access_list,
42    p_userid_list                IN asg_download.user_list,
43    p_dml_type                   IN CHAR,
44    p_timestamp                  IN DATE,
45    x_return_status              OUT NOCOPY VARCHAR2
46 	   	     );
47 
48   PROCEDURE mark_dirty (
49    p_api_version_number         IN      NUMBER,
50    p_init_msg_list              IN      VARCHAR2 :=FND_API.G_FALSE,
51    p_pub_item                   IN VARCHAR2,
52    p_accessid                   IN NUMBER,
53    p_userid                     IN NUMBER,
54    p_dml                        IN CHAR,
55    p_timestamp                  IN DATE,
56    x_return_status              OUT NOCOPY VARCHAR2
57 		     );
58 
59   PROCEDURE mark_dirty (
60    p_api_version_number         IN      NUMBER,
61    p_init_msg_list              IN      VARCHAR2 :=FND_API.G_FALSE,
62    p_pub_item                   IN VARCHAR2,
63    p_accessid                   IN NUMBER,
64    p_userid                     IN NUMBER,
65    p_dml                        IN CHAR,
66    p_timestamp                  IN DATE,
67    p_pkvalues                   IN asg_download.pk_list,
68    x_return_status              OUT NOCOPY VARCHAR2
69 		     );
70 
71   PROCEDURE mark_dirty (
72    p_api_version_number         IN      NUMBER,
73    p_init_msg_list              IN      VARCHAR2 :=FND_API.G_FALSE,
74    p_pub_item                   IN VARCHAR2,
75    p_accessList                 IN asg_download.access_list,
76    p_userid_list                IN asg_download.user_list,
77    p_dml_type                   IN CHAR,
78    p_timestamp                  IN DATE,
79    p_bulk_flag                  IN BOOLEAN,
80    x_return_status              OUT NOCOPY VARCHAR2
81 		     );
82 
83 END ASG_CUSTOM_PUB;