[Home] [Help]
PACKAGE: APPS.PV_GQ_ELEMENTS_PKG
Source
1 PACKAGE PV_Gq_Elements_PKG AUTHID CURRENT_USER AS
2 /* $Header: pvxtgqes.pls 120.2 2006/07/27 19:05:15 saarumug noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Gq_Elements_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19
20
21
22 -- ========================================================
23 --
24 -- NAME
25 -- Insert_Row
26 --
27 -- PURPOSE
28 --
29 -- NOTES
30 --
31 -- HISTORY
32 --
33 -- ========================================================
34 PROCEDURE Insert_Row(
35 px_qsnr_element_id IN OUT NOCOPY NUMBER,
36 px_object_version_number IN OUT NOCOPY NUMBER,
37 p_arc_used_by_entity_code VARCHAR2,
38 p_used_by_entity_id NUMBER,
39 p_qsnr_elmt_seq_num NUMBER,
40 p_qsnr_elmt_type VARCHAR2,
41 p_entity_attr_id NUMBER,
42 p_qsnr_elmt_page_num NUMBER,
43 p_is_required_flag VARCHAR2,
44 p_created_by NUMBER,
45 p_creation_date DATE,
46 p_last_updated_by NUMBER,
47 p_last_update_date DATE,
48 p_last_update_login NUMBER,
49 p_elmt_content VARCHAR2
50 );
51
52
53
54
55
56 -- ========================================================
57 --
58 -- NAME
59 -- Update_Row
60 --
61 -- PURPOSE
62 --
63 -- NOTES
64 --
65 -- HISTORY
66 --
67 -- ========================================================
68 PROCEDURE Update_Row(
69 p_qsnr_element_id NUMBER,
70 px_object_version_number IN OUT NOCOPY NUMBER,
71 p_arc_used_by_entity_code VARCHAR2,
72 p_used_by_entity_id NUMBER,
73 p_qsnr_elmt_seq_num NUMBER,
74 p_qsnr_elmt_type VARCHAR2,
75 p_entity_attr_id NUMBER,
76 p_qsnr_elmt_page_num NUMBER,
77 p_is_required_flag VARCHAR2,
78 p_last_updated_by NUMBER,
79 p_last_update_date DATE,
80 p_last_update_login NUMBER,
81 p_elmt_content VARCHAR2
82 );
83
84
85
86
87
88 -- ========================================================
89 --
90 -- NAME
91 -- Delete_Row
92 --
93 -- PURPOSE
94 --
95 -- NOTES
96 --
97 -- HISTORY
98 --
99 -- ========================================================
100 PROCEDURE Delete_Row(
101 p_qsnr_element_id NUMBER,
102 p_object_version_number NUMBER);
103
104
105
106
107 -- ========================================================
108 --
109 -- NAME
110 -- Lock_Row
111 --
112 -- PURPOSE
113 --
114 -- NOTES
115 --
116 -- HISTORY
117 --
118 -- ========================================================
119 PROCEDURE Lock_Row(
120 p_qsnr_element_id NUMBER,
121 p_object_version_number NUMBER);
122
123 -- ==============================================================================
124 -- Start of Comments
125 -- ==============================================================================
126 -- API Name
127 -- add_language
128 -- Type
129 -- Private
130 -- History
131 --
132 -- NOTE
133 --
134 -- End of Comments
135 -- ===============================================================
136
137 PROCEDURE Add_Language;
138
139 -- ===========================================================================
140 -- THIS SECTION HAS BEEN ADDED TO SUPPORT THE CALL FROM JAV OA TL ENTITY IMPL.
141 -- IN OA THE OBJECT VERSION NUMBER IS HANDLED IN THE MIDDLE TIER WHEREAS IN THIS
142 -- TABLE HANDLER THE OBJECT VERSION NUMBER IS CHANGED IN THE PL/SQL PACKAGE.
143 -- SO THIS TABLE HANDLER CANNOT BE USED IN THE FORM THAT IT IS IN.
144 --
145 -- INSTEAD OF CREATING A NEW TABLE HANDLER THE PRODUCURES INSERT_ROW, UPDATE_ROW,
146 -- LOCK_ROW AND DELETE_ROW WILL BE OVERRIDDEN. A NEW SET OF SIGNATURES WILL BE
147 -- ADDED THAT ARE CONSISTANT WITH THE OA STANDARD FOR TABLE HANDLER IMPLEMENTATION
148 --
149 -- Bug 5400481
150 -- ======================================================================
151 procedure INSERT_ROW (
152 X_ROWID in out NOCOPY VARCHAR2,
153 X_QSNR_ELEMENT_ID in NUMBER,
154 X_OBJECT_VERSION_NUMBER in NUMBER,
155 X_ARC_USED_BY_ENTITY_CODE in VARCHAR2,
156 X_USED_BY_ENTITY_ID in NUMBER,
157 X_QSNR_ELMT_SEQ_NUM in NUMBER,
158 X_QSNR_ELMT_TYPE in VARCHAR2,
159 X_ENTITY_ATTR_ID in NUMBER,
160 X_QSNR_ELMT_PAGE_NUM in NUMBER,
161 X_IS_REQUIRED_FLAG in VARCHAR2,
162 X_ELMT_CONTENT in VARCHAR2,
163 X_CREATION_DATE in DATE,
164 X_CREATED_BY in NUMBER,
165 X_LAST_UPDATE_DATE in DATE,
166 X_LAST_UPDATED_BY in NUMBER,
167 X_LAST_UPDATE_LOGIN in NUMBER);
168 procedure LOCK_ROW (
169 X_QSNR_ELEMENT_ID in NUMBER,
170 X_OBJECT_VERSION_NUMBER in NUMBER,
171 X_ARC_USED_BY_ENTITY_CODE in VARCHAR2,
172 X_USED_BY_ENTITY_ID in NUMBER,
173 X_QSNR_ELMT_SEQ_NUM in NUMBER,
174 X_QSNR_ELMT_TYPE in VARCHAR2,
175 X_ENTITY_ATTR_ID in NUMBER,
176 X_QSNR_ELMT_PAGE_NUM in NUMBER,
177 X_IS_REQUIRED_FLAG in VARCHAR2,
178 X_ELMT_CONTENT in VARCHAR2
179 );
180 procedure UPDATE_ROW (
181 X_QSNR_ELEMENT_ID in NUMBER,
182 X_OBJECT_VERSION_NUMBER in NUMBER,
183 X_ARC_USED_BY_ENTITY_CODE in VARCHAR2,
184 X_USED_BY_ENTITY_ID in NUMBER,
185 X_QSNR_ELMT_SEQ_NUM in NUMBER,
186 X_QSNR_ELMT_TYPE in VARCHAR2,
187 X_ENTITY_ATTR_ID in NUMBER,
188 X_QSNR_ELMT_PAGE_NUM in NUMBER,
189 X_IS_REQUIRED_FLAG in VARCHAR2,
190 X_ELMT_CONTENT in VARCHAR2,
191 X_LAST_UPDATE_DATE in DATE,
192 X_LAST_UPDATED_BY in NUMBER,
193 X_LAST_UPDATE_LOGIN in NUMBER
194 );
195 procedure DELETE_ROW (
196 X_QSNR_ELEMENT_ID in NUMBER
197 );
198
199
200 END PV_Gq_Elements_PKG;