eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_PLL_PRICING_ATTR_UTIL

Line 1: PACKAGE BODY QP_pll_pricing_attr_Util AS

1: PACKAGE BODY QP_pll_pricing_attr_Util AS
2: /* $Header: QPXUPLAB.pls 120.6.12010000.6 2009/11/30 04:04:28 jputta ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXUPLAB.pls 120.6.12010000.6 2009/11/30 04:04:28 jputta ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Qp_pll_pricing_attr_Util';
7: G_PRODUCT_UOM_CODE VARCHAR2(30);
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ACCUMULATE;

31:
32: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ACCUMULATE;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,p_old_PRICING_ATTR_rec.attribute1)
39: THEN

Line 41: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE1;

37:
38: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,p_old_PRICING_ATTR_rec.attribute1)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE1;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,p_old_PRICING_ATTR_rec.attribute10)
45: THEN

Line 47: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE10;

43:
44: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,p_old_PRICING_ATTR_rec.attribute10)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE10;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,p_old_PRICING_ATTR_rec.attribute11)
51: THEN

Line 53: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE11;

49:
50: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,p_old_PRICING_ATTR_rec.attribute11)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE11;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,p_old_PRICING_ATTR_rec.attribute12)
57: THEN

Line 59: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE12;

55:
56: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,p_old_PRICING_ATTR_rec.attribute12)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE12;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,p_old_PRICING_ATTR_rec.attribute13)
63: THEN

Line 65: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE13;

61:
62: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,p_old_PRICING_ATTR_rec.attribute13)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE13;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,p_old_PRICING_ATTR_rec.attribute14)
69: THEN

Line 71: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE14;

67:
68: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,p_old_PRICING_ATTR_rec.attribute14)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE14;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,p_old_PRICING_ATTR_rec.attribute15)
75: THEN

Line 77: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE15;

73:
74: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,p_old_PRICING_ATTR_rec.attribute15)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE15;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,p_old_PRICING_ATTR_rec.attribute2)
81: THEN

Line 83: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE2;

79:
80: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,p_old_PRICING_ATTR_rec.attribute2)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE2;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,p_old_PRICING_ATTR_rec.attribute3)
87: THEN

Line 89: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE3;

85:
86: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,p_old_PRICING_ATTR_rec.attribute3)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE3;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,p_old_PRICING_ATTR_rec.attribute4)
93: THEN

Line 95: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE4;

91:
92: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,p_old_PRICING_ATTR_rec.attribute4)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE4;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,p_old_PRICING_ATTR_rec.attribute5)
99: THEN

Line 101: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE5;

97:
98: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,p_old_PRICING_ATTR_rec.attribute5)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE5;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,p_old_PRICING_ATTR_rec.attribute6)
105: THEN

Line 107: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE6;

103:
104: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,p_old_PRICING_ATTR_rec.attribute6)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE6;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,p_old_PRICING_ATTR_rec.attribute7)
111: THEN

Line 113: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE7;

109:
110: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,p_old_PRICING_ATTR_rec.attribute7)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE7;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,p_old_PRICING_ATTR_rec.attribute8)
117: THEN

Line 119: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE8;

115:
116: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,p_old_PRICING_ATTR_rec.attribute8)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE8;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,p_old_PRICING_ATTR_rec.attribute9)
123: THEN

Line 125: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE9;

121:
122: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,p_old_PRICING_ATTR_rec.attribute9)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE9;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,p_old_PRICING_ATTR_rec.attribute_grouping_no)
129: THEN

Line 131: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE_GROUPING_NO;

127:
128: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,p_old_PRICING_ATTR_rec.attribute_grouping_no)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE_GROUPING_NO;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)
135: THEN

Line 137: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CONTEXT;

133:
134: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CONTEXT;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,p_old_PRICING_ATTR_rec.created_by)
141: THEN

Line 143: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATED_BY;

139:
140: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,p_old_PRICING_ATTR_rec.created_by)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATED_BY;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,p_old_PRICING_ATTR_rec.creation_date)
147: THEN

Line 149: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATION_DATE;

145:
146: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,p_old_PRICING_ATTR_rec.creation_date)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATION_DATE;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,p_old_PRICING_ATTR_rec.excluder_flag)
153: THEN

Line 155: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_EXCLUDER;

151:
152: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,p_old_PRICING_ATTR_rec.excluder_flag)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_EXCLUDER;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)
159: THEN

Line 161: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;

157:
158: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)
165: THEN

Line 167: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;

163:
164: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)
171: THEN

Line 173: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;

169:
170: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
177: THEN

Line 179: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;

175:
176: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
183: THEN

Line 185: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_HEADER;

181:
182: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_HEADER;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
189: THEN

Line 191: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_PHASE;

187:
188: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_PHASE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)
195: THEN

Line 197: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;

193:
194: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
201: THEN

Line 203: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;

199:
200: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
204: END IF;
205:
206: /*
207: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)

Line 210: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;

206: /*
207: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)
208: THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
211: END IF;
212: */
213:
214: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.from_rltd_modifier_id,p_old_PRICING_ATTR_rec.from_rltd_modifier_id)

Line 217: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_FROM_RLTD_MODIFIER;

213:
214: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.from_rltd_modifier_id,p_old_PRICING_ATTR_rec.from_rltd_modifier_id)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_FROM_RLTD_MODIFIER;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)
221: THEN

Line 223: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_FROM;

219:
220: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_FROM;
224: END IF;
225:
226: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,p_old_PRICING_ATTR_rec.pricing_attr_value_to)
227: THEN

Line 229: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_TO;

225:
226: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,p_old_PRICING_ATTR_rec.pricing_attr_value_to)
227: THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_TO;
230: END IF;
231:
232: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,p_old_PRICING_ATTR_rec.product_attribute)
233: THEN

Line 235: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE;

231:
232: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,p_old_PRICING_ATTR_rec.product_attribute)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE;
236: END IF;
237:
238: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)
239: THEN

Line 241: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;

237:
238: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
242: END IF;
243:
244: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,p_old_PRICING_ATTR_rec.product_attr_value)
245: THEN

Line 247: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTR_VALUE;

243:
244: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,p_old_PRICING_ATTR_rec.product_attr_value)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTR_VALUE;
248: END IF;
249:
250: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)
251: THEN

Line 253: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_UOM;

249:
250: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_UOM;
254: END IF;
255:
256: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,p_old_PRICING_ATTR_rec.program_application_id)
257: THEN

Line 259: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_APPLICATION;

255:
256: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,p_old_PRICING_ATTR_rec.program_application_id)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_APPLICATION;
260: END IF;
261:
262: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,p_old_PRICING_ATTR_rec.program_id)
263: THEN

Line 265: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM;

261:
262: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,p_old_PRICING_ATTR_rec.program_id)
263: THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM;
266: END IF;
267:
268: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)
269: THEN

Line 271: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;

267:
268: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)
269: THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;
272: END IF;
273:
274: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)
275: THEN

Line 277: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_REQUEST;

273:
274: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)
275: THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_REQUEST;
278: END IF;
279:
280: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code, p_old_PRICING_ATTR_rec.comparison_operator_code)
281: THEN

Line 283: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;

279:
280: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code, p_old_PRICING_ATTR_rec.comparison_operator_code)
281: THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;
284: END IF;
285:
286: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype, p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
287: THEN

Line 289: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;

285:
286: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype, p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
287: THEN
288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
290: END IF;
291:
292: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype, p_old_PRICING_ATTR_rec.product_attribute_datatype)
293: THEN

Line 295: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;

291:
292: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype, p_old_PRICING_ATTR_rec.product_attribute_datatype)
293: THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
296: END IF;
297:
298: ELSIF p_attr_id = G_ACCUMULATE THEN
299: l_index := l_index + 1;

Line 300: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ACCUMULATE;

296: END IF;
297:
298: ELSIF p_attr_id = G_ACCUMULATE THEN
299: l_index := l_index + 1;
300: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ACCUMULATE;
301: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE1;
304: ELSIF p_attr_id = G_ATTRIBUTE10 THEN

Line 303: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE1;

299: l_index := l_index + 1;
300: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ACCUMULATE;
301: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE1;
304: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
305: l_index := l_index + 1;
306: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE10;
307: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 306: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE10;

302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE1;
304: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
305: l_index := l_index + 1;
306: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE10;
307: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE11;
310: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 309: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE11;

305: l_index := l_index + 1;
306: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE10;
307: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE11;
310: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
311: l_index := l_index + 1;
312: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE12;
313: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 312: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE12;

308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE11;
310: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
311: l_index := l_index + 1;
312: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE12;
313: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE13;
316: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 315: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE13;

311: l_index := l_index + 1;
312: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE12;
313: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE13;
316: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
317: l_index := l_index + 1;
318: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE14;
319: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 318: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE14;

314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE13;
316: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
317: l_index := l_index + 1;
318: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE14;
319: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE15;
322: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 321: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE15;

317: l_index := l_index + 1;
318: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE14;
319: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE15;
322: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
323: l_index := l_index + 1;
324: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE2;
325: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 324: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE2;

320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE15;
322: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
323: l_index := l_index + 1;
324: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE2;
325: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE3;
328: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 327: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE3;

323: l_index := l_index + 1;
324: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE2;
325: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE3;
328: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
329: l_index := l_index + 1;
330: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE4;
331: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 330: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE4;

326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE3;
328: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
329: l_index := l_index + 1;
330: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE4;
331: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE5;
334: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 333: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE5;

329: l_index := l_index + 1;
330: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE4;
331: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE5;
334: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
335: l_index := l_index + 1;
336: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE6;
337: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 336: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE6;

332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE5;
334: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
335: l_index := l_index + 1;
336: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE6;
337: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE7;
340: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 339: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE7;

335: l_index := l_index + 1;
336: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE6;
337: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE7;
340: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
341: l_index := l_index + 1;
342: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE8;
343: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 342: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE8;

338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE7;
340: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
341: l_index := l_index + 1;
342: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE8;
343: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE9;
346: ELSIF p_attr_id = G_ATTRIBUTE_GROUPING_NO THEN

Line 345: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE9;

341: l_index := l_index + 1;
342: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE8;
343: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE9;
346: ELSIF p_attr_id = G_ATTRIBUTE_GROUPING_NO THEN
347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE_GROUPING_NO;
349: ELSIF p_attr_id = G_CONTEXT THEN

Line 348: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE_GROUPING_NO;

344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE9;
346: ELSIF p_attr_id = G_ATTRIBUTE_GROUPING_NO THEN
347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE_GROUPING_NO;
349: ELSIF p_attr_id = G_CONTEXT THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CONTEXT;
352: ELSIF p_attr_id = G_CREATED_BY THEN

Line 351: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CONTEXT;

347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ATTRIBUTE_GROUPING_NO;
349: ELSIF p_attr_id = G_CONTEXT THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CONTEXT;
352: ELSIF p_attr_id = G_CREATED_BY THEN
353: l_index := l_index + 1;
354: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATED_BY;
355: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 354: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATED_BY;

350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CONTEXT;
352: ELSIF p_attr_id = G_CREATED_BY THEN
353: l_index := l_index + 1;
354: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATED_BY;
355: ELSIF p_attr_id = G_CREATION_DATE THEN
356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATION_DATE;
358: ELSIF p_attr_id = G_EXCLUDER THEN

Line 357: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATION_DATE;

353: l_index := l_index + 1;
354: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATED_BY;
355: ELSIF p_attr_id = G_CREATION_DATE THEN
356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATION_DATE;
358: ELSIF p_attr_id = G_EXCLUDER THEN
359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_EXCLUDER;
361: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 360: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_EXCLUDER;

356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_CREATION_DATE;
358: ELSIF p_attr_id = G_EXCLUDER THEN
359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_EXCLUDER;
361: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;
364: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 363: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;

359: l_index := l_index + 1;
360: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_EXCLUDER;
361: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;
364: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
365: l_index := l_index + 1;
366: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;
367: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 366: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;

362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATED_BY;
364: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
365: l_index := l_index + 1;
366: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;
367: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;
370: ELSIF p_attr_id = G_LIST_LINE THEN

Line 369: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;

365: l_index := l_index + 1;
366: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_DATE;
367: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;
370: ELSIF p_attr_id = G_LIST_LINE THEN
371: l_index := l_index + 1;
372: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;
373: ELSIF p_attr_id = G_PRICING_ATTRIBUTE THEN

Line 372: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;

368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;
370: ELSIF p_attr_id = G_LIST_LINE THEN
371: l_index := l_index + 1;
372: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;
373: ELSIF p_attr_id = G_PRICING_ATTRIBUTE THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
376: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_CONTEXT THEN

Line 375: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;

371: l_index := l_index + 1;
372: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;
373: ELSIF p_attr_id = G_PRICING_ATTRIBUTE THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
376: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_CONTEXT THEN
377: l_index := l_index + 1;
378: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
379: /*

Line 378: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;

374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
376: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_CONTEXT THEN
377: l_index := l_index + 1;
378: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
379: /*
380: ELSIF p_attr_id = G_PRICING_ATTRIBUTE THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;

Line 382: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;

378: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
379: /*
380: ELSIF p_attr_id = G_PRICING_ATTRIBUTE THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
383: */
384:
385: ELSIF p_attr_id = G_FROM_RLTD_MODIFIER THEN
386: l_index := l_index + 1;

Line 387: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_FROM_RLTD_MODIFIER;

383: */
384:
385: ELSIF p_attr_id = G_FROM_RLTD_MODIFIER THEN
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_FROM_RLTD_MODIFIER;
388: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_FROM THEN
389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_FROM;
391: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_TO THEN

Line 390: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_FROM;

386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_FROM_RLTD_MODIFIER;
388: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_FROM THEN
389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_FROM;
391: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_TO THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_TO;
394: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE THEN

Line 393: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_TO;

389: l_index := l_index + 1;
390: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_FROM;
391: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_TO THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_TO;
394: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE THEN
395: l_index := l_index + 1;
396: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE;
397: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_CONTEXT THEN

Line 396: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE;

392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_TO;
394: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE THEN
395: l_index := l_index + 1;
396: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE;
397: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_CONTEXT THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
400: ELSIF p_attr_id = G_PRODUCT_ATTR_VALUE THEN

Line 399: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;

395: l_index := l_index + 1;
396: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE;
397: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_CONTEXT THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
400: ELSIF p_attr_id = G_PRODUCT_ATTR_VALUE THEN
401: l_index := l_index + 1;
402: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTR_VALUE;
403: ELSIF p_attr_id = G_PRODUCT_UOM THEN

Line 402: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTR_VALUE;

398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
400: ELSIF p_attr_id = G_PRODUCT_ATTR_VALUE THEN
401: l_index := l_index + 1;
402: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTR_VALUE;
403: ELSIF p_attr_id = G_PRODUCT_UOM THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_UOM;
406: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 405: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_UOM;

401: l_index := l_index + 1;
402: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTR_VALUE;
403: ELSIF p_attr_id = G_PRODUCT_UOM THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_UOM;
406: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
407: l_index := l_index + 1;
408: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_APPLICATION;
409: ELSIF p_attr_id = G_PROGRAM THEN

Line 408: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_APPLICATION;

404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_UOM;
406: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
407: l_index := l_index + 1;
408: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_APPLICATION;
409: ELSIF p_attr_id = G_PROGRAM THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM;
412: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 411: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM;

407: l_index := l_index + 1;
408: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_APPLICATION;
409: ELSIF p_attr_id = G_PROGRAM THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM;
412: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
413: l_index := l_index + 1;
414: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;
415: ELSIF p_attr_id = G_REQUEST THEN

Line 414: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;

410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM;
412: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
413: l_index := l_index + 1;
414: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;
415: ELSIF p_attr_id = G_REQUEST THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_REQUEST;
418:

Line 417: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_REQUEST;

413: l_index := l_index + 1;
414: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PROGRAM_UPDATE_DATE;
415: ELSIF p_attr_id = G_REQUEST THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_REQUEST;
418:
419: ELSIF p_attr_id = G_COMPARISON_OPERATOR_CODE THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;

Line 421: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;

417: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_REQUEST;
418:
419: ELSIF p_attr_id = G_COMPARISON_OPERATOR_CODE THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;
422:
423: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_DATATYPE THEN
424: l_index := l_index + 1;
425: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;

Line 425: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;

421: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;
422:
423: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_DATATYPE THEN
424: l_index := l_index + 1;
425: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
426:
427: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_DATATYPE THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;

Line 429: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;

425: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
426:
427: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_DATATYPE THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
430: END IF;
431:
432: END Clear_Dependent_Attr;
433:

Line 2351: oe_debug_pub.Add('Entering QP_pll_PRICING_ATTR_Util.pre_write_process', 1);

2347: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type := p_PRICING_ATTR_rec;
2348: l_return_status varchar2(30);
2349: BEGIN
2350:
2351: oe_debug_pub.Add('Entering QP_pll_PRICING_ATTR_Util.pre_write_process', 1);
2352:
2353: --Bug 2807015. Added following code to update pricing attributes when the PA is changed in PLL.
2354: IF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE)
2355: THEN

Line 2489: END QP_pll_pricing_attr_Util;

2485: END IF;
2486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2487: END Pre_Write_Process;
2488:
2489: END QP_pll_pricing_attr_Util;