APPS.QP_PRICE_LIST_LINE_UTIL dependencies on QP_PRICE_LIST_LINE_UTIL

Line 1: PACKAGE BODY QP_Price_List_Line_Util AS

1: PACKAGE BODY QP_Price_List_Line_Util AS
2: /* $Header: QPXUPLLB.pls 120.10.12010000.6 2009/12/15 05:35:59 hmohamme ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Price_List_Line_Util';

2: /* $Header: QPXUPLLB.pls 120.10.12010000.6 2009/12/15 05:35:59 hmohamme ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Price_List_Line_Util';
7: --introduced the constant for performance problem
8: G_ORGANIZATION_ID CONSTANT VARCHAR2(30) := TO_CHAR(QP_UTIL.Get_Item_Validation_Org);
9:
10: -- Procedure Clear_Dependent_Attr

Line 37: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_QTY;

33:
34: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_qty,p_old_PRICE_LIST_LINE_rec.accrual_qty)
35: THEN
36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_QTY;
38: END IF;
39:
40: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,p_old_PRICE_LIST_LINE_rec.accrual_uom_code)
41: THEN

Line 43: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;

39:
40: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,p_old_PRICE_LIST_LINE_rec.accrual_uom_code)
41: THEN
42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;
44: END IF;
45:
46: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator)
47: THEN

Line 49: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;

45:
46: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator)
47: THEN
48: l_index := l_index + 1;
49: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;
50: END IF;
51:
52: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,p_old_PRICE_LIST_LINE_rec.attribute1)
53: THEN

Line 55: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;

51:
52: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,p_old_PRICE_LIST_LINE_rec.attribute1)
53: THEN
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
56: END IF;
57:
58: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,p_old_PRICE_LIST_LINE_rec.attribute10)
59: THEN

Line 61: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;

57:
58: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,p_old_PRICE_LIST_LINE_rec.attribute10)
59: THEN
60: l_index := l_index + 1;
61: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
62: END IF;
63:
64: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,p_old_PRICE_LIST_LINE_rec.attribute11)
65: THEN

Line 67: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;

63:
64: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,p_old_PRICE_LIST_LINE_rec.attribute11)
65: THEN
66: l_index := l_index + 1;
67: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
68: END IF;
69:
70: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,p_old_PRICE_LIST_LINE_rec.attribute12)
71: THEN

Line 73: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;

69:
70: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,p_old_PRICE_LIST_LINE_rec.attribute12)
71: THEN
72: l_index := l_index + 1;
73: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
74: END IF;
75:
76: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,p_old_PRICE_LIST_LINE_rec.attribute13)
77: THEN

Line 79: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;

75:
76: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,p_old_PRICE_LIST_LINE_rec.attribute13)
77: THEN
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
80: END IF;
81:
82: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,p_old_PRICE_LIST_LINE_rec.attribute14)
83: THEN

Line 85: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;

81:
82: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,p_old_PRICE_LIST_LINE_rec.attribute14)
83: THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
86: END IF;
87:
88: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,p_old_PRICE_LIST_LINE_rec.attribute15)
89: THEN

Line 91: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;

87:
88: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,p_old_PRICE_LIST_LINE_rec.attribute15)
89: THEN
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
92: END IF;
93:
94: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,p_old_PRICE_LIST_LINE_rec.attribute2)
95: THEN

Line 97: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;

93:
94: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,p_old_PRICE_LIST_LINE_rec.attribute2)
95: THEN
96: l_index := l_index + 1;
97: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
98: END IF;
99:
100: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,p_old_PRICE_LIST_LINE_rec.attribute3)
101: THEN

Line 103: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;

99:
100: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,p_old_PRICE_LIST_LINE_rec.attribute3)
101: THEN
102: l_index := l_index + 1;
103: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
104: END IF;
105:
106: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,p_old_PRICE_LIST_LINE_rec.attribute4)
107: THEN

Line 109: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;

105:
106: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,p_old_PRICE_LIST_LINE_rec.attribute4)
107: THEN
108: l_index := l_index + 1;
109: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
110: END IF;
111:
112: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,p_old_PRICE_LIST_LINE_rec.attribute5)
113: THEN

Line 115: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;

111:
112: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,p_old_PRICE_LIST_LINE_rec.attribute5)
113: THEN
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
116: END IF;
117:
118: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,p_old_PRICE_LIST_LINE_rec.attribute6)
119: THEN

Line 121: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;

117:
118: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,p_old_PRICE_LIST_LINE_rec.attribute6)
119: THEN
120: l_index := l_index + 1;
121: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
122: END IF;
123:
124: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,p_old_PRICE_LIST_LINE_rec.attribute7)
125: THEN

Line 127: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;

123:
124: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,p_old_PRICE_LIST_LINE_rec.attribute7)
125: THEN
126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
128: END IF;
129:
130: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,p_old_PRICE_LIST_LINE_rec.attribute8)
131: THEN

Line 133: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;

129:
130: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,p_old_PRICE_LIST_LINE_rec.attribute8)
131: THEN
132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
134: END IF;
135:
136: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,p_old_PRICE_LIST_LINE_rec.attribute9)
137: THEN

Line 139: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;

135:
136: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,p_old_PRICE_LIST_LINE_rec.attribute9)
137: THEN
138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
140: END IF;
141:
142: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,p_old_PRICE_LIST_LINE_rec.automatic_flag)
143: THEN

Line 145: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;

141:
142: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,p_old_PRICE_LIST_LINE_rec.automatic_flag)
143: THEN
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;
146: END IF;
147:
148: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,p_old_PRICE_LIST_LINE_rec.base_qty)
149: THEN

Line 151: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;

147:
148: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,p_old_PRICE_LIST_LINE_rec.base_qty)
149: THEN
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;
152: END IF;
153:
154: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,p_old_PRICE_LIST_LINE_rec.base_uom_code)
155: THEN

Line 157: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;

153:
154: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,p_old_PRICE_LIST_LINE_rec.base_uom_code)
155: THEN
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;
158: END IF;
159:
160: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,p_old_PRICE_LIST_LINE_rec.comments)
161: THEN

Line 163: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;

159:
160: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,p_old_PRICE_LIST_LINE_rec.comments)
161: THEN
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;
164: END IF;
165:
166: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,p_old_PRICE_LIST_LINE_rec.context)
167: THEN

Line 169: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;

165:
166: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,p_old_PRICE_LIST_LINE_rec.context)
167: THEN
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;
170: END IF;
171:
172: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,p_old_PRICE_LIST_LINE_rec.created_by)
173: THEN

Line 175: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;

171:
172: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,p_old_PRICE_LIST_LINE_rec.created_by)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
176: END IF;
177:
178: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.creation_date,p_old_PRICE_LIST_LINE_rec.creation_date)
179: THEN

Line 181: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;

177:
178: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.creation_date,p_old_PRICE_LIST_LINE_rec.creation_date)
179: THEN
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
182: END IF;
183:
184: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,p_old_PRICE_LIST_LINE_rec.effective_period_uom)
185: THEN

Line 187: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;

183:
184: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,p_old_PRICE_LIST_LINE_rec.effective_period_uom)
185: THEN
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;
188: END IF;
189:
190: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.end_date_active,p_old_PRICE_LIST_LINE_rec.end_date_active)
191: THEN

Line 193: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;

189:
190: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.end_date_active,p_old_PRICE_LIST_LINE_rec.end_date_active)
191: THEN
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
194: END IF;
195:
196: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,p_old_PRICE_LIST_LINE_rec.estim_accrual_rate)
197: THEN

Line 199: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;

195:
196: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,p_old_PRICE_LIST_LINE_rec.estim_accrual_rate)
197: THEN
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;
200: END IF;
201:
202: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,p_old_PRICE_LIST_LINE_rec.generate_using_formula_id)
203: THEN

Line 205: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;

201:
202: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,p_old_PRICE_LIST_LINE_rec.generate_using_formula_id)
203: THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;
206: END IF;
207:
208: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,p_old_PRICE_LIST_LINE_rec.inventory_item_id)
209: THEN

Line 211: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;

207:
208: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,p_old_PRICE_LIST_LINE_rec.inventory_item_id)
209: THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
212: END IF;
213:
214: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,p_old_PRICE_LIST_LINE_rec.last_updated_by)
215: THEN

Line 217: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;

213:
214: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,p_old_PRICE_LIST_LINE_rec.last_updated_by)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_date,p_old_PRICE_LIST_LINE_rec.last_update_date)
221: THEN

Line 223: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;

219:
220: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_date,p_old_PRICE_LIST_LINE_rec.last_update_date)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
224: END IF;
225:
226: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,p_old_PRICE_LIST_LINE_rec.last_update_login)
227: THEN

Line 229: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;

225:
226: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,p_old_PRICE_LIST_LINE_rec.last_update_login)
227: THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
230: END IF;
231:
232: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,p_old_PRICE_LIST_LINE_rec.list_header_id)
233: THEN

Line 235: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;

231:
232: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,p_old_PRICE_LIST_LINE_rec.list_header_id)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;
236: END IF;
237:
238: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,p_old_PRICE_LIST_LINE_rec.list_line_id)
239: THEN

Line 241: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;

237:
238: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,p_old_PRICE_LIST_LINE_rec.list_line_id)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;
242: END IF;
243:
244: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,p_old_PRICE_LIST_LINE_rec.list_line_type_code)
245: THEN

Line 247: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;

243:
244: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,p_old_PRICE_LIST_LINE_rec.list_line_type_code)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;
248: END IF;
249:
250: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,p_old_PRICE_LIST_LINE_rec.list_price)
251: THEN

Line 253: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;

249:
250: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,p_old_PRICE_LIST_LINE_rec.list_price)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
254: END IF;
255:
256: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.from_rltd_modifier_id,p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id)
257: THEN

Line 259: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;

255:
256: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.from_rltd_modifier_id,p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;
260: END IF;
261:
262: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rltd_modifier_group_no,p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no)
263: THEN

Line 265: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;

261:
262: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rltd_modifier_group_no,p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no)
263: THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;
266: END IF;
267:
268: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,p_old_PRICE_LIST_LINE_rec.product_precedence)
269: THEN

Line 271: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;

267:
268: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,p_old_PRICE_LIST_LINE_rec.product_precedence)
269: THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;
272: END IF;
273:
274:
275: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,p_old_PRICE_LIST_LINE_rec.modifier_level_code)

Line 278: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;

274:
275: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,p_old_PRICE_LIST_LINE_rec.modifier_level_code)
276: THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;
279: END IF;
280:
281: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,p_old_PRICE_LIST_LINE_rec.number_effective_periods)
282: THEN

Line 284: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;

280:
281: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,p_old_PRICE_LIST_LINE_rec.number_effective_periods)
282: THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
285: END IF;
286:
287: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,p_old_PRICE_LIST_LINE_rec.operand)
288: THEN

Line 290: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;

286:
287: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,p_old_PRICE_LIST_LINE_rec.operand)
288: THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;
291: END IF;
292:
293: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,p_old_PRICE_LIST_LINE_rec.organization_id)
294: THEN

Line 296: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;

292:
293: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,p_old_PRICE_LIST_LINE_rec.organization_id)
294: THEN
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;
297: END IF;
298:
299: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,p_old_PRICE_LIST_LINE_rec.override_flag)
300: THEN

Line 302: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;

298:
299: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,p_old_PRICE_LIST_LINE_rec.override_flag)
300: THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;
303: END IF;
304:
305: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,p_old_PRICE_LIST_LINE_rec.percent_price)
306: THEN

Line 308: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;

304:
305: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,p_old_PRICE_LIST_LINE_rec.percent_price)
306: THEN
307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;
309: END IF;
310:
311: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,p_old_PRICE_LIST_LINE_rec.price_break_type_code)
312: THEN

Line 314: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;

310:
311: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,p_old_PRICE_LIST_LINE_rec.price_break_type_code)
312: THEN
313: l_index := l_index + 1;
314: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;
315: END IF;
316:
317: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
318: THEN

Line 320: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;

316:
317: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
318: THEN
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;
321: END IF;
322:
323: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,p_old_PRICE_LIST_LINE_rec.primary_uom_flag)
324: THEN

Line 326: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;

322:
323: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,p_old_PRICE_LIST_LINE_rec.primary_uom_flag)
324: THEN
325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;
327: END IF;
328:
329: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag,p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag)
330: THEN

Line 332: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;

328:
329: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag,p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag)
330: THEN
331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;
333: END IF;
334:
335: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,p_old_PRICE_LIST_LINE_rec.program_application_id)
336: THEN

Line 338: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;

334:
335: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,p_old_PRICE_LIST_LINE_rec.program_application_id)
336: THEN
337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
339: END IF;
340:
341: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,p_old_PRICE_LIST_LINE_rec.program_id)
342: THEN

Line 344: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;

340:
341: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,p_old_PRICE_LIST_LINE_rec.program_id)
342: THEN
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;
345: END IF;
346:
347: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_update_date,p_old_PRICE_LIST_LINE_rec.program_update_date)
348: THEN

Line 350: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;

346:
347: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_update_date,p_old_PRICE_LIST_LINE_rec.program_update_date)
348: THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
351: END IF;
352:
353: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
354: THEN

Line 356: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;

352:
353: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
354: THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;
357: END IF;
358:
359: -- block pricing
360: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value, p_old_PRICE_LIST_LINE_rec.recurring_value)

Line 363: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;

359: -- block pricing
360: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value, p_old_PRICE_LIST_LINE_rec.recurring_value)
361: THEN
362: l_index := l_index+1;
363: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;
364: END IF;
365:
366: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,p_old_PRICE_LIST_LINE_rec.related_item_id)
367: THEN

Line 369: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;

365:
366: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,p_old_PRICE_LIST_LINE_rec.related_item_id)
367: THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;
370: END IF;
371:
372: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,p_old_PRICE_LIST_LINE_rec.relationship_type_id)
373: THEN

Line 375: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;

371:
372: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,p_old_PRICE_LIST_LINE_rec.relationship_type_id)
373: THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;
376: END IF;
377:
378: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,p_old_PRICE_LIST_LINE_rec.reprice_flag)
379: THEN

Line 381: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;

377:
378: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,p_old_PRICE_LIST_LINE_rec.reprice_flag)
379: THEN
380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;
382: END IF;
383:
384: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,p_old_PRICE_LIST_LINE_rec.request_id)
385: THEN

Line 387: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;

383:
384: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,p_old_PRICE_LIST_LINE_rec.request_id)
385: THEN
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;
388: END IF;
389:
390: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,p_old_PRICE_LIST_LINE_rec.revision)
391: THEN

Line 393: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;

389:
390: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,p_old_PRICE_LIST_LINE_rec.revision)
391: THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;
394: END IF;
395:
396: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_date,p_old_PRICE_LIST_LINE_rec.revision_date)
397: THEN

Line 399: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;

395:
396: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_date,p_old_PRICE_LIST_LINE_rec.revision_date)
397: THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
400: END IF;
401:
402: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,p_old_PRICE_LIST_LINE_rec.revision_reason_code)
403: THEN

Line 405: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;

401:
402: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,p_old_PRICE_LIST_LINE_rec.revision_reason_code)
403: THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
406: END IF;
407:
408: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.start_date_active,p_old_PRICE_LIST_LINE_rec.start_date_active)
409: THEN

Line 411: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;

407:
408: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.start_date_active,p_old_PRICE_LIST_LINE_rec.start_date_active)
409: THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
412: END IF;
413:
414: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,p_old_PRICE_LIST_LINE_rec.substitution_attribute)
415: THEN

Line 417: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;

413:
414: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,p_old_PRICE_LIST_LINE_rec.substitution_attribute)
415: THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;
418: END IF;
419:
420: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,p_old_PRICE_LIST_LINE_rec.substitution_context)
421: THEN

Line 423: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;

419:
420: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,p_old_PRICE_LIST_LINE_rec.substitution_context)
421: THEN
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;
424: END IF;
425:
426: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,p_old_PRICE_LIST_LINE_rec.substitution_value)
427: THEN

Line 429: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;

425:
426: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,p_old_PRICE_LIST_LINE_rec.substitution_value)
427: THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;
430: END IF;
431:
432: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id, p_old_PRICE_LIST_LINE_rec.customer_item_id)
433: THEN

Line 435: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM_ID;

431:
432: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id, p_old_PRICE_LIST_LINE_rec.customer_item_id)
433: THEN
434: l_index := l_index + 1;
435: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM_ID;
436: END IF;
437:
438: ELSIF p_attr_id = G_ACCRUAL_QTY THEN
439: l_index := l_index + 1;

Line 440: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_QTY;

436: END IF;
437:
438: ELSIF p_attr_id = G_ACCRUAL_QTY THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_QTY;
441: ELSIF p_attr_id = G_ACCRUAL_UOM THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;
444: ELSIF p_attr_id = G_ARITHMETIC_OPERATOR THEN

Line 443: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;

439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_QTY;
441: ELSIF p_attr_id = G_ACCRUAL_UOM THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;
444: ELSIF p_attr_id = G_ARITHMETIC_OPERATOR THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;
447: ELSIF p_attr_id = G_ATTRIBUTE1 THEN

Line 446: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;

442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;
444: ELSIF p_attr_id = G_ARITHMETIC_OPERATOR THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;
447: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
448: l_index := l_index + 1;
449: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
450: ELSIF p_attr_id = G_ATTRIBUTE10 THEN

Line 449: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;

445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;
447: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
448: l_index := l_index + 1;
449: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
450: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
451: l_index := l_index + 1;
452: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
453: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 452: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;

448: l_index := l_index + 1;
449: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
450: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
451: l_index := l_index + 1;
452: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
453: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
456: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 455: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;

451: l_index := l_index + 1;
452: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
453: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
456: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
459: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 458: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;

454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
456: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
459: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
462: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 461: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;

457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
459: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
462: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
465: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 464: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;

460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
462: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
465: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
468: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 467: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;

463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
465: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
468: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
471: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 470: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;

466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
468: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
471: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
472: l_index := l_index + 1;
473: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
474: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 473: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;

469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
471: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
472: l_index := l_index + 1;
473: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
474: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
477: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 476: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;

472: l_index := l_index + 1;
473: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
474: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
477: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
478: l_index := l_index + 1;
479: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
480: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 479: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;

475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
477: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
478: l_index := l_index + 1;
479: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
480: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
483: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 482: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;

478: l_index := l_index + 1;
479: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
480: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
483: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
484: l_index := l_index + 1;
485: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
486: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 485: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;

481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
483: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
484: l_index := l_index + 1;
485: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
486: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
489: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 488: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;

484: l_index := l_index + 1;
485: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
486: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
489: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
490: l_index := l_index + 1;
491: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
492: ELSIF p_attr_id = G_AUTOMATIC THEN

Line 491: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;

487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
489: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
490: l_index := l_index + 1;
491: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
492: ELSIF p_attr_id = G_AUTOMATIC THEN
493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;
495: ELSIF p_attr_id = G_BASE_QTY THEN

Line 494: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;

490: l_index := l_index + 1;
491: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
492: ELSIF p_attr_id = G_AUTOMATIC THEN
493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;
495: ELSIF p_attr_id = G_BASE_QTY THEN
496: l_index := l_index + 1;
497: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;
498: ELSIF p_attr_id = G_BASE_UOM THEN

Line 497: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;

493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;
495: ELSIF p_attr_id = G_BASE_QTY THEN
496: l_index := l_index + 1;
497: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;
498: ELSIF p_attr_id = G_BASE_UOM THEN
499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;
501: ELSIF p_attr_id = G_COMMENTS THEN

Line 500: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;

496: l_index := l_index + 1;
497: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;
498: ELSIF p_attr_id = G_BASE_UOM THEN
499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;
501: ELSIF p_attr_id = G_COMMENTS THEN
502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;
504: ELSIF p_attr_id = G_CONTEXT THEN

Line 503: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;

499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;
501: ELSIF p_attr_id = G_COMMENTS THEN
502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;
504: ELSIF p_attr_id = G_CONTEXT THEN
505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;
507: ELSIF p_attr_id = G_CREATED_BY THEN

Line 506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;

502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;
504: ELSIF p_attr_id = G_CONTEXT THEN
505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;
507: ELSIF p_attr_id = G_CREATED_BY THEN
508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
510: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;

505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;
507: ELSIF p_attr_id = G_CREATED_BY THEN
508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
510: ELSIF p_attr_id = G_CREATION_DATE THEN
511: l_index := l_index + 1;
512: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
513: ELSIF p_attr_id = G_EFFECTIVE_PERIOD_UOM THEN

Line 512: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;

508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
510: ELSIF p_attr_id = G_CREATION_DATE THEN
511: l_index := l_index + 1;
512: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
513: ELSIF p_attr_id = G_EFFECTIVE_PERIOD_UOM THEN
514: l_index := l_index + 1;
515: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;
516: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN

Line 515: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;

511: l_index := l_index + 1;
512: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
513: ELSIF p_attr_id = G_EFFECTIVE_PERIOD_UOM THEN
514: l_index := l_index + 1;
515: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;
516: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
517: l_index := l_index + 1;
518: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
519: ELSIF p_attr_id = G_ESTIM_ACCRUAL_RATE THEN

Line 518: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;

514: l_index := l_index + 1;
515: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;
516: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
517: l_index := l_index + 1;
518: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
519: ELSIF p_attr_id = G_ESTIM_ACCRUAL_RATE THEN
520: l_index := l_index + 1;
521: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;
522: ELSIF p_attr_id = G_GENERATE_USING_FORMULA THEN

Line 521: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;

517: l_index := l_index + 1;
518: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
519: ELSIF p_attr_id = G_ESTIM_ACCRUAL_RATE THEN
520: l_index := l_index + 1;
521: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;
522: ELSIF p_attr_id = G_GENERATE_USING_FORMULA THEN
523: l_index := l_index + 1;
524: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;
525: ELSIF p_attr_id = G_INVENTORY_ITEM THEN

Line 524: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;

520: l_index := l_index + 1;
521: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;
522: ELSIF p_attr_id = G_GENERATE_USING_FORMULA THEN
523: l_index := l_index + 1;
524: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;
525: ELSIF p_attr_id = G_INVENTORY_ITEM THEN
526: l_index := l_index + 1;
527: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
528: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 527: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;

523: l_index := l_index + 1;
524: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;
525: ELSIF p_attr_id = G_INVENTORY_ITEM THEN
526: l_index := l_index + 1;
527: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
528: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
529: l_index := l_index + 1;
530: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
531: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 530: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;

526: l_index := l_index + 1;
527: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
528: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
529: l_index := l_index + 1;
530: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
531: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
532: l_index := l_index + 1;
533: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
534: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 533: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;

529: l_index := l_index + 1;
530: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
531: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
532: l_index := l_index + 1;
533: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
534: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
535: l_index := l_index + 1;
536: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
537: ELSIF p_attr_id = G_LIST_HEADER THEN

Line 536: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;

532: l_index := l_index + 1;
533: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
534: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
535: l_index := l_index + 1;
536: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
537: ELSIF p_attr_id = G_LIST_HEADER THEN
538: l_index := l_index + 1;
539: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;
540: ELSIF p_attr_id = G_LIST_LINE THEN

Line 539: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;

535: l_index := l_index + 1;
536: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
537: ELSIF p_attr_id = G_LIST_HEADER THEN
538: l_index := l_index + 1;
539: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;
540: ELSIF p_attr_id = G_LIST_LINE THEN
541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;
543: ELSIF p_attr_id = G_LIST_LINE_TYPE THEN

Line 542: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;

538: l_index := l_index + 1;
539: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;
540: ELSIF p_attr_id = G_LIST_LINE THEN
541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;
543: ELSIF p_attr_id = G_LIST_LINE_TYPE THEN
544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;
546: ELSIF p_attr_id = G_LIST_PRICE THEN

Line 545: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;

541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;
543: ELSIF p_attr_id = G_LIST_LINE_TYPE THEN
544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;
546: ELSIF p_attr_id = G_LIST_PRICE THEN
547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
549: ELSIF p_attr_id = G_FROM_RLTD_MODIFIER THEN

Line 548: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;

544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;
546: ELSIF p_attr_id = G_LIST_PRICE THEN
547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
549: ELSIF p_attr_id = G_FROM_RLTD_MODIFIER THEN
550: l_index := l_index + 1;
551: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;
552: ELSIF p_attr_id = G_RLTD_MODIFIER_GROUP_NO THEN

Line 551: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;

547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
549: ELSIF p_attr_id = G_FROM_RLTD_MODIFIER THEN
550: l_index := l_index + 1;
551: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;
552: ELSIF p_attr_id = G_RLTD_MODIFIER_GROUP_NO THEN
553: l_index := l_index + 1;
554: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;
555: ELSIF p_attr_id = G_PRODUCT_PRECEDENCE THEN

Line 554: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;

550: l_index := l_index + 1;
551: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;
552: ELSIF p_attr_id = G_RLTD_MODIFIER_GROUP_NO THEN
553: l_index := l_index + 1;
554: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;
555: ELSIF p_attr_id = G_PRODUCT_PRECEDENCE THEN
556: l_index := l_index + 1;
557: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;
558: ELSIF p_attr_id = G_MODIFIER_LEVEL THEN

Line 557: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;

553: l_index := l_index + 1;
554: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;
555: ELSIF p_attr_id = G_PRODUCT_PRECEDENCE THEN
556: l_index := l_index + 1;
557: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;
558: ELSIF p_attr_id = G_MODIFIER_LEVEL THEN
559: l_index := l_index + 1;
560: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;
561: ELSIF p_attr_id = G_NUMBER_EFFECTIVE_PERIODS THEN

Line 560: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;

556: l_index := l_index + 1;
557: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;
558: ELSIF p_attr_id = G_MODIFIER_LEVEL THEN
559: l_index := l_index + 1;
560: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;
561: ELSIF p_attr_id = G_NUMBER_EFFECTIVE_PERIODS THEN
562: l_index := l_index + 1;
563: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
564: ELSIF p_attr_id = G_OPERAND THEN

Line 563: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;

559: l_index := l_index + 1;
560: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;
561: ELSIF p_attr_id = G_NUMBER_EFFECTIVE_PERIODS THEN
562: l_index := l_index + 1;
563: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
564: ELSIF p_attr_id = G_OPERAND THEN
565: l_index := l_index + 1;
566: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;
567: ELSIF p_attr_id = G_ORGANIZATION THEN

Line 566: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;

562: l_index := l_index + 1;
563: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
564: ELSIF p_attr_id = G_OPERAND THEN
565: l_index := l_index + 1;
566: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;
567: ELSIF p_attr_id = G_ORGANIZATION THEN
568: l_index := l_index + 1;
569: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;
570: ELSIF p_attr_id = G_OVERRIDE THEN

Line 569: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;

565: l_index := l_index + 1;
566: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;
567: ELSIF p_attr_id = G_ORGANIZATION THEN
568: l_index := l_index + 1;
569: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;
570: ELSIF p_attr_id = G_OVERRIDE THEN
571: l_index := l_index + 1;
572: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;
573: ELSIF p_attr_id = G_PERCENT_PRICE THEN

Line 572: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;

568: l_index := l_index + 1;
569: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;
570: ELSIF p_attr_id = G_OVERRIDE THEN
571: l_index := l_index + 1;
572: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;
573: ELSIF p_attr_id = G_PERCENT_PRICE THEN
574: l_index := l_index + 1;
575: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;
576: ELSIF p_attr_id = G_PRICE_BREAK_TYPE THEN

Line 575: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;

571: l_index := l_index + 1;
572: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;
573: ELSIF p_attr_id = G_PERCENT_PRICE THEN
574: l_index := l_index + 1;
575: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;
576: ELSIF p_attr_id = G_PRICE_BREAK_TYPE THEN
577: l_index := l_index + 1;
578: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;
579: ELSIF p_attr_id = G_PRICE_BY_FORMULA THEN

Line 578: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;

574: l_index := l_index + 1;
575: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;
576: ELSIF p_attr_id = G_PRICE_BREAK_TYPE THEN
577: l_index := l_index + 1;
578: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;
579: ELSIF p_attr_id = G_PRICE_BY_FORMULA THEN
580: l_index := l_index + 1;
581: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;
582: ELSIF p_attr_id = G_PRIMARY_UOM THEN

Line 581: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;

577: l_index := l_index + 1;
578: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;
579: ELSIF p_attr_id = G_PRICE_BY_FORMULA THEN
580: l_index := l_index + 1;
581: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;
582: ELSIF p_attr_id = G_PRIMARY_UOM THEN
583: l_index := l_index + 1;
584: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;
585: ELSIF p_attr_id = G_PRINT_ON_INVOICE THEN

Line 584: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;

580: l_index := l_index + 1;
581: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;
582: ELSIF p_attr_id = G_PRIMARY_UOM THEN
583: l_index := l_index + 1;
584: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;
585: ELSIF p_attr_id = G_PRINT_ON_INVOICE THEN
586: l_index := l_index + 1;
587: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;
588: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 587: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;

583: l_index := l_index + 1;
584: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;
585: ELSIF p_attr_id = G_PRINT_ON_INVOICE THEN
586: l_index := l_index + 1;
587: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;
588: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
589: l_index := l_index + 1;
590: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
591: ELSIF p_attr_id = G_PROGRAM THEN

Line 590: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;

586: l_index := l_index + 1;
587: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;
588: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
589: l_index := l_index + 1;
590: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
591: ELSIF p_attr_id = G_PROGRAM THEN
592: l_index := l_index + 1;
593: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;
594: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 593: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;

589: l_index := l_index + 1;
590: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
591: ELSIF p_attr_id = G_PROGRAM THEN
592: l_index := l_index + 1;
593: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;
594: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
595: l_index := l_index + 1;
596: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
597: ELSIF p_attr_id = G_REBATE_TRANSACTION_TYPE THEN

Line 596: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;

592: l_index := l_index + 1;
593: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;
594: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
595: l_index := l_index + 1;
596: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
597: ELSIF p_attr_id = G_REBATE_TRANSACTION_TYPE THEN
598: l_index := l_index + 1;
599: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;
600: -- block pricing

Line 599: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;

595: l_index := l_index + 1;
596: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
597: ELSIF p_attr_id = G_REBATE_TRANSACTION_TYPE THEN
598: l_index := l_index + 1;
599: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;
600: -- block pricing
601: ELSIF p_attr_id = G_RECURRING_VALUE THEN
602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;

Line 603: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;

599: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;
600: -- block pricing
601: ELSIF p_attr_id = G_RECURRING_VALUE THEN
602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;
604: ELSIF p_attr_id = G_RELATED_ITEM THEN
605: l_index := l_index + 1;
606: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;
607: ELSIF p_attr_id = G_RELATIONSHIP_TYPE THEN

Line 606: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;

602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;
604: ELSIF p_attr_id = G_RELATED_ITEM THEN
605: l_index := l_index + 1;
606: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;
607: ELSIF p_attr_id = G_RELATIONSHIP_TYPE THEN
608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;
610: ELSIF p_attr_id = G_REPRICE THEN

Line 609: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;

605: l_index := l_index + 1;
606: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;
607: ELSIF p_attr_id = G_RELATIONSHIP_TYPE THEN
608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;
610: ELSIF p_attr_id = G_REPRICE THEN
611: l_index := l_index + 1;
612: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;
613: ELSIF p_attr_id = G_REQUEST THEN

Line 612: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;

608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;
610: ELSIF p_attr_id = G_REPRICE THEN
611: l_index := l_index + 1;
612: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;
613: ELSIF p_attr_id = G_REQUEST THEN
614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;
616: ELSIF p_attr_id = G_REVISION THEN

Line 615: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;

611: l_index := l_index + 1;
612: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;
613: ELSIF p_attr_id = G_REQUEST THEN
614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;
616: ELSIF p_attr_id = G_REVISION THEN
617: l_index := l_index + 1;
618: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;
619: ELSIF p_attr_id = G_REVISION_DATE THEN

Line 618: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;

614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;
616: ELSIF p_attr_id = G_REVISION THEN
617: l_index := l_index + 1;
618: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;
619: ELSIF p_attr_id = G_REVISION_DATE THEN
620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
622: ELSIF p_attr_id = G_REVISION_REASON THEN

Line 621: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;

617: l_index := l_index + 1;
618: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;
619: ELSIF p_attr_id = G_REVISION_DATE THEN
620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
622: ELSIF p_attr_id = G_REVISION_REASON THEN
623: l_index := l_index + 1;
624: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
625: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN

Line 624: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;

620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
622: ELSIF p_attr_id = G_REVISION_REASON THEN
623: l_index := l_index + 1;
624: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
625: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
628: ELSIF p_attr_id = G_SUBSTITUTION_ATTRIBUTE THEN

Line 627: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;

623: l_index := l_index + 1;
624: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
625: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
628: ELSIF p_attr_id = G_SUBSTITUTION_ATTRIBUTE THEN
629: l_index := l_index + 1;
630: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;
631: ELSIF p_attr_id = G_SUBSTITUTION_CONTEXT THEN

Line 630: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;

626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
628: ELSIF p_attr_id = G_SUBSTITUTION_ATTRIBUTE THEN
629: l_index := l_index + 1;
630: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;
631: ELSIF p_attr_id = G_SUBSTITUTION_CONTEXT THEN
632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;
634: ELSIF p_attr_id = G_SUBSTITUTION_VALUE THEN

Line 633: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;

629: l_index := l_index + 1;
630: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;
631: ELSIF p_attr_id = G_SUBSTITUTION_CONTEXT THEN
632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;
634: ELSIF p_attr_id = G_SUBSTITUTION_VALUE THEN
635: l_index := l_index + 1;
636: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;
637: ELSIF p_attr_id = G_CUSTOMER_ITEM_ID THEN

Line 636: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;

632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;
634: ELSIF p_attr_id = G_SUBSTITUTION_VALUE THEN
635: l_index := l_index + 1;
636: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;
637: ELSIF p_attr_id = G_CUSTOMER_ITEM_ID THEN
638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM_ID;
640: ELSIF p_attr_id = G_BREAK_UOM_CODE THEN

Line 639: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM_ID;

635: l_index := l_index + 1;
636: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;
637: ELSIF p_attr_id = G_CUSTOMER_ITEM_ID THEN
638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM_ID;
640: ELSIF p_attr_id = G_BREAK_UOM_CODE THEN
641: l_index := l_index + 1;
642: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CODE;
643: ELSIF p_attr_id = G_BREAK_UOM_CONTEXT THEN

Line 642: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CODE;

638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM_ID;
640: ELSIF p_attr_id = G_BREAK_UOM_CODE THEN
641: l_index := l_index + 1;
642: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CODE;
643: ELSIF p_attr_id = G_BREAK_UOM_CONTEXT THEN
644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CONTEXT;
646: ELSIF p_attr_id = G_BREAK_UOM_ATTRIBUTE THEN

Line 645: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CONTEXT;

641: l_index := l_index + 1;
642: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CODE;
643: ELSIF p_attr_id = G_BREAK_UOM_CONTEXT THEN
644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CONTEXT;
646: ELSIF p_attr_id = G_BREAK_UOM_ATTRIBUTE THEN
647: l_index := l_index + 1;
648: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_ATTRIBUTE;
649: ELSIF p_attr_id = G_CONTINUOUS_PRICE_BREAK_FLAG THEN

Line 648: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_ATTRIBUTE;

644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_CONTEXT;
646: ELSIF p_attr_id = G_BREAK_UOM_ATTRIBUTE THEN
647: l_index := l_index + 1;
648: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_ATTRIBUTE;
649: ELSIF p_attr_id = G_CONTINUOUS_PRICE_BREAK_FLAG THEN
650: l_index := l_index + 1;
651: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTINUOUS_PRICE_BREAK_FLAG;
652: END IF;

Line 651: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTINUOUS_PRICE_BREAK_FLAG;

647: l_index := l_index + 1;
648: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BREAK_UOM_ATTRIBUTE;
649: ELSIF p_attr_id = G_CONTINUOUS_PRICE_BREAK_FLAG THEN
650: l_index := l_index + 1;
651: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTINUOUS_PRICE_BREAK_FLAG;
652: END IF;
653:
654: END Clear_Dependent_Attr;
655:

Line 2111: QP_PRICE_LIST_LINE_UTIL.DELETE_ROW(get_rltd_mods_rec.to_rltd_modifier_id);

2107: IF L_LINE_TYPE_CODE = 'PBH' THEN
2108:
2109: for get_rltd_mods_rec in get_rltd_mods(p_list_line_id) loop
2110:
2111: QP_PRICE_LIST_LINE_UTIL.DELETE_ROW(get_rltd_mods_rec.to_rltd_modifier_id);
2112:
2113: end loop;
2114:
2115: DELETE FROM QP_RLTD_MODIFIERS

Line 2621: QP_Price_List_Line_Util.Print_Price_List_line(p_PRICE_LIST_LINE_rec,

2617: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
2618: BEGIN
2619:
2620:
2621: QP_Price_List_Line_Util.Print_Price_List_line(p_PRICE_LIST_LINE_rec,
2622: 1);
2623:
2624:
2625: SELECT ACCRUAL_QTY

Line 4493: END QP_Price_List_Line_Util;

4489: END Get_Product_Id;
4490:
4491:
4492:
4493: END QP_Price_List_Line_Util;