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_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record

Line 20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
24:

Line 32: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)

28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
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;

Line 38: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)

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
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE10;
42: END IF;

Line 44: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)

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
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE11;
48: END IF;

Line 50: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)

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
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE12;
54: END IF;

Line 56: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)

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
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE13;
60: END IF;

Line 62: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)

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
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE14;
66: END IF;

Line 68: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)

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
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE15;
72: END IF;

Line 74: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)

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
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE2;
78: END IF;

Line 80: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)

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
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE3;
84: END IF;

Line 86: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)

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
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE4;
90: END IF;

Line 92: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)

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
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE5;
96: END IF;

Line 98: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)

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
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE6;
102: END IF;

Line 104: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)

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
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE7;
108: END IF;

Line 110: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)

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
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE8;
114: END IF;

Line 116: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)

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
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ATTRIBUTE9;
120: END IF;

Line 122: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,p_old_PRICE_LIST_rec.automatic_flag)

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
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_AUTOMATIC;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)

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
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_COMMENTS;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)

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
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CONTEXT;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,p_old_PRICE_LIST_rec.created_by)

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
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATED_BY;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)

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
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CREATION_DATE;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)

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
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_CURRENCY;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,p_old_PRICE_LIST_rec.discount_lines_flag)

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
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DISCOUNT_LINES;
162: END IF;

Line 164: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)

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
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_END_DATE_ACTIVE;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)

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
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_FREIGHT_TERMS;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,p_old_PRICE_LIST_rec.gsa_indicator)

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
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_GSA_INDICATOR;
180: END IF;

Line 182: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)

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
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATED_BY;
186: END IF;

Line 188: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)

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
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_DATE;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)

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
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LAST_UPDATE_LOGIN;
198: END IF;

Line 200: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)

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
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_NAME;
204: END IF;

Line 206: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)

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
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_DESCRIPTION;
210: END IF;

Line 213: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,p_old_PRICE_LIST_rec.list_header_id)

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)
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;

Line 219: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,p_old_PRICE_LIST_rec.list_type_code)

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
221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_LIST_TYPE;
223: END IF;

Line 225: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.version_no,p_old_PRICE_LIST_rec.version_no)

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
227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_VERSION_NO;
229: END IF;

Line 231: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,p_old_PRICE_LIST_rec.active_flag)

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
233: l_index := l_index + 1;
234: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ACTIVE_FLAG;
235: END IF;

Line 238: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download,p_old_PRICE_LIST_rec.mobile_download)

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)
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;

Line 245: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag,p_old_PRICE_LIST_rec.global_flag)

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)
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;

Line 252: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)

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)
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;

Line 259: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.pte_code,p_old_PRICE_LIST_rec.pte_code)

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)
260: THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PTE;
263: END IF;

Line 265: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)

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
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_APPLICATION;
269: END IF;

Line 271: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)

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
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM;
275: END IF;

Line 277: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)

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
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
281: END IF;

Line 283: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,p_old_PRICE_LIST_rec.prorate_flag)

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
285: l_index := l_index + 1;
286: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_PRORATE;
287: END IF;

Line 289: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)

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
291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_REQUEST;
293: END IF;

Line 295: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)

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
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_ROUNDING_FACTOR;
299: END IF;

Line 301: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)

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
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHIP_METHOD;
305: END IF;

Line 307: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)

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
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_START_DATE_ACTIVE;
311: END IF;

Line 313: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)

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
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_TERMS;
317: END IF;

Line 320: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,p_old_PRICE_LIST_rec.list_source_code)

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)
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;

Line 326: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,p_old_PRICE_LIST_rec.orig_system_header_ref)

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
328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.ORIG_SYSTEM_HEADER_REF;
330: END IF;

Line 333: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,p_old_PRICE_LIST_rec.source_system_code)

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)
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;

Line 339: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,p_old_PRICE_LIST_rec.shareable_flag)

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
341: l_index := l_index + 1;
342: l_src_attr_tbl(l_index) := QP_PRICE_LIST_UTIL.G_SHAREABLE_FLAG;
343: END IF;

Line 345: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id, p_old_PRICE_LIST_rec.sold_to_org_id)

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
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;

Line 353: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,

349: END IF;
350:
351:
352: --Added for Price List Locking project (Pack J)
353: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
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) :=

Line 362: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,p_old_PRICE_LIST_rec.org_id)

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)
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;

Line 533: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)

529:
530: x_PRICE_LIST_rec := p_PRICE_LIST_rec;
531:
532:
533: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,p_old_PRICE_LIST_rec.attribute1)
534: THEN
535: NULL;
536: END IF;
537:

Line 538: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)

534: THEN
535: NULL;
536: END IF;
537:
538: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,p_old_PRICE_LIST_rec.attribute10)
539: THEN
540: NULL;
541: END IF;
542:

Line 543: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)

539: THEN
540: NULL;
541: END IF;
542:
543: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,p_old_PRICE_LIST_rec.attribute11)
544: THEN
545: NULL;
546: END IF;
547:

Line 548: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)

544: THEN
545: NULL;
546: END IF;
547:
548: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,p_old_PRICE_LIST_rec.attribute12)
549: THEN
550: NULL;
551: END IF;
552:

Line 553: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)

549: THEN
550: NULL;
551: END IF;
552:
553: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,p_old_PRICE_LIST_rec.attribute13)
554: THEN
555: NULL;
556: END IF;
557:

Line 558: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)

554: THEN
555: NULL;
556: END IF;
557:
558: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,p_old_PRICE_LIST_rec.attribute14)
559: THEN
560: NULL;
561: END IF;
562:

Line 563: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)

559: THEN
560: NULL;
561: END IF;
562:
563: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,p_old_PRICE_LIST_rec.attribute15)
564: THEN
565: NULL;
566: END IF;
567:

Line 568: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)

564: THEN
565: NULL;
566: END IF;
567:
568: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,p_old_PRICE_LIST_rec.attribute2)
569: THEN
570: NULL;
571: END IF;
572:

Line 573: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)

569: THEN
570: NULL;
571: END IF;
572:
573: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,p_old_PRICE_LIST_rec.attribute3)
574: THEN
575: NULL;
576: END IF;
577:

Line 578: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)

574: THEN
575: NULL;
576: END IF;
577:
578: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,p_old_PRICE_LIST_rec.attribute4)
579: THEN
580: NULL;
581: END IF;
582:

Line 583: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)

579: THEN
580: NULL;
581: END IF;
582:
583: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,p_old_PRICE_LIST_rec.attribute5)
584: THEN
585: NULL;
586: END IF;
587:

Line 588: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)

584: THEN
585: NULL;
586: END IF;
587:
588: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,p_old_PRICE_LIST_rec.attribute6)
589: THEN
590: NULL;
591: END IF;
592:

Line 593: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)

589: THEN
590: NULL;
591: END IF;
592:
593: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,p_old_PRICE_LIST_rec.attribute7)
594: THEN
595: NULL;
596: END IF;
597:

Line 598: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)

594: THEN
595: NULL;
596: END IF;
597:
598: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,p_old_PRICE_LIST_rec.attribute8)
599: THEN
600: NULL;
601: END IF;
602:

Line 603: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)

599: THEN
600: NULL;
601: END IF;
602:
603: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,p_old_PRICE_LIST_rec.attribute9)
604: THEN
605: NULL;
606: END IF;
607:

Line 608: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,p_old_PRICE_LIST_rec.automatic_flag)

604: THEN
605: NULL;
606: END IF;
607:
608: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,p_old_PRICE_LIST_rec.automatic_flag)
609: THEN
610: NULL;
611: END IF;
612:

Line 613: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)

609: THEN
610: NULL;
611: END IF;
612:
613: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,p_old_PRICE_LIST_rec.comments)
614: THEN
615: NULL;
616: END IF;
617:

Line 618: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)

614: THEN
615: NULL;
616: END IF;
617:
618: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,p_old_PRICE_LIST_rec.context)
619: THEN
620: NULL;
621: END IF;
622:

Line 623: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,p_old_PRICE_LIST_rec.created_by)

619: THEN
620: NULL;
621: END IF;
622:
623: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,p_old_PRICE_LIST_rec.created_by)
624: THEN
625: NULL;
626: END IF;
627:

Line 628: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)

624: THEN
625: NULL;
626: END IF;
627:
628: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,p_old_PRICE_LIST_rec.creation_date)
629: THEN
630: NULL;
631: END IF;
632:

Line 633: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)

629: THEN
630: NULL;
631: END IF;
632:
633: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,p_old_PRICE_LIST_rec.currency_code)
634: THEN
635: NULL;
636: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
637: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 639: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

635: NULL;
636: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
637: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
638: qp_delayed_requests_pvt.log_request(
639: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
640: p_entity_id => p_PRICE_LIST_rec.list_header_id,
641: p_request_unique_key1 => NULL,
642: p_request_unique_key2 => 'UD',
643: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 643: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

639: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
640: p_entity_id => p_PRICE_LIST_rec.list_header_id,
641: p_request_unique_key1 => NULL,
642: p_request_unique_key2 => 'UD',
643: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
644: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
645: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
646: x_return_status => x_PRICE_LIST_rec.return_status);
647: END IF;

Line 645: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

641: p_request_unique_key1 => NULL,
642: p_request_unique_key2 => 'UD',
643: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
644: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
645: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
646: x_return_status => x_PRICE_LIST_rec.return_status);
647: END IF;
648: END IF; --Java Engine Installed
649: -- pattern

Line 653: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,p_old_PRICE_LIST_rec.discount_lines_flag)

649: -- pattern
650:
651: END IF;
652:
653: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,p_old_PRICE_LIST_rec.discount_lines_flag)
654: THEN
655: NULL;
656: END IF;
657:

Line 658: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)

654: THEN
655: NULL;
656: END IF;
657:
658: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)
659: THEN
660: NULL;
661: END IF;
662:

Line 665: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,p_old_PRICE_LIST_rec.active_flag)

661: END IF;
662:
663: /* Bug 1856788 Added the if condition to propogate the change in active_flag of price_list to qualifiers
664: of the price_list */
665: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,p_old_PRICE_LIST_rec.active_flag)
666: THEN
667: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
668: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
669: qp_delayed_requests_pvt.log_request(

Line 670: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

666: THEN
667: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
668: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
669: qp_delayed_requests_pvt.log_request(
670: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
671: p_entity_id => p_PRICE_LIST_rec.list_header_id,
672: p_request_unique_key1 => NULL,
673: p_request_unique_key2 => 'UD',
674: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 674: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

670: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
671: p_entity_id => p_PRICE_LIST_rec.list_header_id,
672: p_request_unique_key1 => NULL,
673: p_request_unique_key2 => 'UD',
674: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
675: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
676: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
677: x_return_status => x_PRICE_LIST_rec.return_status);
678: END IF;

Line 676: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

672: p_request_unique_key1 => NULL,
673: p_request_unique_key2 => 'UD',
674: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
675: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
676: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
677: x_return_status => x_PRICE_LIST_rec.return_status);
678: END IF;
679: END IF; --Java Engine Installed
680: -- pattern

Line 683: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

679: END IF; --Java Engine Installed
680: -- pattern
681:
682: -- added for bug 2912834
683: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
684: THEN
685:
686: UPDATE qp_qualifiers
687: SET active_flag = p_PRICE_LIST_rec.active_flag

Line 735: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download,p_old_PRICE_LIST_rec.mobile_download)

731: END IF;
732:
733: END IF;
734: -- mkarya for bug 1944882
735: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download,p_old_PRICE_LIST_rec.mobile_download)
736: THEN
737: NULL;
738: END IF;
739:

Line 741: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag,p_old_PRICE_LIST_rec.global_flag)

737: NULL;
738: END IF;
739:
740: -- Pricing Security gtippire
741: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag,p_old_PRICE_LIST_rec.global_flag)
742: THEN
743: NULL;
744: END IF;
745:

Line 751: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)

747: oe_debug_pub.add('QPXUPLHB - currency_header_id = ' || p_PRICE_LIST_rec.currency_header_id);
748: oe_debug_pub.add('QPXUPLHB - old currency_header_id = ' || p_old_PRICE_LIST_rec.currency_header_id);
749: oe_debug_pub.add('QPXUPLHB - rounding_factor = ' || p_PRICE_LIST_rec.rounding_factor);
750: -- Multi-Currency SunilPandey
751: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)
752: THEN
753: NULL;
754: if p_PRICE_LIST_rec.currency_header_id is not null then
755: select BASE_ROUNDING_FACTOR

Line 763: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.pte_code,p_old_PRICE_LIST_rec.pte_code)

759: end if;
760: END IF;
761:
762: -- Attributes Manager Giri
763: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.pte_code,p_old_PRICE_LIST_rec.pte_code)
764: THEN
765: NULL;
766: END IF;
767:

Line 768: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)

764: THEN
765: NULL;
766: END IF;
767:
768: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,p_old_PRICE_LIST_rec.freight_terms_code)
769: THEN
770: NULL;
771: END IF;
772:

Line 773: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,p_old_PRICE_LIST_rec.gsa_indicator)

769: THEN
770: NULL;
771: END IF;
772:
773: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,p_old_PRICE_LIST_rec.gsa_indicator)
774: THEN
775: NULL;
776: END IF;
777:

Line 778: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)

774: THEN
775: NULL;
776: END IF;
777:
778: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
779: THEN
780: NULL;
781: END IF;
782:

Line 783: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)

779: THEN
780: NULL;
781: END IF;
782:
783: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
784: THEN
785: NULL;
786: END IF;
787:

Line 788: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)

784: THEN
785: NULL;
786: END IF;
787:
788: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
789: THEN
790: NULL;
791: END IF;
792:

Line 793: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)

789: THEN
790: NULL;
791: END IF;
792:
793: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)
794: THEN
795: IF NOT QP_Validate.Price_List_Name(p_PRICE_LIST_rec.name,
796: p_PRICE_LIST_rec.list_header_id,
797: p_PRICE_LIST_rec.version_no) THEN

Line 802: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)

798: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
799: END IF;
800: END IF;
801:
802: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)
803: THEN
804: NULL;
805: END IF;
806:

Line 807: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,p_old_PRICE_LIST_rec.list_header_id)

803: THEN
804: NULL;
805: END IF;
806:
807: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,p_old_PRICE_LIST_rec.list_header_id)
808: THEN
809: NULL;
810: END IF;
811:

Line 812: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,p_old_PRICE_LIST_rec.list_type_code)

808: THEN
809: NULL;
810: END IF;
811:
812: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,p_old_PRICE_LIST_rec.list_type_code)
813: THEN
814: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
815: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
816: qp_delayed_requests_pvt.log_request(

Line 817: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

813: THEN
814: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
815: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
816: qp_delayed_requests_pvt.log_request(
817: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
818: p_entity_id => p_PRICE_LIST_rec.list_header_id,
819: p_request_unique_key1 => NULL,
820: p_request_unique_key2 => 'UD',
821: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 821: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

817: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
818: p_entity_id => p_PRICE_LIST_rec.list_header_id,
819: p_request_unique_key1 => NULL,
820: p_request_unique_key2 => 'UD',
821: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
822: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
823: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
824: x_return_status => x_PRICE_LIST_rec.return_status);
825: END IF;

Line 823: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

819: p_request_unique_key1 => NULL,
820: p_request_unique_key2 => 'UD',
821: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
822: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
823: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
824: x_return_status => x_PRICE_LIST_rec.return_status);
825: END IF;
826: END IF; --Java Engine Installed
827: -- pattern

Line 832: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.version_no,p_old_PRICE_LIST_rec.version_no)

828:
829: NULL;
830: END IF;
831:
832: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.version_no,p_old_PRICE_LIST_rec.version_no)
833: THEN
834: NULL;
835: END IF;
836:

Line 837: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)

833: THEN
834: NULL;
835: END IF;
836:
837: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)
838: THEN
839: NULL;
840: END IF;
841:

Line 842: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)

838: THEN
839: NULL;
840: END IF;
841:
842: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)
843: THEN
844: NULL;
845: END IF;
846:

Line 847: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)

843: THEN
844: NULL;
845: END IF;
846:
847: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
848: THEN
849: NULL;
850: END IF;
851:

Line 852: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,p_old_PRICE_LIST_rec.prorate_flag)

848: THEN
849: NULL;
850: END IF;
851:
852: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,p_old_PRICE_LIST_rec.prorate_flag)
853: THEN
854: NULL;
855: END IF;
856:

Line 857: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)

853: THEN
854: NULL;
855: END IF;
856:
857: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)
858: THEN
859: NULL;
860: END IF;
861:

Line 862: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)

858: THEN
859: NULL;
860: END IF;
861:
862: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)
863: THEN
864: /*
865: IF NOT QP_Validate.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor,
866: p_PRICE_LIST_rec.currency_code)

Line 874: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)

870: */
871: null;
872: END IF;
873:
874: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)
875: THEN
876: NULL;
877: END IF;
878:

Line 879: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)

875: THEN
876: NULL;
877: END IF;
878:
879: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)
880: THEN
881: NULL;
882: END IF;
883:

Line 884: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)

880: THEN
881: NULL;
882: END IF;
883:
884: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)
885: THEN
886: NULL;
887: END IF;
888:

Line 890: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,p_old_PRICE_LIST_rec.list_source_code)

886: NULL;
887: END IF;
888:
889: -- Blanket Sales Order
890: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,p_old_PRICE_LIST_rec.list_source_code)
891: THEN
892: NULL;
893: END IF;
894:

Line 895: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,p_old_PRICE_LIST_rec.orig_system_header_ref)

891: THEN
892: NULL;
893: END IF;
894:
895: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,p_old_PRICE_LIST_rec.orig_system_header_ref)
896: THEN
897: NULL;
898: END IF;
899:

Line 901: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code, p_old_PRICE_LIST_rec.source_system_code)

897: NULL;
898: END IF;
899:
900: -- Blanket Pricing
901: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code, p_old_PRICE_LIST_rec.source_system_code)
902: THEN
903: NULL;
904: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
905: IF( p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 907: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

903: NULL;
904: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
905: IF( p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
906: qp_delayed_requests_pvt.log_request(
907: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
908: p_entity_id => p_PRICE_LIST_rec.list_header_id,
909: p_request_unique_key1 => NULL,
910: p_request_unique_key2 => 'UD',
911: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 911: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

907: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
908: p_entity_id => p_PRICE_LIST_rec.list_header_id,
909: p_request_unique_key1 => NULL,
910: p_request_unique_key2 => 'UD',
911: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
912: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
913: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
914: x_return_status => x_PRICE_LIST_rec.return_status);
915: END IF;

Line 913: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

909: p_request_unique_key1 => NULL,
910: p_request_unique_key2 => 'UD',
911: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
912: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
913: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
914: x_return_status => x_PRICE_LIST_rec.return_status);
915: END IF;
916: END IF; --Java Engine Installed
917: -- pattern

Line 921: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag, p_old_PRICE_LIST_rec.shareable_flag)

917: -- pattern
918:
919: END IF;
920:
921: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag, p_old_PRICE_LIST_rec.shareable_flag)
922: THEN
923: NULL;
924: END IF;
925:

Line 926: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id, p_old_PRICE_LIST_rec.sold_to_org_id)

922: THEN
923: NULL;
924: END IF;
925:
926: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id, p_old_PRICE_LIST_rec.sold_to_org_id)
927: THEN
928: NULL;
929: END IF;
930:

Line 932: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id, p_old_PRICE_LIST_rec.locked_from_list_header_id)

928: NULL;
929: END IF;
930:
931: --Added for Price List Locking
932: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id, p_old_PRICE_LIST_rec.locked_from_list_header_id)
933: THEN
934: NULL;
935: END IF;
936:

Line 938: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id, p_old_PRICE_LIST_rec.org_id)

934: NULL;
935: END IF;
936:
937: --added for MOAC
938: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id, p_old_PRICE_LIST_rec.org_id)
939: THEN
940: NULL;
941: END IF;
942: END Apply_Attribute_Changes;

Line 2005: IF QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,

2001: FOR UPDATE NOWAIT;
2002:
2003: -- Row locked. Compare IN attributes to DB attributes.
2004:
2005: IF QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,
2006: l_PRICE_LIST_rec.attribute1)
2007: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2008: l_PRICE_LIST_rec.attribute10)
2009: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,

Line 2007: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,

2003: -- Row locked. Compare IN attributes to DB attributes.
2004:
2005: IF QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,
2006: l_PRICE_LIST_rec.attribute1)
2007: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2008: l_PRICE_LIST_rec.attribute10)
2009: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2010: l_PRICE_LIST_rec.attribute11)
2011: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,

Line 2009: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,

2005: IF QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,
2006: l_PRICE_LIST_rec.attribute1)
2007: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2008: l_PRICE_LIST_rec.attribute10)
2009: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2010: l_PRICE_LIST_rec.attribute11)
2011: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2012: l_PRICE_LIST_rec.attribute12)
2013: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,

Line 2011: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,

2007: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2008: l_PRICE_LIST_rec.attribute10)
2009: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2010: l_PRICE_LIST_rec.attribute11)
2011: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2012: l_PRICE_LIST_rec.attribute12)
2013: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2014: l_PRICE_LIST_rec.attribute13)
2015: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,

Line 2013: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,

2009: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2010: l_PRICE_LIST_rec.attribute11)
2011: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2012: l_PRICE_LIST_rec.attribute12)
2013: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2014: l_PRICE_LIST_rec.attribute13)
2015: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2016: l_PRICE_LIST_rec.attribute14)
2017: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,

Line 2015: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,

2011: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2012: l_PRICE_LIST_rec.attribute12)
2013: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2014: l_PRICE_LIST_rec.attribute13)
2015: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2016: l_PRICE_LIST_rec.attribute14)
2017: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2018: l_PRICE_LIST_rec.attribute15)
2019: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,

Line 2017: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,

2013: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2014: l_PRICE_LIST_rec.attribute13)
2015: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2016: l_PRICE_LIST_rec.attribute14)
2017: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2018: l_PRICE_LIST_rec.attribute15)
2019: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2020: l_PRICE_LIST_rec.attribute2)
2021: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,

Line 2019: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,

2015: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2016: l_PRICE_LIST_rec.attribute14)
2017: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2018: l_PRICE_LIST_rec.attribute15)
2019: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2020: l_PRICE_LIST_rec.attribute2)
2021: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2022: l_PRICE_LIST_rec.attribute3)
2023: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,

Line 2021: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,

2017: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2018: l_PRICE_LIST_rec.attribute15)
2019: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2020: l_PRICE_LIST_rec.attribute2)
2021: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2022: l_PRICE_LIST_rec.attribute3)
2023: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2024: l_PRICE_LIST_rec.attribute4)
2025: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,

Line 2023: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,

2019: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2020: l_PRICE_LIST_rec.attribute2)
2021: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2022: l_PRICE_LIST_rec.attribute3)
2023: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2024: l_PRICE_LIST_rec.attribute4)
2025: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2026: l_PRICE_LIST_rec.attribute5)
2027: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,

Line 2025: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,

2021: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2022: l_PRICE_LIST_rec.attribute3)
2023: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2024: l_PRICE_LIST_rec.attribute4)
2025: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2026: l_PRICE_LIST_rec.attribute5)
2027: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2028: l_PRICE_LIST_rec.attribute6)
2029: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,

Line 2027: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,

2023: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2024: l_PRICE_LIST_rec.attribute4)
2025: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2026: l_PRICE_LIST_rec.attribute5)
2027: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2028: l_PRICE_LIST_rec.attribute6)
2029: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2030: l_PRICE_LIST_rec.attribute7)
2031: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,

Line 2029: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,

2025: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2026: l_PRICE_LIST_rec.attribute5)
2027: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2028: l_PRICE_LIST_rec.attribute6)
2029: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2030: l_PRICE_LIST_rec.attribute7)
2031: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2032: l_PRICE_LIST_rec.attribute8)
2033: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,

Line 2031: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,

2027: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2028: l_PRICE_LIST_rec.attribute6)
2029: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2030: l_PRICE_LIST_rec.attribute7)
2031: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2032: l_PRICE_LIST_rec.attribute8)
2033: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2034: l_PRICE_LIST_rec.attribute9)
2035: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,

Line 2033: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,

2029: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2030: l_PRICE_LIST_rec.attribute7)
2031: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2032: l_PRICE_LIST_rec.attribute8)
2033: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2034: l_PRICE_LIST_rec.attribute9)
2035: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2036: l_PRICE_LIST_rec.automatic_flag)
2037: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,

Line 2035: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,

2031: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2032: l_PRICE_LIST_rec.attribute8)
2033: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2034: l_PRICE_LIST_rec.attribute9)
2035: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2036: l_PRICE_LIST_rec.automatic_flag)
2037: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2038: l_PRICE_LIST_rec.comments)
2039: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,

Line 2037: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,

2033: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2034: l_PRICE_LIST_rec.attribute9)
2035: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2036: l_PRICE_LIST_rec.automatic_flag)
2037: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2038: l_PRICE_LIST_rec.comments)
2039: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2040: l_PRICE_LIST_rec.context)
2041: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,

Line 2039: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,

2035: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2036: l_PRICE_LIST_rec.automatic_flag)
2037: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2038: l_PRICE_LIST_rec.comments)
2039: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2040: l_PRICE_LIST_rec.context)
2041: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2042: l_PRICE_LIST_rec.created_by)
2043: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,

Line 2041: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,

2037: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2038: l_PRICE_LIST_rec.comments)
2039: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2040: l_PRICE_LIST_rec.context)
2041: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2042: l_PRICE_LIST_rec.created_by)
2043: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2044: l_PRICE_LIST_rec.creation_date)
2045: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,

Line 2043: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,

2039: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2040: l_PRICE_LIST_rec.context)
2041: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2042: l_PRICE_LIST_rec.created_by)
2043: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2044: l_PRICE_LIST_rec.creation_date)
2045: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2046: l_PRICE_LIST_rec.currency_code)
2047: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,

Line 2045: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,

2041: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2042: l_PRICE_LIST_rec.created_by)
2043: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2044: l_PRICE_LIST_rec.creation_date)
2045: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2046: l_PRICE_LIST_rec.currency_code)
2047: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2048: l_PRICE_LIST_rec.discount_lines_flag)
2049: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

Line 2047: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,

2043: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2044: l_PRICE_LIST_rec.creation_date)
2045: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2046: l_PRICE_LIST_rec.currency_code)
2047: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2048: l_PRICE_LIST_rec.discount_lines_flag)
2049: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2050: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2051: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,

Line 2049: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

2045: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2046: l_PRICE_LIST_rec.currency_code)
2047: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2048: l_PRICE_LIST_rec.discount_lines_flag)
2049: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2050: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2051: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2052: l_PRICE_LIST_rec.freight_terms_code)
2053: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,

Line 2051: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,

2047: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2048: l_PRICE_LIST_rec.discount_lines_flag)
2049: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2050: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2051: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2052: l_PRICE_LIST_rec.freight_terms_code)
2053: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2054: l_PRICE_LIST_rec.gsa_indicator)
2055: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,

Line 2053: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,

2049: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2050: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2051: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2052: l_PRICE_LIST_rec.freight_terms_code)
2053: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2054: l_PRICE_LIST_rec.gsa_indicator)
2055: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2056: l_PRICE_LIST_rec.last_updated_by)
2057: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,

Line 2055: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,

2051: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2052: l_PRICE_LIST_rec.freight_terms_code)
2053: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2054: l_PRICE_LIST_rec.gsa_indicator)
2055: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2056: l_PRICE_LIST_rec.last_updated_by)
2057: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2058: l_PRICE_LIST_rec.last_update_date)
2059: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,

Line 2057: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,

2053: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2054: l_PRICE_LIST_rec.gsa_indicator)
2055: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2056: l_PRICE_LIST_rec.last_updated_by)
2057: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2058: l_PRICE_LIST_rec.last_update_date)
2059: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2060: l_PRICE_LIST_rec.last_update_login)
2061: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,

Line 2059: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,

2055: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2056: l_PRICE_LIST_rec.last_updated_by)
2057: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2058: l_PRICE_LIST_rec.last_update_date)
2059: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2060: l_PRICE_LIST_rec.last_update_login)
2061: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2062: l_PRICE_LIST_rec.list_header_id)
2063: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,

Line 2061: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,

2057: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2058: l_PRICE_LIST_rec.last_update_date)
2059: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2060: l_PRICE_LIST_rec.last_update_login)
2061: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2062: l_PRICE_LIST_rec.list_header_id)
2063: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2064: l_PRICE_LIST_rec.list_type_code)
2065: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,

Line 2063: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,

2059: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2060: l_PRICE_LIST_rec.last_update_login)
2061: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2062: l_PRICE_LIST_rec.list_header_id)
2063: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2064: l_PRICE_LIST_rec.list_type_code)
2065: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2066: l_PRICE_LIST_rec.program_application_id)
2067: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,

Line 2065: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,

2061: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2062: l_PRICE_LIST_rec.list_header_id)
2063: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2064: l_PRICE_LIST_rec.list_type_code)
2065: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2066: l_PRICE_LIST_rec.program_application_id)
2067: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2068: l_PRICE_LIST_rec.program_id)
2069: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,

Line 2067: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,

2063: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2064: l_PRICE_LIST_rec.list_type_code)
2065: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2066: l_PRICE_LIST_rec.program_application_id)
2067: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2068: l_PRICE_LIST_rec.program_id)
2069: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2070: l_PRICE_LIST_rec.program_update_date)
2071: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,

Line 2069: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,

2065: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2066: l_PRICE_LIST_rec.program_application_id)
2067: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2068: l_PRICE_LIST_rec.program_id)
2069: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2070: l_PRICE_LIST_rec.program_update_date)
2071: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2072: l_PRICE_LIST_rec.prorate_flag)
2073: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,

Line 2071: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,

2067: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2068: l_PRICE_LIST_rec.program_id)
2069: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2070: l_PRICE_LIST_rec.program_update_date)
2071: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2072: l_PRICE_LIST_rec.prorate_flag)
2073: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2074: l_PRICE_LIST_rec.request_id)
2075: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,

Line 2073: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,

2069: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2070: l_PRICE_LIST_rec.program_update_date)
2071: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2072: l_PRICE_LIST_rec.prorate_flag)
2073: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2074: l_PRICE_LIST_rec.request_id)
2075: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2076: l_PRICE_LIST_rec.rounding_factor)
2077: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,

Line 2075: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,

2071: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2072: l_PRICE_LIST_rec.prorate_flag)
2073: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2074: l_PRICE_LIST_rec.request_id)
2075: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2076: l_PRICE_LIST_rec.rounding_factor)
2077: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2078: l_PRICE_LIST_rec.ship_method_code)
2079: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

Line 2077: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,

2073: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2074: l_PRICE_LIST_rec.request_id)
2075: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2076: l_PRICE_LIST_rec.rounding_factor)
2077: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2078: l_PRICE_LIST_rec.ship_method_code)
2079: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2080: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2081: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,

Line 2079: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

2075: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2076: l_PRICE_LIST_rec.rounding_factor)
2077: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2078: l_PRICE_LIST_rec.ship_method_code)
2079: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2080: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2081: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2082: l_PRICE_LIST_rec.terms_id)
2083: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903

Line 2081: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,

2077: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2078: l_PRICE_LIST_rec.ship_method_code)
2079: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2080: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2081: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2082: l_PRICE_LIST_rec.terms_id)
2083: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903
2084: l_PRICE_LIST_rec.active_flag)
2085: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903

Line 2083: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903

2079: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2080: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2081: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2082: l_PRICE_LIST_rec.terms_id)
2083: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903
2084: l_PRICE_LIST_rec.active_flag)
2085: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903
2086: l_PRICE_LIST_rec.mobile_download)
2087: -- Multi-Currency Change SunilPandey

Line 2085: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903

2081: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2082: l_PRICE_LIST_rec.terms_id)
2083: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903
2084: l_PRICE_LIST_rec.active_flag)
2085: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903
2086: l_PRICE_LIST_rec.mobile_download)
2087: -- Multi-Currency Change SunilPandey
2088: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
2089: l_PRICE_LIST_rec.currency_header_id)

Line 2088: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,

2084: l_PRICE_LIST_rec.active_flag)
2085: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903
2086: l_PRICE_LIST_rec.mobile_download)
2087: -- Multi-Currency Change SunilPandey
2088: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
2089: l_PRICE_LIST_rec.currency_header_id)
2090: -- Blanket Sales Order
2091: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
2092: l_PRICE_LIST_rec.list_source_code)

Line 2091: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,

2087: -- Multi-Currency Change SunilPandey
2088: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
2089: l_PRICE_LIST_rec.currency_header_id)
2090: -- Blanket Sales Order
2091: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
2092: l_PRICE_LIST_rec.list_source_code)
2093: -- Bug # 5128941
2094: --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
2095: -- l_PRICE_LIST_rec.orig_system_header_ref)

Line 2094: --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,

2090: -- Blanket Sales Order
2091: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
2092: l_PRICE_LIST_rec.list_source_code)
2093: -- Bug # 5128941
2094: --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
2095: -- l_PRICE_LIST_rec.orig_system_header_ref)
2096: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire
2097: l_PRICE_LIST_rec.global_flag)
2098: -- Blanket Pricing

Line 2096: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire

2092: l_PRICE_LIST_rec.list_source_code)
2093: -- Bug # 5128941
2094: --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
2095: -- l_PRICE_LIST_rec.orig_system_header_ref)
2096: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire
2097: l_PRICE_LIST_rec.global_flag)
2098: -- Blanket Pricing
2099: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2100: l_PRICE_LIST_rec.source_system_code)

Line 2099: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,

2095: -- l_PRICE_LIST_rec.orig_system_header_ref)
2096: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire
2097: l_PRICE_LIST_rec.global_flag)
2098: -- Blanket Pricing
2099: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2100: l_PRICE_LIST_rec.source_system_code)
2101: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2102: l_PRICE_LIST_rec.shareable_flag)
2103: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,

Line 2101: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,

2097: l_PRICE_LIST_rec.global_flag)
2098: -- Blanket Pricing
2099: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2100: l_PRICE_LIST_rec.source_system_code)
2101: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2102: l_PRICE_LIST_rec.shareable_flag)
2103: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
2104: l_PRICE_LIST_rec.sold_to_org_id)
2105: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,

Line 2103: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,

2099: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2100: l_PRICE_LIST_rec.source_system_code)
2101: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2102: l_PRICE_LIST_rec.shareable_flag)
2103: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
2104: l_PRICE_LIST_rec.sold_to_org_id)
2105: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
2106: l_PRICE_LIST_rec.locked_from_list_header_id)
2107: --added for MOAC

Line 2105: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,

2101: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2102: l_PRICE_LIST_rec.shareable_flag)
2103: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
2104: l_PRICE_LIST_rec.sold_to_org_id)
2105: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
2106: l_PRICE_LIST_rec.locked_from_list_header_id)
2107: --added for MOAC
2108: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,
2109: l_PRICE_LIST_rec.org_id)

Line 2108: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,

2104: l_PRICE_LIST_rec.sold_to_org_id)
2105: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
2106: l_PRICE_LIST_rec.locked_from_list_header_id)
2107: --added for MOAC
2108: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,
2109: l_PRICE_LIST_rec.org_id)
2110: THEN
2111:
2112: -- Row has not changed. Set out parameter.

Line 2124: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.list_source_code,l_PRICE_LIST_rec.list_source_code) then

2120:
2121: oe_debug_pub.add('success 1');
2122:
2123: ELSE
2124: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.list_source_code,l_PRICE_LIST_rec.list_source_code) then
2125: -- Row has changed by another user.
2126: oe_debug_pub.add('Passed Value: LSC'||p_PRICE_LIST_rec.list_source_code);
2127: oe_debug_pub.add('DB Value: LSC'||l_PRICE_LIST_rec.list_source_code);
2128:

Line 2131: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.orig_system_header_ref,l_PRICE_LIST_rec.orig_system_header_ref) then

2127: oe_debug_pub.add('DB Value: LSC'||l_PRICE_LIST_rec.list_source_code);
2128:
2129: end if ;
2130:
2131: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.orig_system_header_ref,l_PRICE_LIST_rec.orig_system_header_ref) then
2132:
2133: oe_debug_pub.add('Passed Value: OSHR'||p_PRICE_LIST_rec.orig_system_header_ref);
2134:
2135:

Line 2238: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,

2234: BEGIN
2235:
2236: IF p_PRICE_LIST_rec.automatic_flag IS NOT NULL AND
2237: p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2238: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2239: p_old_PRICE_LIST_rec.automatic_flag)
2240: THEN
2241: l_PRICE_LIST_val_rec.automatic := QP_Id_To_Value.Automatic
2242: ( p_automatic_flag => p_PRICE_LIST_rec.automatic_flag

Line 2248: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,

2244: END IF;
2245:
2246: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
2247: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2248: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2249: p_old_PRICE_LIST_rec.currency_code)
2250: THEN
2251: l_PRICE_LIST_val_rec.currency := QP_Id_To_Value.Currency
2252: ( p_currency_code => p_PRICE_LIST_rec.currency_code

Line 2258: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,

2254: END IF;
2255:
2256: IF p_PRICE_LIST_rec.discount_lines_flag IS NOT NULL AND
2257: p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2258: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2259: p_old_PRICE_LIST_rec.discount_lines_flag)
2260: THEN
2261: l_PRICE_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines
2262: ( p_discount_lines_flag => p_PRICE_LIST_rec.discount_lines_flag

Line 2268: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,

2264: END IF;
2265:
2266: IF p_PRICE_LIST_rec.freight_terms_code IS NOT NULL AND
2267: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2268: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2269: p_old_PRICE_LIST_rec.freight_terms_code)
2270: THEN
2271: l_PRICE_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms
2272: ( p_freight_terms_code => p_PRICE_LIST_rec.freight_terms_code

Line 2278: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,

2274: END IF;
2275:
2276: IF p_PRICE_LIST_rec.list_header_id IS NOT NULL AND
2277: p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2278: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2279: p_old_PRICE_LIST_rec.list_header_id)
2280: THEN
2281: l_PRICE_LIST_val_rec.list_header := QP_Id_To_Value.List_Header
2282: ( p_list_header_id => p_PRICE_LIST_rec.list_header_id

Line 2288: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,

2284: END IF;
2285:
2286: IF p_PRICE_LIST_rec.list_type_code IS NOT NULL AND
2287: p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2288: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2289: p_old_PRICE_LIST_rec.list_type_code)
2290: THEN
2291: l_PRICE_LIST_val_rec.list_type := QP_Id_To_Value.List_Type
2292: ( p_list_type_code => p_PRICE_LIST_rec.list_type_code

Line 2298: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,

2294: END IF;
2295:
2296: IF p_PRICE_LIST_rec.prorate_flag IS NOT NULL AND
2297: p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2298: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2299: p_old_PRICE_LIST_rec.prorate_flag)
2300: THEN
2301: l_PRICE_LIST_val_rec.prorate := QP_Id_To_Value.Prorate
2302: ( p_prorate_flag => p_PRICE_LIST_rec.prorate_flag

Line 2308: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,

2304: END IF;
2305:
2306: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND
2307: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2308: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2309: p_old_PRICE_LIST_rec.ship_method_code)
2310: THEN
2311: l_PRICE_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method
2312: ( p_ship_method_code => p_PRICE_LIST_rec.ship_method_code

Line 2318: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,

2314: END IF;
2315:
2316: IF p_PRICE_LIST_rec.terms_id IS NOT NULL AND
2317: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2318: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2319: p_old_PRICE_LIST_rec.terms_id)
2320: THEN
2321: l_PRICE_LIST_val_rec.terms := QP_Id_To_Value.Terms
2322: ( p_terms_id => p_PRICE_LIST_rec.terms_id