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 655: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

651: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
652: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
653: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
654: qp_delayed_requests_pvt.log_request(
655: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
656: p_entity_id => p_PRICE_LIST_rec.list_header_id,
657: p_request_unique_key1 => NULL,
658: p_request_unique_key2 => 'UD',
659: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 659: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

655: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
656: p_entity_id => p_PRICE_LIST_rec.list_header_id,
657: p_request_unique_key1 => NULL,
658: p_request_unique_key2 => 'UD',
659: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
660: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
661: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
662: x_return_status => x_PRICE_LIST_rec.return_status);
663: END IF;

Line 661: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

657: p_request_unique_key1 => NULL,
658: p_request_unique_key2 => 'UD',
659: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
660: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
661: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
662: x_return_status => x_PRICE_LIST_rec.return_status);
663: END IF;
664: END IF;
665: END IF;

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

665: END IF;
666:
667: END IF;
668:
669: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,p_old_PRICE_LIST_rec.discount_lines_flag)
670: THEN
671: NULL;
672: END IF;
673:

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

670: THEN
671: NULL;
672: END IF;
673:
674: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.end_date_active,p_old_PRICE_LIST_rec.end_date_active)
675: THEN
676: -- NULL;
677: -- jagan's PL/SQL pattern
678: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN

Line 682: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

678: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
679: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
680: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
681: qp_delayed_requests_pvt.log_request(
682: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
683: p_entity_id => p_PRICE_LIST_rec.list_header_id,
684: p_request_unique_key1 => NULL,
685: p_request_unique_key2 => 'UD',
686: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 686: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

682: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
683: p_entity_id => p_PRICE_LIST_rec.list_header_id,
684: p_request_unique_key1 => NULL,
685: p_request_unique_key2 => 'UD',
686: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
687: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
688: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
689: x_return_status => x_PRICE_LIST_rec.return_status);
690: END IF;

Line 688: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

684: p_request_unique_key1 => NULL,
685: p_request_unique_key2 => 'UD',
686: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
687: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
688: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
689: x_return_status => x_PRICE_LIST_rec.return_status);
690: END IF;
691: END IF;
692: END IF;

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

694: END IF;
695:
696: /* Bug 1856788 Added the if condition to propogate the change in active_flag of price_list to qualifiers
697: of the price_list */
698: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag,p_old_PRICE_LIST_rec.active_flag)
699: THEN
700: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
701: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
702: qp_delayed_requests_pvt.log_request(

Line 703: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

699: THEN
700: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
701: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
702: qp_delayed_requests_pvt.log_request(
703: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
704: p_entity_id => p_PRICE_LIST_rec.list_header_id,
705: p_request_unique_key1 => NULL,
706: p_request_unique_key2 => 'UD',
707: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 707: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

703: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
704: p_entity_id => p_PRICE_LIST_rec.list_header_id,
705: p_request_unique_key1 => NULL,
706: p_request_unique_key2 => 'UD',
707: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
708: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
709: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
710: x_return_status => x_PRICE_LIST_rec.return_status);
711: END IF;

Line 709: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

705: p_request_unique_key1 => NULL,
706: p_request_unique_key2 => 'UD',
707: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
708: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
709: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
710: x_return_status => x_PRICE_LIST_rec.return_status);
711: END IF;
712: END IF; --Java Engine Installed
713: -- pattern

Line 719: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

715: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
716: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
717: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
718: qp_delayed_requests_pvt.log_request(
719: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
720: p_entity_id => p_PRICE_LIST_rec.list_header_id,
721: p_request_unique_key1 => NULL,
722: p_request_unique_key2 => 'UD',
723: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 723: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

719: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
720: p_entity_id => p_PRICE_LIST_rec.list_header_id,
721: p_request_unique_key1 => NULL,
722: p_request_unique_key2 => 'UD',
723: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
724: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
725: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
726: x_return_status => x_PRICE_LIST_rec.return_status);
727: END IF;

Line 725: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

721: p_request_unique_key1 => NULL,
722: p_request_unique_key2 => 'UD',
723: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
724: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
725: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
726: x_return_status => x_PRICE_LIST_rec.return_status);
727: END IF;
728: END IF;
729: END IF;

Line 733: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

729: END IF;
730:
731:
732: -- added for bug 2912834
733: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
734: THEN
735:
736: UPDATE qp_qualifiers
737: SET active_flag = p_PRICE_LIST_rec.active_flag

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

781: END IF;
782:
783: END IF;
784: -- mkarya for bug 1944882
785: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download,p_old_PRICE_LIST_rec.mobile_download)
786: THEN
787: NULL;
788: END IF;
789:

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

787: NULL;
788: END IF;
789:
790: -- Pricing Security gtippire
791: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag,p_old_PRICE_LIST_rec.global_flag)
792: THEN
793: -- NULL;
794: -- jagan's PL/SQL pattern
795: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN

Line 799: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

795: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
796: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
797: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
798: qp_delayed_requests_pvt.log_request(
799: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
800: p_entity_id => p_PRICE_LIST_rec.list_header_id,
801: p_request_unique_key1 => NULL,
802: p_request_unique_key2 => 'UD',
803: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 803: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

799: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
800: p_entity_id => p_PRICE_LIST_rec.list_header_id,
801: p_request_unique_key1 => NULL,
802: p_request_unique_key2 => 'UD',
803: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
804: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
805: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
806: x_return_status => x_PRICE_LIST_rec.return_status);
807: END IF;

Line 805: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

801: p_request_unique_key1 => NULL,
802: p_request_unique_key2 => 'UD',
803: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
804: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
805: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
806: x_return_status => x_PRICE_LIST_rec.return_status);
807: END IF;
808: END IF;
809: END IF;

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

814: oe_debug_pub.add('QPXUPLHB - currency_header_id = ' || p_PRICE_LIST_rec.currency_header_id);
815: oe_debug_pub.add('QPXUPLHB - old currency_header_id = ' || p_old_PRICE_LIST_rec.currency_header_id);
816: oe_debug_pub.add('QPXUPLHB - rounding_factor = ' || p_PRICE_LIST_rec.rounding_factor);
817: -- Multi-Currency SunilPandey
818: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)
819: THEN
820: -- NULL;
821: if p_PRICE_LIST_rec.currency_header_id is not null then
822: select BASE_ROUNDING_FACTOR

Line 832: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

828: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
829: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
830: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
831: qp_delayed_requests_pvt.log_request(
832: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
833: p_entity_id => p_PRICE_LIST_rec.list_header_id,
834: p_request_unique_key1 => NULL,
835: p_request_unique_key2 => 'UD',
836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

832: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
833: p_entity_id => p_PRICE_LIST_rec.list_header_id,
834: p_request_unique_key1 => NULL,
835: p_request_unique_key2 => 'UD',
836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
837: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
838: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
839: x_return_status => x_PRICE_LIST_rec.return_status);
840: END IF;

Line 838: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

834: p_request_unique_key1 => NULL,
835: p_request_unique_key2 => 'UD',
836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
837: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
838: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
839: x_return_status => x_PRICE_LIST_rec.return_status);
840: END IF;
841: END IF;
842: END IF;

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

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

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

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

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

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

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

858: THEN
859: NULL;
860: END IF;
861:
862: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,p_old_PRICE_LIST_rec.last_updated_by)
863: THEN
864: NULL;
865: END IF;
866:

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

863: THEN
864: NULL;
865: END IF;
866:
867: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,p_old_PRICE_LIST_rec.last_update_date)
868: THEN
869: NULL;
870: END IF;
871:

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

868: THEN
869: NULL;
870: END IF;
871:
872: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,p_old_PRICE_LIST_rec.last_update_login)
873: THEN
874: NULL;
875: END IF;
876:

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

873: THEN
874: NULL;
875: END IF;
876:
877: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.name,p_old_PRICE_LIST_rec.name)
878: THEN
879: IF NOT QP_Validate.Price_List_Name(p_PRICE_LIST_rec.name,
880: p_PRICE_LIST_rec.list_header_id,
881: p_PRICE_LIST_rec.version_no) THEN

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

882: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
883: END IF;
884: END IF;
885:
886: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.description,p_old_PRICE_LIST_rec.description)
887: THEN
888: NULL;
889: END IF;
890:

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

887: THEN
888: NULL;
889: END IF;
890:
891: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,p_old_PRICE_LIST_rec.list_header_id)
892: THEN
893: NULL;
894: END IF;
895:

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

892: THEN
893: NULL;
894: END IF;
895:
896: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,p_old_PRICE_LIST_rec.list_type_code)
897: THEN
898: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
899: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
900: qp_delayed_requests_pvt.log_request(

Line 901: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

897: THEN
898: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
899: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
900: qp_delayed_requests_pvt.log_request(
901: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
902: p_entity_id => p_PRICE_LIST_rec.list_header_id,
903: p_request_unique_key1 => NULL,
904: p_request_unique_key2 => 'UD',
905: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 905: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

901: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
902: p_entity_id => p_PRICE_LIST_rec.list_header_id,
903: p_request_unique_key1 => NULL,
904: p_request_unique_key2 => 'UD',
905: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
906: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
907: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
908: x_return_status => x_PRICE_LIST_rec.return_status);
909: END IF;

Line 907: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

903: p_request_unique_key1 => NULL,
904: p_request_unique_key2 => 'UD',
905: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
906: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
907: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
908: x_return_status => x_PRICE_LIST_rec.return_status);
909: END IF;
910: END IF; --Java Engine Installed
911: -- pattern

Line 917: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

913: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
914: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
915: IF(p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
916: qp_delayed_requests_pvt.log_request(
917: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
918: p_entity_id => p_PRICE_LIST_rec.list_header_id,
919: p_request_unique_key1 => NULL,
920: p_request_unique_key2 => 'UD',
921: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 921: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

917: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
918: p_entity_id => p_PRICE_LIST_rec.list_header_id,
919: p_request_unique_key1 => NULL,
920: p_request_unique_key2 => 'UD',
921: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
922: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
923: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
924: x_return_status => x_PRICE_LIST_rec.return_status);
925: END IF;

Line 923: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

919: p_request_unique_key1 => NULL,
920: p_request_unique_key2 => 'UD',
921: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
922: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
923: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
924: x_return_status => x_PRICE_LIST_rec.return_status);
925: END IF;
926: END IF;
927: END IF;

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

928:
929: NULL;
930: END IF;
931:
932: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.version_no,p_old_PRICE_LIST_rec.version_no)
933: THEN
934: NULL;
935: END IF;
936:

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

933: THEN
934: NULL;
935: END IF;
936:
937: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,p_old_PRICE_LIST_rec.program_application_id)
938: THEN
939: NULL;
940: END IF;
941:

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

938: THEN
939: NULL;
940: END IF;
941:
942: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,p_old_PRICE_LIST_rec.program_id)
943: THEN
944: NULL;
945: END IF;
946:

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

943: THEN
944: NULL;
945: END IF;
946:
947: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,p_old_PRICE_LIST_rec.program_update_date)
948: THEN
949: NULL;
950: END IF;
951:

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

948: THEN
949: NULL;
950: END IF;
951:
952: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,p_old_PRICE_LIST_rec.prorate_flag)
953: THEN
954: NULL;
955: END IF;
956:

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

953: THEN
954: NULL;
955: END IF;
956:
957: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,p_old_PRICE_LIST_rec.request_id)
958: THEN
959: NULL;
960: END IF;
961:

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

958: THEN
959: NULL;
960: END IF;
961:
962: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,p_old_PRICE_LIST_rec.rounding_factor)
963: THEN
964: /*
965: IF NOT QP_Validate.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor,
966: p_PRICE_LIST_rec.currency_code)

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

970: */
971: null;
972: END IF;
973:
974: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,p_old_PRICE_LIST_rec.ship_method_code)
975: THEN
976: NULL;
977: END IF;
978:

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

975: THEN
976: NULL;
977: END IF;
978:
979: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.start_date_active,p_old_PRICE_LIST_rec.start_date_active)
980: THEN
981: -- NULL;
982: -- jagan's PL/SQL pattern
983: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN

Line 987: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

983: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
984: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
985: IF (p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
986: qp_delayed_requests_pvt.log_request(
987: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
988: p_entity_id => p_PRICE_LIST_rec.list_header_id,
989: p_request_unique_key1 => NULL,
990: p_request_unique_key2 => 'UD',
991: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 991: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

987: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
988: p_entity_id => p_PRICE_LIST_rec.list_header_id,
989: p_request_unique_key1 => NULL,
990: p_request_unique_key2 => 'UD',
991: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
992: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
993: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
994: x_return_status => x_PRICE_LIST_rec.return_status);
995: END IF;

Line 993: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

989: p_request_unique_key1 => NULL,
990: p_request_unique_key2 => 'UD',
991: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
992: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
993: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
994: x_return_status => x_PRICE_LIST_rec.return_status);
995: END IF;
996: END IF;
997: END IF;

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

997: END IF;
998:
999: END IF;
1000:
1001: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,p_old_PRICE_LIST_rec.terms_id)
1002: THEN
1003: NULL;
1004: END IF;
1005:

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

1003: NULL;
1004: END IF;
1005:
1006: -- Blanket Sales Order
1007: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,p_old_PRICE_LIST_rec.list_source_code)
1008: THEN
1009: NULL;
1010: END IF;
1011:

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

1008: THEN
1009: NULL;
1010: END IF;
1011:
1012: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,p_old_PRICE_LIST_rec.orig_system_header_ref)
1013: THEN
1014: NULL;
1015: END IF;
1016:

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

1014: NULL;
1015: END IF;
1016:
1017: -- Blanket Pricing
1018: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code, p_old_PRICE_LIST_rec.source_system_code)
1019: THEN
1020: NULL;
1021: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1022: IF( p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 1024: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1020: NULL;
1021: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1022: IF( p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1023: qp_delayed_requests_pvt.log_request(
1024: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1025: p_entity_id => p_PRICE_LIST_rec.list_header_id,
1026: p_request_unique_key1 => NULL,
1027: p_request_unique_key2 => 'UD',
1028: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1028: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1024: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1025: p_entity_id => p_PRICE_LIST_rec.list_header_id,
1026: p_request_unique_key1 => NULL,
1027: p_request_unique_key2 => 'UD',
1028: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1029: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
1030: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1031: x_return_status => x_PRICE_LIST_rec.return_status);
1032: END IF;

Line 1030: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1026: p_request_unique_key1 => NULL,
1027: p_request_unique_key2 => 'UD',
1028: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1029: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
1030: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1031: x_return_status => x_PRICE_LIST_rec.return_status);
1032: END IF;
1033: END IF; --Java Engine Installed
1034: -- pattern

Line 1040: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1036: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1037: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1038: IF( p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1039: qp_delayed_requests_pvt.log_request(
1040: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1041: p_entity_id => p_PRICE_LIST_rec.list_header_id,
1042: p_request_unique_key1 => NULL,
1043: p_request_unique_key2 => 'UD',
1044: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1044: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1040: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1041: p_entity_id => p_PRICE_LIST_rec.list_header_id,
1042: p_request_unique_key1 => NULL,
1043: p_request_unique_key2 => 'UD',
1044: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1045: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
1046: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1047: x_return_status => x_PRICE_LIST_rec.return_status);
1048: END IF;

Line 1046: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1042: p_request_unique_key1 => NULL,
1043: p_request_unique_key2 => 'UD',
1044: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1045: p_requesting_entity_id => p_PRICE_LIST_rec.list_header_id,
1046: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1047: x_return_status => x_PRICE_LIST_rec.return_status);
1048: END IF;
1049: END IF;
1050: END IF;

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

1050: END IF;
1051:
1052: END IF;
1053:
1054: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag, p_old_PRICE_LIST_rec.shareable_flag)
1055: THEN
1056: NULL;
1057: END IF;
1058:

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

1055: THEN
1056: NULL;
1057: END IF;
1058:
1059: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id, p_old_PRICE_LIST_rec.sold_to_org_id)
1060: THEN
1061: NULL;
1062: END IF;
1063:

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

1061: NULL;
1062: END IF;
1063:
1064: --Added for Price List Locking
1065: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id, p_old_PRICE_LIST_rec.locked_from_list_header_id)
1066: THEN
1067: NULL;
1068: END IF;
1069:

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

1067: NULL;
1068: END IF;
1069:
1070: --added for MOAC
1071: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id, p_old_PRICE_LIST_rec.org_id)
1072: THEN
1073: NULL;
1074: END IF;
1075: END Apply_Attribute_Changes;

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

2140: FOR UPDATE NOWAIT;
2141:
2142: -- Row locked. Compare IN attributes to DB attributes.
2143:
2144: IF QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,
2145: l_PRICE_LIST_rec.attribute1)
2146: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2147: l_PRICE_LIST_rec.attribute10)
2148: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,

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

2142: -- Row locked. Compare IN attributes to DB attributes.
2143:
2144: IF QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,
2145: l_PRICE_LIST_rec.attribute1)
2146: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2147: l_PRICE_LIST_rec.attribute10)
2148: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2149: l_PRICE_LIST_rec.attribute11)
2150: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,

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

2144: IF QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute1,
2145: l_PRICE_LIST_rec.attribute1)
2146: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2147: l_PRICE_LIST_rec.attribute10)
2148: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2149: l_PRICE_LIST_rec.attribute11)
2150: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2151: l_PRICE_LIST_rec.attribute12)
2152: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,

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

2146: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute10,
2147: l_PRICE_LIST_rec.attribute10)
2148: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2149: l_PRICE_LIST_rec.attribute11)
2150: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2151: l_PRICE_LIST_rec.attribute12)
2152: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2153: l_PRICE_LIST_rec.attribute13)
2154: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,

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

2148: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute11,
2149: l_PRICE_LIST_rec.attribute11)
2150: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2151: l_PRICE_LIST_rec.attribute12)
2152: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2153: l_PRICE_LIST_rec.attribute13)
2154: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2155: l_PRICE_LIST_rec.attribute14)
2156: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,

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

2150: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute12,
2151: l_PRICE_LIST_rec.attribute12)
2152: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2153: l_PRICE_LIST_rec.attribute13)
2154: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2155: l_PRICE_LIST_rec.attribute14)
2156: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2157: l_PRICE_LIST_rec.attribute15)
2158: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,

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

2152: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute13,
2153: l_PRICE_LIST_rec.attribute13)
2154: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2155: l_PRICE_LIST_rec.attribute14)
2156: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2157: l_PRICE_LIST_rec.attribute15)
2158: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2159: l_PRICE_LIST_rec.attribute2)
2160: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,

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

2154: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute14,
2155: l_PRICE_LIST_rec.attribute14)
2156: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2157: l_PRICE_LIST_rec.attribute15)
2158: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2159: l_PRICE_LIST_rec.attribute2)
2160: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2161: l_PRICE_LIST_rec.attribute3)
2162: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,

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

2156: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute15,
2157: l_PRICE_LIST_rec.attribute15)
2158: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2159: l_PRICE_LIST_rec.attribute2)
2160: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2161: l_PRICE_LIST_rec.attribute3)
2162: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2163: l_PRICE_LIST_rec.attribute4)
2164: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,

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

2158: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute2,
2159: l_PRICE_LIST_rec.attribute2)
2160: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2161: l_PRICE_LIST_rec.attribute3)
2162: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2163: l_PRICE_LIST_rec.attribute4)
2164: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2165: l_PRICE_LIST_rec.attribute5)
2166: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,

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

2160: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute3,
2161: l_PRICE_LIST_rec.attribute3)
2162: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2163: l_PRICE_LIST_rec.attribute4)
2164: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2165: l_PRICE_LIST_rec.attribute5)
2166: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2167: l_PRICE_LIST_rec.attribute6)
2168: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,

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

2162: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute4,
2163: l_PRICE_LIST_rec.attribute4)
2164: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2165: l_PRICE_LIST_rec.attribute5)
2166: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2167: l_PRICE_LIST_rec.attribute6)
2168: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2169: l_PRICE_LIST_rec.attribute7)
2170: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,

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

2164: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute5,
2165: l_PRICE_LIST_rec.attribute5)
2166: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2167: l_PRICE_LIST_rec.attribute6)
2168: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2169: l_PRICE_LIST_rec.attribute7)
2170: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2171: l_PRICE_LIST_rec.attribute8)
2172: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,

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

2166: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute6,
2167: l_PRICE_LIST_rec.attribute6)
2168: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2169: l_PRICE_LIST_rec.attribute7)
2170: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2171: l_PRICE_LIST_rec.attribute8)
2172: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2173: l_PRICE_LIST_rec.attribute9)
2174: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,

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

2168: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute7,
2169: l_PRICE_LIST_rec.attribute7)
2170: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2171: l_PRICE_LIST_rec.attribute8)
2172: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2173: l_PRICE_LIST_rec.attribute9)
2174: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2175: l_PRICE_LIST_rec.automatic_flag)
2176: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,

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

2170: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute8,
2171: l_PRICE_LIST_rec.attribute8)
2172: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2173: l_PRICE_LIST_rec.attribute9)
2174: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2175: l_PRICE_LIST_rec.automatic_flag)
2176: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2177: l_PRICE_LIST_rec.comments)
2178: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,

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

2172: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.attribute9,
2173: l_PRICE_LIST_rec.attribute9)
2174: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2175: l_PRICE_LIST_rec.automatic_flag)
2176: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2177: l_PRICE_LIST_rec.comments)
2178: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2179: l_PRICE_LIST_rec.context)
2180: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,

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

2174: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2175: l_PRICE_LIST_rec.automatic_flag)
2176: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2177: l_PRICE_LIST_rec.comments)
2178: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2179: l_PRICE_LIST_rec.context)
2180: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2181: l_PRICE_LIST_rec.created_by)
2182: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,

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

2176: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.comments,
2177: l_PRICE_LIST_rec.comments)
2178: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2179: l_PRICE_LIST_rec.context)
2180: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2181: l_PRICE_LIST_rec.created_by)
2182: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2183: l_PRICE_LIST_rec.creation_date)
2184: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,

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

2178: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.context,
2179: l_PRICE_LIST_rec.context)
2180: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2181: l_PRICE_LIST_rec.created_by)
2182: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2183: l_PRICE_LIST_rec.creation_date)
2184: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2185: l_PRICE_LIST_rec.currency_code)
2186: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,

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

2180: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.created_by,
2181: l_PRICE_LIST_rec.created_by)
2182: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2183: l_PRICE_LIST_rec.creation_date)
2184: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2185: l_PRICE_LIST_rec.currency_code)
2186: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2187: l_PRICE_LIST_rec.discount_lines_flag)
2188: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

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

2182: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.creation_date,
2183: l_PRICE_LIST_rec.creation_date)
2184: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2185: l_PRICE_LIST_rec.currency_code)
2186: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2187: l_PRICE_LIST_rec.discount_lines_flag)
2188: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2189: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2190: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,

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

2184: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2185: l_PRICE_LIST_rec.currency_code)
2186: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2187: l_PRICE_LIST_rec.discount_lines_flag)
2188: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2189: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2190: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2191: l_PRICE_LIST_rec.freight_terms_code)
2192: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,

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

2186: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2187: l_PRICE_LIST_rec.discount_lines_flag)
2188: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2189: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2190: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2191: l_PRICE_LIST_rec.freight_terms_code)
2192: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2193: l_PRICE_LIST_rec.gsa_indicator)
2194: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,

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

2188: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2189: to_date(to_char(l_PRICE_LIST_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2190: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2191: l_PRICE_LIST_rec.freight_terms_code)
2192: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2193: l_PRICE_LIST_rec.gsa_indicator)
2194: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2195: l_PRICE_LIST_rec.last_updated_by)
2196: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,

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

2190: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2191: l_PRICE_LIST_rec.freight_terms_code)
2192: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2193: l_PRICE_LIST_rec.gsa_indicator)
2194: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2195: l_PRICE_LIST_rec.last_updated_by)
2196: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2197: l_PRICE_LIST_rec.last_update_date)
2198: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,

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

2192: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.gsa_indicator,
2193: l_PRICE_LIST_rec.gsa_indicator)
2194: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2195: l_PRICE_LIST_rec.last_updated_by)
2196: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2197: l_PRICE_LIST_rec.last_update_date)
2198: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2199: l_PRICE_LIST_rec.last_update_login)
2200: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,

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

2194: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_updated_by,
2195: l_PRICE_LIST_rec.last_updated_by)
2196: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2197: l_PRICE_LIST_rec.last_update_date)
2198: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2199: l_PRICE_LIST_rec.last_update_login)
2200: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2201: l_PRICE_LIST_rec.list_header_id)
2202: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,

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

2196: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_date,
2197: l_PRICE_LIST_rec.last_update_date)
2198: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2199: l_PRICE_LIST_rec.last_update_login)
2200: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2201: l_PRICE_LIST_rec.list_header_id)
2202: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2203: l_PRICE_LIST_rec.list_type_code)
2204: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,

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

2198: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.last_update_login,
2199: l_PRICE_LIST_rec.last_update_login)
2200: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2201: l_PRICE_LIST_rec.list_header_id)
2202: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2203: l_PRICE_LIST_rec.list_type_code)
2204: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2205: l_PRICE_LIST_rec.program_application_id)
2206: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,

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

2200: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2201: l_PRICE_LIST_rec.list_header_id)
2202: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2203: l_PRICE_LIST_rec.list_type_code)
2204: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2205: l_PRICE_LIST_rec.program_application_id)
2206: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2207: l_PRICE_LIST_rec.program_id)
2208: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,

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

2202: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2203: l_PRICE_LIST_rec.list_type_code)
2204: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2205: l_PRICE_LIST_rec.program_application_id)
2206: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2207: l_PRICE_LIST_rec.program_id)
2208: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2209: l_PRICE_LIST_rec.program_update_date)
2210: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,

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

2204: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_application_id,
2205: l_PRICE_LIST_rec.program_application_id)
2206: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2207: l_PRICE_LIST_rec.program_id)
2208: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2209: l_PRICE_LIST_rec.program_update_date)
2210: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2211: l_PRICE_LIST_rec.prorate_flag)
2212: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,

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

2206: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_id,
2207: l_PRICE_LIST_rec.program_id)
2208: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2209: l_PRICE_LIST_rec.program_update_date)
2210: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2211: l_PRICE_LIST_rec.prorate_flag)
2212: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2213: l_PRICE_LIST_rec.request_id)
2214: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,

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

2208: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.program_update_date,
2209: l_PRICE_LIST_rec.program_update_date)
2210: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2211: l_PRICE_LIST_rec.prorate_flag)
2212: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2213: l_PRICE_LIST_rec.request_id)
2214: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2215: l_PRICE_LIST_rec.rounding_factor)
2216: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,

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

2210: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2211: l_PRICE_LIST_rec.prorate_flag)
2212: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2213: l_PRICE_LIST_rec.request_id)
2214: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2215: l_PRICE_LIST_rec.rounding_factor)
2216: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2217: l_PRICE_LIST_rec.ship_method_code)
2218: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

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

2212: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.request_id,
2213: l_PRICE_LIST_rec.request_id)
2214: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2215: l_PRICE_LIST_rec.rounding_factor)
2216: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2217: l_PRICE_LIST_rec.ship_method_code)
2218: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2219: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2220: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,

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

2214: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.rounding_factor,
2215: l_PRICE_LIST_rec.rounding_factor)
2216: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2217: l_PRICE_LIST_rec.ship_method_code)
2218: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2219: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2220: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2221: l_PRICE_LIST_rec.terms_id)
2222: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903

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

2216: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2217: l_PRICE_LIST_rec.ship_method_code)
2218: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2219: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2220: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2221: l_PRICE_LIST_rec.terms_id)
2222: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903
2223: l_PRICE_LIST_rec.active_flag)
2224: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903

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

2218: AND QP_GLOBALS.Equal(to_date(to_char(p_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
2219: to_date(to_char(l_PRICE_LIST_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
2220: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2221: l_PRICE_LIST_rec.terms_id)
2222: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903
2223: l_PRICE_LIST_rec.active_flag)
2224: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903
2225: l_PRICE_LIST_rec.mobile_download)
2226: -- Multi-Currency Change SunilPandey

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

2220: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2221: l_PRICE_LIST_rec.terms_id)
2222: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.active_flag, -- Added by dhgupta for bug 2144903
2223: l_PRICE_LIST_rec.active_flag)
2224: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903
2225: l_PRICE_LIST_rec.mobile_download)
2226: -- Multi-Currency Change SunilPandey
2227: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
2228: l_PRICE_LIST_rec.currency_header_id)

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

2223: l_PRICE_LIST_rec.active_flag)
2224: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.mobile_download, -- Added by dhgupta for bug 2144903
2225: l_PRICE_LIST_rec.mobile_download)
2226: -- Multi-Currency Change SunilPandey
2227: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
2228: l_PRICE_LIST_rec.currency_header_id)
2229: -- Blanket Sales Order
2230: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
2231: l_PRICE_LIST_rec.list_source_code)

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

2226: -- Multi-Currency Change SunilPandey
2227: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,
2228: l_PRICE_LIST_rec.currency_header_id)
2229: -- Blanket Sales Order
2230: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
2231: l_PRICE_LIST_rec.list_source_code)
2232: -- Bug # 5128941
2233: --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
2234: -- l_PRICE_LIST_rec.orig_system_header_ref)

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

2229: -- Blanket Sales Order
2230: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_source_code,
2231: l_PRICE_LIST_rec.list_source_code)
2232: -- Bug # 5128941
2233: --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
2234: -- l_PRICE_LIST_rec.orig_system_header_ref)
2235: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire
2236: l_PRICE_LIST_rec.global_flag)
2237: -- Blanket Pricing

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

2231: l_PRICE_LIST_rec.list_source_code)
2232: -- Bug # 5128941
2233: --AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.orig_system_header_ref,
2234: -- l_PRICE_LIST_rec.orig_system_header_ref)
2235: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire
2236: l_PRICE_LIST_rec.global_flag)
2237: -- Blanket Pricing
2238: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2239: l_PRICE_LIST_rec.source_system_code)

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

2234: -- l_PRICE_LIST_rec.orig_system_header_ref)
2235: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.global_flag, -- Pricing Security gtippire
2236: l_PRICE_LIST_rec.global_flag)
2237: -- Blanket Pricing
2238: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2239: l_PRICE_LIST_rec.source_system_code)
2240: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2241: l_PRICE_LIST_rec.shareable_flag)
2242: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,

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

2236: l_PRICE_LIST_rec.global_flag)
2237: -- Blanket Pricing
2238: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2239: l_PRICE_LIST_rec.source_system_code)
2240: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2241: l_PRICE_LIST_rec.shareable_flag)
2242: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
2243: l_PRICE_LIST_rec.sold_to_org_id)
2244: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,

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

2238: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.source_system_code,
2239: l_PRICE_LIST_rec.source_system_code)
2240: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2241: l_PRICE_LIST_rec.shareable_flag)
2242: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
2243: l_PRICE_LIST_rec.sold_to_org_id)
2244: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
2245: l_PRICE_LIST_rec.locked_from_list_header_id)
2246: --added for MOAC

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

2240: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.shareable_flag,
2241: l_PRICE_LIST_rec.shareable_flag)
2242: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.sold_to_org_id,
2243: l_PRICE_LIST_rec.sold_to_org_id)
2244: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
2245: l_PRICE_LIST_rec.locked_from_list_header_id)
2246: --added for MOAC
2247: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,
2248: l_PRICE_LIST_rec.org_id)

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

2243: l_PRICE_LIST_rec.sold_to_org_id)
2244: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.locked_from_list_header_id,
2245: l_PRICE_LIST_rec.locked_from_list_header_id)
2246: --added for MOAC
2247: AND QP_GLOBALS.Equal(p_PRICE_LIST_rec.org_id,
2248: l_PRICE_LIST_rec.org_id)
2249: THEN
2250:
2251: -- Row has not changed. Set out parameter.

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

2310: oe_debug_pub.ADD('LOCKED_FROM_LIST_HEADER_ID:'||l_PRICE_LIST_rec.LOCKED_FROM_LIST_HEADER_ID||':'||p_PRICE_LIST_rec.LOCKED_FROM_LIST_HEADER_ID||':');
2311: oe_debug_pub.ADD('-------------------Data compare in price list header end------------------');
2312: --end 8594682
2313:
2314: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.list_source_code,l_PRICE_LIST_rec.list_source_code) then
2315: -- Row has changed by another user.
2316: oe_debug_pub.add('Passed Value: LSC'||p_PRICE_LIST_rec.list_source_code);
2317: oe_debug_pub.add('DB Value: LSC'||l_PRICE_LIST_rec.list_source_code);
2318:

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

2317: oe_debug_pub.add('DB Value: LSC'||l_PRICE_LIST_rec.list_source_code);
2318:
2319: end if ;
2320:
2321: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.orig_system_header_ref,l_PRICE_LIST_rec.orig_system_header_ref) then
2322:
2323: oe_debug_pub.add('Passed Value: OSHR'||p_PRICE_LIST_rec.orig_system_header_ref);
2324:
2325:

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

2424: BEGIN
2425:
2426: IF p_PRICE_LIST_rec.automatic_flag IS NOT NULL AND
2427: p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2428: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.automatic_flag,
2429: p_old_PRICE_LIST_rec.automatic_flag)
2430: THEN
2431: l_PRICE_LIST_val_rec.automatic := QP_Id_To_Value.Automatic
2432: ( p_automatic_flag => p_PRICE_LIST_rec.automatic_flag

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

2434: END IF;
2435:
2436: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
2437: p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2438: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_code,
2439: p_old_PRICE_LIST_rec.currency_code)
2440: THEN
2441: l_PRICE_LIST_val_rec.currency := QP_Id_To_Value.Currency
2442: ( p_currency_code => p_PRICE_LIST_rec.currency_code

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

2444: END IF;
2445:
2446: IF p_PRICE_LIST_rec.discount_lines_flag IS NOT NULL AND
2447: p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2448: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.discount_lines_flag,
2449: p_old_PRICE_LIST_rec.discount_lines_flag)
2450: THEN
2451: l_PRICE_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines
2452: ( p_discount_lines_flag => p_PRICE_LIST_rec.discount_lines_flag

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

2454: END IF;
2455:
2456: IF p_PRICE_LIST_rec.freight_terms_code IS NOT NULL AND
2457: p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2458: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.freight_terms_code,
2459: p_old_PRICE_LIST_rec.freight_terms_code)
2460: THEN
2461: l_PRICE_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms
2462: ( p_freight_terms_code => p_PRICE_LIST_rec.freight_terms_code

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

2464: END IF;
2465:
2466: IF p_PRICE_LIST_rec.list_header_id IS NOT NULL AND
2467: p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2468: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_header_id,
2469: p_old_PRICE_LIST_rec.list_header_id)
2470: THEN
2471: l_PRICE_LIST_val_rec.list_header := QP_Id_To_Value.List_Header
2472: ( p_list_header_id => p_PRICE_LIST_rec.list_header_id

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

2474: END IF;
2475:
2476: IF p_PRICE_LIST_rec.list_type_code IS NOT NULL AND
2477: p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2478: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.list_type_code,
2479: p_old_PRICE_LIST_rec.list_type_code)
2480: THEN
2481: l_PRICE_LIST_val_rec.list_type := QP_Id_To_Value.List_Type
2482: ( p_list_type_code => p_PRICE_LIST_rec.list_type_code

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

2484: END IF;
2485:
2486: IF p_PRICE_LIST_rec.prorate_flag IS NOT NULL AND
2487: p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2488: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.prorate_flag,
2489: p_old_PRICE_LIST_rec.prorate_flag)
2490: THEN
2491: l_PRICE_LIST_val_rec.prorate := QP_Id_To_Value.Prorate
2492: ( p_prorate_flag => p_PRICE_LIST_rec.prorate_flag

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

2494: END IF;
2495:
2496: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND
2497: p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2498: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.ship_method_code,
2499: p_old_PRICE_LIST_rec.ship_method_code)
2500: THEN
2501: l_PRICE_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method
2502: ( p_ship_method_code => p_PRICE_LIST_rec.ship_method_code

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

2504: END IF;
2505:
2506: IF p_PRICE_LIST_rec.terms_id IS NOT NULL AND
2507: p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2508: NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.terms_id,
2509: p_old_PRICE_LIST_rec.terms_id)
2510: THEN
2511: l_PRICE_LIST_val_rec.terms := QP_Id_To_Value.Terms
2512: ( p_terms_id => p_PRICE_LIST_rec.terms_id