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_PRICING_ATTR_UTIL dependencies on QP_PRICING_ATTR_UTIL

Line 1: PACKAGE BODY QP_Pricing_Attr_Util AS

1: PACKAGE BODY QP_Pricing_Attr_Util AS
2: /* $Header: QPXUPRAB.pls 120.14.12020000.2 2012/09/10 11:02:03 smbalara ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXUPRAB.pls 120.14.12020000.2 2012/09/10 11:02:03 smbalara ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Pricing_Attr_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 37: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ACCUMULATE;

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

Line 43: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE1;

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

Line 49: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE10;

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

Line 55: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE11;

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

Line 61: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE12;

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

Line 67: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE13;

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

Line 73: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE14;

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

Line 79: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE15;

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

Line 85: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE2;

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

Line 91: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE3;

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

Line 97: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE4;

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

Line 103: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE5;

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

Line 109: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE6;

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

Line 115: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE7;

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

Line 121: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE8;

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

Line 127: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE9;

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

Line 133: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE_GROUPING_NO;

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

Line 139: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CONTEXT;

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

Line 145: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATED_BY;

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

Line 151: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATION_DATE;

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

Line 157: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_EXCLUDER;

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

Line 163: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATED_BY;

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

Line 169: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_DATE;

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

Line 175: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_LOGIN;

171:
172: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_LOGIN;
176: END IF;
177:
178: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
179: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)

Line 182: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_HEADER;

178: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
179: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
180: THEN
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_HEADER;
183: END IF;
184:
185: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
186: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)

Line 189: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_PHASE;

185: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
186: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
187: THEN
188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_PHASE;
190: END IF;
191:
192: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
193: THEN

Line 195: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_LINE;

191:
192: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
193: THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_LINE;
196: END IF;
197:
198: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)
199: THEN

Line 201: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;

197:
198: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)
199: THEN
200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
202: END IF;
203:
204: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
205: THEN

Line 207: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;

203:
204: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
205: THEN
206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
208: END IF;
209:
210: /*
211: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)

Line 214: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;

210: /*
211: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)
212: THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
215: END IF;
216: */
217:
218: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)

Line 221: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_FROM;

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

Line 227: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_TO;

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

Line 233: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE;

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

Line 239: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;

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

Line 245: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTR_VALUE;

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

Line 251: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_UOM;

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

Line 257: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_APPLICATION;

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

Line 263: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM;

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

Line 269: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_UPDATE_DATE;

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

Line 275: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;

271:
272: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)
273: THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;
276: END IF;
277:
278: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,p_old_PRICING_ATTR_rec.product_attribute_datatype)
279: THEN

Line 281: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;

277:
278: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,p_old_PRICING_ATTR_rec.product_attribute_datatype)
279: THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
282: END IF;
283:
284: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
285: THEN

Line 287: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;

283:
284: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
285: THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
288: END IF;
289:
290: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,p_old_PRICING_ATTR_rec.comparison_operator_code)
291: THEN

Line 293: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_COMPARISON_OPERATOR;

289:
290: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,p_old_PRICING_ATTR_rec.comparison_operator_code)
291: THEN
292: l_index := l_index + 1;
293: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_COMPARISON_OPERATOR;
294: END IF;
295:
296: ELSIF p_attr_id = G_ACCUMULATE THEN
297: l_index := l_index + 1;

Line 298: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ACCUMULATE;

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

Line 301: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE1;

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

Line 304: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE10;

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

Line 307: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE11;

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

Line 310: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE12;

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

Line 313: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE13;

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

Line 316: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE14;

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

Line 319: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE15;

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

Line 322: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE2;

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

Line 325: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE3;

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

Line 328: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE4;

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

Line 331: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE5;

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

Line 334: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE6;

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

Line 337: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE7;

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

Line 340: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE8;

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

Line 343: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE9;

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

Line 346: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE_GROUPING_NO;

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

Line 349: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CONTEXT;

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

Line 352: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATED_BY;

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

Line 355: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATION_DATE;

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

Line 358: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_EXCLUDER;

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

Line 361: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATED_BY;

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

Line 364: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_DATE;

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

Line 367: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_LOGIN;

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

Line 370: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_LINE;

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

Line 373: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;

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

Line 376: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;

372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
374: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_CONTEXT THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
377: ELSIF p_attr_id = G_PRICING_ATTRIBUTE THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
380: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_FROM THEN

Line 379: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;

375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
377: ELSIF p_attr_id = G_PRICING_ATTRIBUTE THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
380: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_FROM THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_FROM;
383: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_TO THEN

Line 382: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_FROM;

378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
380: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_FROM THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_FROM;
383: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_TO THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_TO;
386: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE THEN

Line 385: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_TO;

381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_FROM;
383: ELSIF p_attr_id = G_PRICING_ATTR_VALUE_TO THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_TO;
386: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE;
389: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_CONTEXT THEN

Line 388: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE;

384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_TO;
386: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE;
389: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_CONTEXT THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
392: ELSIF p_attr_id = G_PRODUCT_ATTR_VALUE THEN

Line 391: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;

387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE;
389: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_CONTEXT THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
392: ELSIF p_attr_id = G_PRODUCT_ATTR_VALUE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTR_VALUE;
395: ELSIF p_attr_id = G_PRODUCT_UOM THEN

Line 394: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTR_VALUE;

390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
392: ELSIF p_attr_id = G_PRODUCT_ATTR_VALUE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTR_VALUE;
395: ELSIF p_attr_id = G_PRODUCT_UOM THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_UOM;
398: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 397: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_UOM;

393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTR_VALUE;
395: ELSIF p_attr_id = G_PRODUCT_UOM THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_UOM;
398: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_APPLICATION;
401: ELSIF p_attr_id = G_PROGRAM THEN

Line 400: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_APPLICATION;

396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_UOM;
398: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_APPLICATION;
401: ELSIF p_attr_id = G_PROGRAM THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM;
404: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 403: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM;

399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_APPLICATION;
401: ELSIF p_attr_id = G_PROGRAM THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM;
404: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_UPDATE_DATE;
407: ELSIF p_attr_id = G_REQUEST THEN

Line 406: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_UPDATE_DATE;

402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM;
404: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_UPDATE_DATE;
407: ELSIF p_attr_id = G_REQUEST THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;
410: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_DATATYPE THEN

Line 409: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;

405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_UPDATE_DATE;
407: ELSIF p_attr_id = G_REQUEST THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;
410: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_DATATYPE THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
413: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_DATATYPE THEN

Line 412: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;

408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;
410: ELSIF p_attr_id = G_PRODUCT_ATTRIBUTE_DATATYPE THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
413: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_DATATYPE THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
416: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN

Line 415: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;

411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
413: ELSIF p_attr_id = G_PRICING_ATTRIBUTE_DATATYPE THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
416: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_COMPARISON_OPERATOR;
419: END IF;

Line 418: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_COMPARISON_OPERATOR;

414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
416: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_COMPARISON_OPERATOR;
419: END IF;
420:
421: oe_debug_pub.add('END Clear_Dependent_Attr in QPXUPRAB');
422:

Line 2848: oe_debug_pub.Add('Entering QP_PRICING_ATTR_Util.pre_write_process', 1);

2844: l_list_header_id number;
2845:
2846: BEGIN
2847:
2848: oe_debug_pub.Add('Entering QP_PRICING_ATTR_Util.pre_write_process', 1);
2849: --Bug 10421292 . Added following code to update pricing attributes when the Product attribute is changed in Modifier form.
2850: --Similar issue addressed for Price list in bug 2807015
2851: IF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND p_PRICING_ATTR_rec.excluder_flag = 'N') --14603635
2852: THEN

Line 3034: END QP_Pricing_Attr_Util;

3030: END IF;
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: END Pre_Write_Process;
3033:
3034: END QP_Pricing_Attr_Util;