[Home] [Help]
PACKAGE: APPS.AMS_LIST_QUERIES_PKG
Source
1 PACKAGE AMS_LIST_QUERIES_PKG AS
2 /* $Header: amstliqs.pls 120.3 2006/06/27 06:20:52 bmuthukr noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_LIST_QUERIES_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 PROCEDURE Insert_Row(
17 px_list_query_id IN OUT NOCOPY NUMBER,
18 p_last_update_date DATE,
19 p_last_updated_by NUMBER,
20 p_creation_date DATE,
21 p_created_by NUMBER,
22 p_last_update_login NUMBER,
23 px_object_version_number IN OUT NOCOPY NUMBER,
24 p_name VARCHAR2,
25 p_type VARCHAR2,
26 p_enabled_flag VARCHAR2,
27 p_primary_key VARCHAR2,
28 p_source_object_name VARCHAR2,
29 p_public_flag VARCHAR2,
30 px_org_id IN OUT NOCOPY NUMBER,
31 p_comments VARCHAR2,
32 p_act_list_query_used_by_id NUMBER,
33 p_arc_act_list_query_used_by VARCHAR2,
34 p_sql_string VARCHAR2,
35 p_parent_list_query_id number,
36 p_sequence_order in number);
37
38 PROCEDURE Update_Row(
39 p_list_query_id NUMBER,
40 p_last_update_date DATE,
41 p_last_updated_by NUMBER,
42 p_creation_date DATE,
43 p_created_by NUMBER,
44 p_last_update_login NUMBER,
45 p_object_version_number NUMBER,
46 p_name VARCHAR2,
47 p_type VARCHAR2,
48 p_enabled_flag VARCHAR2,
49 p_primary_key VARCHAR2,
50 p_source_object_name VARCHAR2,
51 p_public_flag VARCHAR2,
52 p_org_id NUMBER,
53 p_comments VARCHAR2,
54 p_act_list_query_used_by_id NUMBER,
55 p_arc_act_list_query_used_by VARCHAR2,
56 p_sql_string VARCHAR2,
57 p_parent_list_query_id number,
58 p_sequence_order in number);
59
60 PROCEDURE Delete_Row(
61 p_LIST_QUERY_ID NUMBER);
62 PROCEDURE Lock_Row(
63 p_list_query_id NUMBER,
64 p_last_update_date DATE,
65 p_last_updated_by NUMBER,
66 p_creation_date DATE,
67 p_created_by NUMBER,
68 p_last_update_login NUMBER,
69 p_object_version_number NUMBER,
70 p_name VARCHAR2,
71 p_type VARCHAR2,
72 p_enabled_flag VARCHAR2,
73 p_primary_key VARCHAR2,
74 p_source_object_name VARCHAR2,
75 p_public_flag VARCHAR2,
76 p_org_id NUMBER,
77 p_comments VARCHAR2,
78 p_act_list_query_used_by_id NUMBER,
79 p_arc_act_list_query_used_by VARCHAR2,
80 p_sql_string VARCHAR2,
81 p_parent_list_query_id number,
82 p_sequence_order in number);
83
84 PROCEDURE load_row(
85 p_owner varchar2,
86 p_list_query_id NUMBER,
87 p_last_update_date DATE,
88 p_last_updated_by NUMBER,
89 p_creation_date DATE,
90 p_created_by NUMBER,
91 p_last_update_login NUMBER,
92 p_object_version_number NUMBER,
93 p_name VARCHAR2,
94 p_type VARCHAR2,
95 p_enabled_flag VARCHAR2,
96 p_primary_key VARCHAR2,
97 p_source_object_name VARCHAR2,
98 p_public_flag VARCHAR2,
99 p_org_id NUMBER,
100 p_comments VARCHAR2,
101 p_act_list_query_used_by_id NUMBER,
102 p_arc_act_list_query_used_by VARCHAR2,
103 p_sql_string VARCHAR2,
104 p_custom_mode VARCHAR2
105 );
106
107 PROCEDURE ADD_LANGUAGE;
108
109 PROCEDURE translate_row(
110 p_list_query_id in number,
111 p_name in varchar2,
112 p_owner in varchar2,
113 p_custom_mode in varchar2
114 ) ;
115
116 END AMS_LIST_QUERIES_PKG;