1 PACKAGE ASG_CUSTOM_PVT AUTHID CURRENT_USER as
2 /* $Header: asgvcsts.pls 120.1 2005/08/12 02:59:33 saradhak noship $ */
3
4
5
6 -- Global constants holding the package and file names to be used by
7 -- messaging routines in the case of an unexpected error.
8
9 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASG_CUSTOM_PVT';
10 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asgvcstb.pls';
11
12
13 -- This procedure is used to redefine custom publication items
14 -- by speciying the base table and other parameters.
15 -- p_pub_item_name specifies the name of custom publication item
16 -- p_base_table_name parameter can be a view as well.
17 -- p_primary_key_columns is comma separated list of columns that
18 -- constitute the primary key.
19 -- p_data_columns is comma separated list of columns that should
20 -- be in the publication item are not part of primary key columns
21 -- p_additional_filter is additional predicate on PIV besides
22 -- the ones already defined.
23 -- x_error_status return FND_API.G_RET_STS_SUCCESS when the
24 -- procedure executed without error.
25 -- x_error_message contains a descriptive message if the x_error_status
26
27 -- is not FND_API.G_RET_STS_SUCCESS
28 PROCEDURE customize_pub_item(
29 p_api_version_number IN NUMBER,
30 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
31 p_pub_item_name IN VARCHAR2,
32 p_base_table_name IN VARCHAR2,
33 p_primary_key_columns IN VARCHAR2,
34 p_data_columns IN VARCHAR2,
35 p_additional_filter IN VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_error_message OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE mark_dirty (
42 p_api_version_number IN NUMBER,
43 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
44 p_pub_item IN VARCHAR2,
45 p_accessList IN asg_download.access_list,
46 p_userid_list IN asg_download.user_list,
47 p_dmlList IN asg_download.dml_list,
48 p_timestamp IN DATE,
49 x_return_status OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE mark_dirty (
53 p_api_version_number IN NUMBER,
54 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
55 p_pub_item IN VARCHAR2,
56 p_accessList IN asg_download.access_list,
57 p_userid_list IN asg_download.user_list,
58 p_dml_type IN CHAR,
59 p_timestamp IN DATE,
60 x_return_status OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE mark_dirty (
64 p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
66 p_pub_item IN VARCHAR2,
67 p_accessid IN NUMBER,
68 p_userid IN NUMBER,
69 p_dml IN CHAR,
70 p_timestamp IN DATE,
71 x_return_status OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE mark_dirty (
75 p_api_version_number IN NUMBER,
76 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
77 p_pub_item IN VARCHAR2,
78 p_accessid IN NUMBER,
79 p_userid IN NUMBER,
80 p_dml IN CHAR,
81 p_timestamp IN DATE,
82 p_pkvalues IN asg_download.pk_list,
83 x_return_status OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE mark_dirty (
87 p_api_version_number IN NUMBER,
88 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
89 p_pub_item IN VARCHAR2,
90 p_accessList IN asg_download.access_list,
91 p_userid_list IN asg_download.user_list,
92 p_dml_type IN CHAR,
93 p_timestamp IN DATE,
94 p_bulk_flag IN BOOLEAN,
95 x_return_status OUT NOCOPY VARCHAR2
96 );
97
98 FUNCTION exec_cmd(pCmd in varchar2) RETURN VARCHAR2;
99 FUNCTION generate_where (collist in varchar2) RETURN VARCHAR2;
100 FUNCTION generate_query (collist in varchar2, cnt in number) RETURN VARCHAR2;
101 FUNCTION find_num_pkcols (pkcolumns in varchar2) RETURN number;
102 PROCEDURE log (p_mesg VARCHAR2);
103 FUNCTION get_col (col varchar2) RETURN VARCHAR2;
104
105 END ASG_CUSTOM_PVT;