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_PRICE_LIST_UTIL dependencies on QP_PRICE_LIST_UTIL

Line 1: PACKAGE BODY QP_Price_List_Util AS

1: PACKAGE BODY QP_Price_List_Util AS
2: /* $Header: QPXUPLHB.pls 120.12 2011/11/29 15:42:40 jputta ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXUPLHB.pls 120.12 2011/11/29 15:42:40 jputta ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Price_List_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE1;

31:
32: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)
39: THEN

Line 41: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE10;

37:
38: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)
45: THEN

Line 47: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE11;

43:
44: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)
51: THEN

Line 53: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE12;

49:
50: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)
57: THEN

Line 59: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE13;

55:
56: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)
63: THEN

Line 65: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE14;

61:
62: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)
69: THEN

Line 71: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE15;

67:
68: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)
75: THEN

Line 77: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE2;

73:
74: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)
81: THEN

Line 83: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE3;

79:
80: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)
87: THEN

Line 89: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE4;

85:
86: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)
93: THEN

Line 95: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE5;

91:
92: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)
99: THEN

Line 101: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE6;

97:
98: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)
105: THEN

Line 107: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE7;

103:
104: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)
111: THEN

Line 113: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE8;

109:
110: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)
117: THEN

Line 119: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE9;

115:
116: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,p_old_PRICE_LIST_rec.automatic_flag)
123: THEN

Line 125: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_AUTOMATIC;

121:
122: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,p_old_PRICE_LIST_rec.automatic_flag)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_AUTOMATIC;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)
129: THEN

Line 131: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_COMMENTS;

127:
128: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_COMMENTS;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)
135: THEN

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

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

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

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

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

145:
146: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATION_DATE;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)
153: THEN

Line 155: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY;

151:
152: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,p_old_PRICE_LIST_rec.discount_lines_flag)
159: THEN

Line 161: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DISCOUNT_LINES;

157:
158: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,p_old_PRICE_LIST_rec.discount_lines_flag)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DISCOUNT_LINES;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)
165: THEN

Line 167: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;

163:
164: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)
171: THEN

Line 173: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_FREIGHT_TERMS;

169:
170: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_FREIGHT_TERMS;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,p_old_PRICE_LIST_rec.gsa_indicator)
177: THEN

Line 179: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GSA_INDICATOR;

175:
176: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,p_old_PRICE_LIST_rec.gsa_indicator)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GSA_INDICATOR;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
183: THEN

Line 185: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;

181:
182: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
189: THEN

Line 191: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;

187:
188: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
195: THEN

Line 197: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;

193:
194: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)
201: THEN

Line 203: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_NAME;

199:
200: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_NAME;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)
207: THEN

Line 209: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DESCRIPTION;

205:
206: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DESCRIPTION;
210: END IF;
211:
212:
213: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,p_old_PRICE_LIST_rec.list_header_id)

Line 216: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_HEADER;

212:
213: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,p_old_PRICE_LIST_rec.list_header_id)
214: THEN
215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_HEADER;
217: END IF;
218:
219: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,p_old_PRICE_LIST_rec.list_type_code)
220: THEN

Line 222: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_TYPE;

218:
219: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,p_old_PRICE_LIST_rec.list_type_code)
220: THEN
221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_TYPE;
223: END IF;
224:
225: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.version_no,p_old_PRICE_LIST_rec.version_no)
226: THEN

Line 228: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_VERSION_NO;

224:
225: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.version_no,p_old_PRICE_LIST_rec.version_no)
226: THEN
227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_VERSION_NO;
229: END IF;
230:
231: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,p_old_PRICE_LIST_rec.active_flag)
232: THEN

Line 234: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ACTIVE_FLAG;

230:
231: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,p_old_PRICE_LIST_rec.active_flag)
232: THEN
233: l_index := l_index + 1;
234: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ACTIVE_FLAG;
235: END IF;
236:
237: --mkarya for bug 1944882
238: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download,p_old_PRICE_LIST_rec.mobile_download)

Line 241: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_MOBILE_DOWNLOAD;

237: --mkarya for bug 1944882
238: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download,p_old_PRICE_LIST_rec.mobile_download)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_MOBILE_DOWNLOAD;
242: END IF;
243:
244: --Pricing Security gtippire
245: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag,p_old_PRICE_LIST_rec.global_flag)

Line 248: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GLOBAL_FLAG;

244: --Pricing Security gtippire
245: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag,p_old_PRICE_LIST_rec.global_flag)
246: THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GLOBAL_FLAG;
249: END IF;
250:
251: --Multi-Currency SunilPandey
252: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)

Line 255: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY_HEADER;

251: --Multi-Currency SunilPandey
252: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY_HEADER;
256: END IF;
257:
258: --Attributes Manager Giri
259: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.pte_code,p_old_PRICE_LIST_rec.pte_code)

Line 262: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PTE;

258: --Attributes Manager Giri
259: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.pte_code,p_old_PRICE_LIST_rec.pte_code)
260: THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PTE;
263: END IF;
264:
265: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)
266: THEN

Line 268: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;

264:
265: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)
266: THEN
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;
269: END IF;
270:
271: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)
272: THEN

Line 274: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM;

270:
271: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)
272: THEN
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM;
275: END IF;
276:
277: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
278: THEN

Line 280: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;

276:
277: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
278: THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
281: END IF;
282:
283: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,p_old_PRICE_LIST_rec.prorate_flag)
284: THEN

Line 286: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PRORATE;

282:
283: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,p_old_PRICE_LIST_rec.prorate_flag)
284: THEN
285: l_index := l_index + 1;
286: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PRORATE;
287: END IF;
288:
289: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)
290: THEN

Line 292: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_REQUEST;

288:
289: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)
290: THEN
291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_REQUEST;
293: END IF;
294:
295: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)
296: THEN

Line 298: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;

294:
295: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)
296: THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;
299: END IF;
300:
301: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)
302: THEN

Line 304: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHIP_METHOD;

300:
301: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)
302: THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHIP_METHOD;
305: END IF;
306:
307: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)
308: THEN

Line 310: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;

306:
307: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)
308: THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;
311: END IF;
312:
313: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)
314: THEN

Line 316: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_TERMS;

312:
313: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)
314: THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_TERMS;
317: END IF;
318:
319: --Blanket Sales Order Addition
320: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,p_old_PRICE_LIST_rec.list_source_code)

Line 323: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_SOURCE;

319: --Blanket Sales Order Addition
320: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,p_old_PRICE_LIST_rec.list_source_code)
321: THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_SOURCE;
324: END IF;
325:
326: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,p_old_PRICE_LIST_rec.orig_system_header_ref)
327: THEN

Line 329: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.ORIG_SYSTEM_HEADER_REF;

325:
326: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,p_old_PRICE_LIST_rec.orig_system_header_ref)
327: THEN
328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.ORIG_SYSTEM_HEADER_REF;
330: END IF;
331:
332: --Blanket Pricing
333: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,p_old_PRICE_LIST_rec.source_system_code)

Line 336: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOURCE_SYSTEM_CODE;

332: --Blanket Pricing
333: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,p_old_PRICE_LIST_rec.source_system_code)
334: THEN
335: l_index := l_index + 1;
336: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
337: END IF;
338:
339: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,p_old_PRICE_LIST_rec.shareable_flag)
340: THEN

Line 342: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHAREABLE_FLAG;

338:
339: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,p_old_PRICE_LIST_rec.shareable_flag)
340: THEN
341: l_index := l_index + 1;
342: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHAREABLE_FLAG;
343: END IF;
344:
345: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id, p_old_PRICE_LIST_rec.sold_to_org_id)
346: THEN

Line 348: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOLD_TO_ORG_ID;

344:
345: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id, p_old_PRICE_LIST_rec.sold_to_org_id)
346: THEN
347: l_index := l_index + 1;
348: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOLD_TO_ORG_ID;
349: END IF;
350:
351:
352: --Added for Price List Locking project (Pack J)

Line 358: QP_PRICE_LIST_UTIL.G_LOCKED_FROM_LIST_HEADER;

354: p_old_PRICE_LIST_rec.locked_from_list_header_id)
355: THEN
356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) :=
358: QP_PRICE_LIST_UTIL.G_LOCKED_FROM_LIST_HEADER;
359: END IF;
360:
361: --added for MOAC
362: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,p_old_PRICE_LIST_rec.org_id)

Line 365: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ORG_ID;

361: --added for MOAC
362: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,p_old_PRICE_LIST_rec.org_id)
363: THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ORG_ID;
366: END IF;
367:
368: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
369: l_index := l_index + 1;

Line 370: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE1;

366: END IF;
367:
368: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE1;
371: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE10;
374: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 373: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE10;

369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE1;
371: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE10;
374: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE11;
377: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 376: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE11;

372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE10;
374: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE11;
377: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE12;
380: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 379: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE12;

375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE11;
377: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE12;
380: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE13;
383: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 382: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE13;

378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE12;
380: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE13;
383: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE14;
386: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 385: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE14;

381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE13;
383: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE14;
386: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE15;
389: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 388: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE15;

384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE14;
386: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE15;
389: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE2;
392: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 391: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE2;

387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE15;
389: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE2;
392: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE3;
395: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 394: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE3;

390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE2;
392: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE3;
395: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE4;
398: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 397: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE4;

393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE3;
395: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE4;
398: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE5;
401: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 400: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE5;

396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE4;
398: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE5;
401: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE6;
404: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 403: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE6;

399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE5;
401: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE6;
404: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE7;
407: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 406: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE7;

402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE6;
404: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE7;
407: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE8;
410: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 409: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE8;

405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE7;
407: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE8;
410: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE9;
413: ELSIF p_attr_id = G_AUTOMATIC THEN

Line 412: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE9;

408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE8;
410: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE9;
413: ELSIF p_attr_id = G_AUTOMATIC THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_AUTOMATIC;
416: ELSIF p_attr_id = G_COMMENTS THEN

Line 415: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_AUTOMATIC;

411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE9;
413: ELSIF p_attr_id = G_AUTOMATIC THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_AUTOMATIC;
416: ELSIF p_attr_id = G_COMMENTS THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_COMMENTS;
419: ELSIF p_attr_id = G_CONTEXT THEN

Line 418: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_COMMENTS;

414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_AUTOMATIC;
416: ELSIF p_attr_id = G_COMMENTS THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_COMMENTS;
419: ELSIF p_attr_id = G_CONTEXT THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CONTEXT;
422: ELSIF p_attr_id = G_CREATED_BY THEN

Line 421: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CONTEXT;

417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_COMMENTS;
419: ELSIF p_attr_id = G_CONTEXT THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CONTEXT;
422: ELSIF p_attr_id = G_CREATED_BY THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATED_BY;
425: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 424: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATED_BY;

420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CONTEXT;
422: ELSIF p_attr_id = G_CREATED_BY THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATED_BY;
425: ELSIF p_attr_id = G_CREATION_DATE THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATION_DATE;
428: ELSIF p_attr_id = G_CURRENCY THEN

Line 427: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATION_DATE;

423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATED_BY;
425: ELSIF p_attr_id = G_CREATION_DATE THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATION_DATE;
428: ELSIF p_attr_id = G_CURRENCY THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY;
431: ELSIF p_attr_id = G_DISCOUNT_LINES THEN

Line 430: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY;

426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATION_DATE;
428: ELSIF p_attr_id = G_CURRENCY THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY;
431: ELSIF p_attr_id = G_DISCOUNT_LINES THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DISCOUNT_LINES;
434: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN

Line 433: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DISCOUNT_LINES;

429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY;
431: ELSIF p_attr_id = G_DISCOUNT_LINES THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DISCOUNT_LINES;
434: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;
437: ELSIF p_attr_id = G_FREIGHT_TERMS THEN

Line 436: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;

432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DISCOUNT_LINES;
434: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;
437: ELSIF p_attr_id = G_FREIGHT_TERMS THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_FREIGHT_TERMS;
440: ELSIF p_attr_id = G_GSA_INDICATOR THEN

Line 439: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_FREIGHT_TERMS;

435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;
437: ELSIF p_attr_id = G_FREIGHT_TERMS THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_FREIGHT_TERMS;
440: ELSIF p_attr_id = G_GSA_INDICATOR THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GSA_INDICATOR;
443: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 442: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GSA_INDICATOR;

438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_FREIGHT_TERMS;
440: ELSIF p_attr_id = G_GSA_INDICATOR THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GSA_INDICATOR;
443: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
446: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 445: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;

441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GSA_INDICATOR;
443: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
446: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
449: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 448: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;

444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
446: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
449: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
452: ELSIF p_attr_id = G_NAME THEN

Line 451: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;

447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
449: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
452: ELSIF p_attr_id = G_NAME THEN
453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_NAME;
455: ELSIF p_attr_id = G_DESCRIPTION THEN

Line 460: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_HEADER;

456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := OE_PRICE_LIST_UTIL.G_DESCRIPTION;
458: ELSIF p_attr_id = G_LIST_HEADER THEN
459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_HEADER;
461: ELSIF p_attr_id = G_LIST_TYPE THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_TYPE;
464: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 463: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_TYPE;

459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_HEADER;
461: ELSIF p_attr_id = G_LIST_TYPE THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_TYPE;
464: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;
467: ELSIF p_attr_id = G_PROGRAM THEN

Line 466: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;

462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_TYPE;
464: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;
467: ELSIF p_attr_id = G_PROGRAM THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM;
470: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 469: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM;

465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;
467: ELSIF p_attr_id = G_PROGRAM THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM;
470: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
473: ELSIF p_attr_id = G_PRORATE THEN

Line 472: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;

468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM;
470: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
473: ELSIF p_attr_id = G_PRORATE THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PRORATE;
476: ELSIF p_attr_id = G_REQUEST THEN

Line 475: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PRORATE;

471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
473: ELSIF p_attr_id = G_PRORATE THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PRORATE;
476: ELSIF p_attr_id = G_REQUEST THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_REQUEST;
479: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN

Line 478: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_REQUEST;

474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PRORATE;
476: ELSIF p_attr_id = G_REQUEST THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_REQUEST;
479: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;
482: ELSIF p_attr_id = G_SHIP_METHOD THEN

Line 481: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;

477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_REQUEST;
479: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;
482: ELSIF p_attr_id = G_SHIP_METHOD THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHIP_METHOD;
485: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN

Line 484: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHIP_METHOD;

480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;
482: ELSIF p_attr_id = G_SHIP_METHOD THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHIP_METHOD;
485: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;
488: ELSIF p_attr_id = G_TERMS THEN

Line 487: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;

483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHIP_METHOD;
485: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;
488: ELSIF p_attr_id = G_TERMS THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_TERMS;
491:

Line 490: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_TERMS;

486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;
488: ELSIF p_attr_id = G_TERMS THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_TERMS;
491:
492: --Blanket Sales Order Addition
493: ELSIF p_attr_id = G_LIST_SOURCE THEN
494: l_index := l_index + 1;

Line 495: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_SOURCE;

491:
492: --Blanket Sales Order Addition
493: ELSIF p_attr_id = G_LIST_SOURCE THEN
494: l_index := l_index + 1;
495: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_SOURCE;
496: ELSIF p_attr_id = ORIG_SYSTEM_HEADER_REF THEN
497: l_index := l_index + 1;
498: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.ORIG_SYSTEM_HEADER_REF;
499:

Line 498: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.ORIG_SYSTEM_HEADER_REF;

494: l_index := l_index + 1;
495: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_SOURCE;
496: ELSIF p_attr_id = ORIG_SYSTEM_HEADER_REF THEN
497: l_index := l_index + 1;
498: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.ORIG_SYSTEM_HEADER_REF;
499:
500: --Blanket pricing
501: ELSIF p_attr_id = G_SOURCE_SYSTEM_CODE THEN
502: l_index := l_index + 1;

Line 503: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOURCE_SYSTEM_CODE;

499:
500: --Blanket pricing
501: ELSIF p_attr_id = G_SOURCE_SYSTEM_CODE THEN
502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
504: ELSIF p_attr_id = G_SHAREABLE_FLAG THEN
505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHAREABLE_FLAG;
507: ELSIF p_attr_id = G_SOLD_TO_ORG_ID THEN

Line 506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHAREABLE_FLAG;

502: l_index := l_index + 1;
503: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
504: ELSIF p_attr_id = G_SHAREABLE_FLAG THEN
505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHAREABLE_FLAG;
507: ELSIF p_attr_id = G_SOLD_TO_ORG_ID THEN
508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOLD_TO_ORG_ID;
510: --added for MOAC

Line 509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOLD_TO_ORG_ID;

505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHAREABLE_FLAG;
507: ELSIF p_attr_id = G_SOLD_TO_ORG_ID THEN
508: l_index := l_index + 1;
509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOLD_TO_ORG_ID;
510: --added for MOAC
511: ELSIF p_attr_id = G_ORG_ID THEN
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ORG_ID;

Line 513: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ORG_ID;

509: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SOLD_TO_ORG_ID;
510: --added for MOAC
511: ELSIF p_attr_id = G_ORG_ID THEN
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ORG_ID;
514: END IF;
515: END Clear_Dependent_Attr;
516:
517: -- Procedure Apply_Attribute_Changes

Line 1738: , nvl(p_PRICE_LIST_rec.orig_system_header_ref,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(p_PRICE_LIST_rec.list_header_id)) -- Blanket Sales Order

1734: , p_PRICE_LIST_rec.currency_header_id
1735: , p_PRICE_LIST_rec.pte_code -- Giri for Attributes Manager
1736: , p_PRICE_LIST_rec.list_source_code -- Blanket Sales Order
1737: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1738: , nvl(p_PRICE_LIST_rec.orig_system_header_ref,QP_PRICE_LIST_UTIL.Get_Orig_Sys_Hdr(p_PRICE_LIST_rec.list_header_id)) -- Blanket Sales Order
1739: , decode(p_PRICE_LIST_rec.global_flag, FND_API.G_MISS_CHAR, 'N',
1740: p_PRICE_LIST_rec.global_flag) -- Pricing Security gtippire
1741: --added for MOAC
1742: , p_PRICE_LIST_rec.org_id

Line 2835: END QP_Price_List_Util;

2831: END IF;
2832: END IF;
2833: END;
2834:
2835: END QP_Price_List_Util;