[Home] [Help]
PACKAGE: APPS.QP_MODIFIER_LIST_LINE_PVT
Source
1 PACKAGE QP_MODIFIER_LIST_LINE_PVT AUTHID CURRENT_USER as
2 /* $Header: QPXVMLLS.pls 115.0 99/10/14 18:54:21 porting ship $ */
3
4 PROCEDURE Insert_Row(
5 X_LIST_LINE_ID IN OUT NUMBER
6 , X_CREATION_DATE DATE
7 , X_CREATED_BY NUMBER
8 , X_LAST_UPDATE_DATE DATE
9 , X_LAST_UPDATED_BY NUMBER
10 , X_LAST_UPDATE_LOGIN NUMBER
11 , X_PROGRAM_APPLICATION_ID NUMBER
12 , X_PROGRAM_ID NUMBER
13 , X_PROGRAM_UPDATE_DATE DATE
14 , X_REQUEST_ID NUMBER
15 , X_LIST_HEADER_ID NUMBER
16 , X_LIST_LINE_TYPE_CODE VARCHAR2
17 , X_START_DATE_ACTIVE DATE
18 , X_END_DATE_ACTIVE DATE
19 , X_AUTOMATIC_FLAG VARCHAR2
20 , X_MODIFIER_LEVEL_CODE VARCHAR2
21 , X_LIST_PRICE NUMBER
22 , X_LIST_PRICE_UOM_CODE VARCHAR2
23 , X_PRIMARY_UOM_FLAG VARCHAR2
24 , X_INVENTORY_ITEM_ID NUMBER
25 , X_ORGANIZATION_ID NUMBER
26 , X_RELATED_ITEM_ID NUMBER
27 , X_RELATIONSHIP_TYPE_ID NUMBER
28 , X_SUBSTITUTION_CONTEXT VARCHAR2
29 , X_SUBSTITUTION_ATTRIBUTE VARCHAR2
30 , X_SUBSTITUTION_VALUE VARCHAR2
31 , X_REVISION VARCHAR2
32 , X_REVISION_DATE DATE
33 , X_REVISION_REASON_CODE VARCHAR2
34 , X_COMMENTS VARCHAR2
35 , X_CONTEXT VARCHAR2
36 , X_ATTRIBUTE1 VARCHAR2
37 , X_ATTRIBUTE2 VARCHAR2
38 , X_ATTRIBUTE3 VARCHAR2
39 , X_ATTRIBUTE4 VARCHAR2
40 , X_ATTRIBUTE5 VARCHAR2
41 , X_ATTRIBUTE6 VARCHAR2
42 , X_ATTRIBUTE7 VARCHAR2
43 , X_ATTRIBUTE8 VARCHAR2
44 , X_ATTRIBUTE9 VARCHAR2
45 , X_ATTRIBUTE10 VARCHAR2
46 , X_ATTRIBUTE11 VARCHAR2
47 , X_ATTRIBUTE12 VARCHAR2
48 , X_ATTRIBUTE13 VARCHAR2
49 , X_ATTRIBUTE14 VARCHAR2
50 , X_ATTRIBUTE15 VARCHAR2
51 ,X_PRICE_BREAK_TYPE_CODE VARCHAR2
52 , X_PERCENT_PRICE NUMBER
53 , X_PRICE_BY_FORMULA_ID NUMBER
54 , X_NUMBER_EFFECTIVE_PERIODS NUMBER
55 , X_EFFECTIVE_PERIOD_UOM VARCHAR2
56 , X_ARITHMETIC_OPERATOR VARCHAR2
57 , X_OPERAND NUMBER
58 , X_NEW_PRICE NUMBER
59 , X_OVERRIDE_FLAG VARCHAR2
60 , X_PRINT_ON_INVOICE_FLAG VARCHAR2
61 , X_GL_CLASS_ID NUMBER
62 , X_REBATE_TRANSACTION_TYPE_CODE VARCHAR2
63 , X_REBATE_SUBTYPE_CODE VARCHAR2
64 , X_BASE_QTY NUMBER
65 , X_BASE_UOM_CODE VARCHAR2
66 , X_ACCRUAL_TYPE_CODE VARCHAR2
67 , X_ACCRUAL_QTY NUMBER
68 , X_ACCRUAL_UOM_CODE VARCHAR2
69 , X_ESTIM_ACCRUAL_RATE NUMBER
70 , X_ACCUM_TO_ACCR_CONV_RATE NUMBER
71 , X_GENERATE_USING_FORMULA_ID NUMBER
72 );
73
74
75 PROCEDURE Lock_Row(
76 X_LIST_LINE_ID IN OUT NUMBER
77 , X_CREATION_DATE DATE
78 , X_CREATED_BY NUMBER
79 , X_LAST_UPDATE_DATE DATE
80 , X_LAST_UPDATED_BY NUMBER
81 , X_LAST_UPDATE_LOGIN NUMBER
82 , X_PROGRAM_APPLICATION_ID NUMBER
83 , X_PROGRAM_ID NUMBER
84 , X_PROGRAM_UPDATE_DATE DATE
85 , X_REQUEST_ID NUMBER
86 , X_LIST_HEADER_ID NUMBER
87 , X_LIST_LINE_TYPE_CODE VARCHAR2
88 , X_START_DATE_ACTIVE DATE
89 , X_END_DATE_ACTIVE DATE
90 , X_AUTOMATIC_FLAG VARCHAR2
91 , X_MODIFIER_LEVEL_CODE VARCHAR2
92 , X_LIST_PRICE NUMBER
93 , X_LIST_PRICE_UOM_CODE VARCHAR2
94 , X_PRIMARY_UOM_FLAG VARCHAR2
95 , X_INVENTORY_ITEM_ID NUMBER
96 , X_ORGANIZATION_ID NUMBER
97 , X_RELATED_ITEM_ID NUMBER
98 , X_RELATIONSHIP_TYPE_ID NUMBER
99 , X_SUBSTITUTION_CONTEXT VARCHAR2
100 , X_SUBSTITUTION_ATTRIBUTE VARCHAR2
101 , X_SUBSTITUTION_VALUE VARCHAR2
102 , X_REVISION VARCHAR2
103 , X_REVISION_DATE DATE
104 , X_REVISION_REASON_CODE VARCHAR2
105 , X_COMMENTS VARCHAR2
106 , X_CONTEXT VARCHAR2
107 , X_ATTRIBUTE1 VARCHAR2
108 , X_ATTRIBUTE2 VARCHAR2
109 , X_ATTRIBUTE3 VARCHAR2
110 , X_ATTRIBUTE4 VARCHAR2
111 , X_ATTRIBUTE5 VARCHAR2
112 , X_ATTRIBUTE6 VARCHAR2
113 , X_ATTRIBUTE7 VARCHAR2
114 , X_ATTRIBUTE8 VARCHAR2
115 , X_ATTRIBUTE9 VARCHAR2
116 , X_ATTRIBUTE10 VARCHAR2
117 , X_ATTRIBUTE11 VARCHAR2
118 , X_ATTRIBUTE12 VARCHAR2
119 , X_ATTRIBUTE13 VARCHAR2
120 , X_ATTRIBUTE14 VARCHAR2
121 , X_ATTRIBUTE15 VARCHAR2
122 ,X_PRICE_BREAK_TYPE_CODE VARCHAR2
123 , X_PERCENT_PRICE NUMBER
124 , X_PRICE_BY_FORMULA_ID NUMBER
125 , X_NUMBER_EFFECTIVE_PERIODS NUMBER
126 , X_EFFECTIVE_PERIOD_UOM VARCHAR2
127 , X_ARITHMETIC_OPERATOR VARCHAR2
128 , X_OPERAND NUMBER
129 , X_NEW_PRICE NUMBER
130 , X_OVERRIDE_FLAG VARCHAR2
131 , X_PRINT_ON_INVOICE_FLAG VARCHAR2
132 , X_GL_CLASS_ID NUMBER
133 , X_REBATE_TRANSACTION_TYPE_CODE VARCHAR2
134 , X_REBATE_SUBTYPE_CODE VARCHAR2
135 , X_BASE_QTY NUMBER
136 , X_BASE_UOM_CODE VARCHAR2
137 , X_ACCRUAL_TYPE_CODE VARCHAR2
138 , X_ACCRUAL_QTY NUMBER
139 , X_ACCRUAL_UOM_CODE VARCHAR2
140 , X_ESTIM_ACCRUAL_RATE NUMBER
141 , X_ACCUM_TO_ACCR_CONV_RATE NUMBER
142 , X_GENERATE_USING_FORMULA_ID NUMBER
143
144
145 );
146
147
148 PROCEDURE Update_Row(
149 X_LIST_LINE_ID IN OUT NUMBER
150 , X_CREATION_DATE DATE
151 , X_CREATED_BY NUMBER
152 , X_LAST_UPDATE_DATE DATE
153 , X_LAST_UPDATED_BY NUMBER
154 , X_LAST_UPDATE_LOGIN NUMBER
155 , X_PROGRAM_APPLICATION_ID NUMBER
156 , X_PROGRAM_ID NUMBER
157 , X_PROGRAM_UPDATE_DATE DATE
158 , X_REQUEST_ID NUMBER
159 , X_LIST_HEADER_ID NUMBER
160 , X_LIST_LINE_TYPE_CODE VARCHAR2
161 , X_START_DATE_ACTIVE DATE
162 , X_END_DATE_ACTIVE DATE
163 , X_AUTOMATIC_FLAG VARCHAR2
164 , X_MODIFIER_LEVEL_CODE VARCHAR2
165 , X_LIST_PRICE NUMBER
166 , X_LIST_PRICE_UOM_CODE VARCHAR2
167 , X_PRIMARY_UOM_FLAG VARCHAR2
168 , X_INVENTORY_ITEM_ID NUMBER
169 , X_ORGANIZATION_ID NUMBER
170 , X_RELATED_ITEM_ID NUMBER
171 , X_RELATIONSHIP_TYPE_ID NUMBER
172 , X_SUBSTITUTION_CONTEXT VARCHAR2
173 , X_SUBSTITUTION_ATTRIBUTE VARCHAR2
174 , X_SUBSTITUTION_VALUE VARCHAR2
175 , X_REVISION VARCHAR2
176 , X_REVISION_DATE DATE
177 , X_REVISION_REASON_CODE VARCHAR2
178 , X_COMMENTS VARCHAR2
179 , X_CONTEXT VARCHAR2
180 , X_ATTRIBUTE1 VARCHAR2
181 , X_ATTRIBUTE2 VARCHAR2
182 , X_ATTRIBUTE3 VARCHAR2
183 , X_ATTRIBUTE4 VARCHAR2
184 , X_ATTRIBUTE5 VARCHAR2
185 , X_ATTRIBUTE6 VARCHAR2
186 , X_ATTRIBUTE7 VARCHAR2
187 , X_ATTRIBUTE8 VARCHAR2
188 , X_ATTRIBUTE9 VARCHAR2
189 , X_ATTRIBUTE10 VARCHAR2
190 , X_ATTRIBUTE11 VARCHAR2
191 , X_ATTRIBUTE12 VARCHAR2
192 , X_ATTRIBUTE13 VARCHAR2
193 , X_ATTRIBUTE14 VARCHAR2
194 , X_ATTRIBUTE15 VARCHAR2
195 ,X_PRICE_BREAK_TYPE_CODE VARCHAR2
196 , X_PERCENT_PRICE NUMBER
197 , X_PRICE_BY_FORMULA_ID NUMBER
198 , X_NUMBER_EFFECTIVE_PERIODS NUMBER
199 , X_EFFECTIVE_PERIOD_UOM VARCHAR2
200 , X_ARITHMETIC_OPERATOR VARCHAR2
201 , X_OPERAND NUMBER
202 , X_NEW_PRICE NUMBER
203 , X_OVERRIDE_FLAG VARCHAR2
204 , X_PRINT_ON_INVOICE_FLAG VARCHAR2
205 , X_GL_CLASS_ID NUMBER
206 , X_REBATE_TRANSACTION_TYPE_CODE VARCHAR2
207 , X_REBATE_SUBTYPE_CODE VARCHAR2
208 , X_BASE_QTY NUMBER
209 , X_BASE_UOM_CODE VARCHAR2
210 , X_ACCRUAL_TYPE_CODE VARCHAR2
211 , X_ACCRUAL_QTY NUMBER
212 , X_ACCRUAL_UOM_CODE VARCHAR2
213 , X_ESTIM_ACCRUAL_RATE NUMBER
214 , X_ACCUM_TO_ACCR_CONV_RATE NUMBER
215 , X_GENERATE_USING_FORMULA_ID NUMBER
216
217 );
218
219 PROCEDURE Delete_Row(
220 X_LIST_LINE_ID NUMBER
221 );
222
223
224 END QP_MODIFIER_LIST_LINE_PVT;