APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_MODIFIER_LIST_rec OUT NOCOPY QP_Modifiers_PUB.Modifier_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:

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:
24: oe_debug_pub.add('BEGIN clear_dependent_attr in QPXUMLHB');

Line 35: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,p_old_MODIFIER_LIST_rec.attribute1)

31: -- every changed attribute clear its dependent fields.
32:
33: IF p_attr_id = FND_API.G_MISS_NUM THEN
34:
35: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,p_old_MODIFIER_LIST_rec.attribute1)
36: THEN
37: l_index := l_index + 1;
38: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE1;
39: END IF;

Line 41: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,p_old_MODIFIER_LIST_rec.attribute10)

37: l_index := l_index + 1;
38: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE1;
39: END IF;
40:
41: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,p_old_MODIFIER_LIST_rec.attribute10)
42: THEN
43: l_index := l_index + 1;
44: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE10;
45: END IF;

Line 47: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,p_old_MODIFIER_LIST_rec.attribute11)

43: l_index := l_index + 1;
44: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE10;
45: END IF;
46:
47: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,p_old_MODIFIER_LIST_rec.attribute11)
48: THEN
49: l_index := l_index + 1;
50: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE11;
51: END IF;

Line 53: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,p_old_MODIFIER_LIST_rec.attribute12)

49: l_index := l_index + 1;
50: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE11;
51: END IF;
52:
53: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,p_old_MODIFIER_LIST_rec.attribute12)
54: THEN
55: l_index := l_index + 1;
56: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE12;
57: END IF;

Line 59: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,p_old_MODIFIER_LIST_rec.attribute13)

55: l_index := l_index + 1;
56: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE12;
57: END IF;
58:
59: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,p_old_MODIFIER_LIST_rec.attribute13)
60: THEN
61: l_index := l_index + 1;
62: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE13;
63: END IF;

Line 65: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,p_old_MODIFIER_LIST_rec.attribute14)

61: l_index := l_index + 1;
62: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE13;
63: END IF;
64:
65: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,p_old_MODIFIER_LIST_rec.attribute14)
66: THEN
67: l_index := l_index + 1;
68: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE14;
69: END IF;

Line 71: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,p_old_MODIFIER_LIST_rec.attribute15)

67: l_index := l_index + 1;
68: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE14;
69: END IF;
70:
71: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,p_old_MODIFIER_LIST_rec.attribute15)
72: THEN
73: l_index := l_index + 1;
74: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE15;
75: END IF;

Line 77: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,p_old_MODIFIER_LIST_rec.attribute2)

73: l_index := l_index + 1;
74: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE15;
75: END IF;
76:
77: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,p_old_MODIFIER_LIST_rec.attribute2)
78: THEN
79: l_index := l_index + 1;
80: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE2;
81: END IF;

Line 83: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,p_old_MODIFIER_LIST_rec.attribute3)

79: l_index := l_index + 1;
80: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE2;
81: END IF;
82:
83: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,p_old_MODIFIER_LIST_rec.attribute3)
84: THEN
85: l_index := l_index + 1;
86: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE3;
87: END IF;

Line 89: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,p_old_MODIFIER_LIST_rec.attribute4)

85: l_index := l_index + 1;
86: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE3;
87: END IF;
88:
89: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,p_old_MODIFIER_LIST_rec.attribute4)
90: THEN
91: l_index := l_index + 1;
92: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE4;
93: END IF;

Line 95: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,p_old_MODIFIER_LIST_rec.attribute5)

91: l_index := l_index + 1;
92: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE4;
93: END IF;
94:
95: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,p_old_MODIFIER_LIST_rec.attribute5)
96: THEN
97: l_index := l_index + 1;
98: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE5;
99: END IF;

Line 101: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,p_old_MODIFIER_LIST_rec.attribute6)

97: l_index := l_index + 1;
98: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE5;
99: END IF;
100:
101: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,p_old_MODIFIER_LIST_rec.attribute6)
102: THEN
103: l_index := l_index + 1;
104: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE6;
105: END IF;

Line 107: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,p_old_MODIFIER_LIST_rec.attribute7)

103: l_index := l_index + 1;
104: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE6;
105: END IF;
106:
107: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,p_old_MODIFIER_LIST_rec.attribute7)
108: THEN
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE7;
111: END IF;

Line 113: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,p_old_MODIFIER_LIST_rec.attribute8)

109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE7;
111: END IF;
112:
113: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,p_old_MODIFIER_LIST_rec.attribute8)
114: THEN
115: l_index := l_index + 1;
116: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE8;
117: END IF;

Line 119: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,p_old_MODIFIER_LIST_rec.attribute9)

115: l_index := l_index + 1;
116: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE8;
117: END IF;
118:
119: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,p_old_MODIFIER_LIST_rec.attribute9)
120: THEN
121: l_index := l_index + 1;
122: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE9;
123: END IF;

Line 125: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,p_old_MODIFIER_LIST_rec.automatic_flag)

121: l_index := l_index + 1;
122: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE9;
123: END IF;
124:
125: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,p_old_MODIFIER_LIST_rec.automatic_flag)
126: THEN
127: l_index := l_index + 1;
128: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_AUTOMATIC;
129: END IF;

Line 131: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,p_old_MODIFIER_LIST_rec.comments)

127: l_index := l_index + 1;
128: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_AUTOMATIC;
129: END IF;
130:
131: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,p_old_MODIFIER_LIST_rec.comments)
132: THEN
133: l_index := l_index + 1;
134: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_COMMENTS;
135: END IF;

Line 137: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,p_old_MODIFIER_LIST_rec.context)

133: l_index := l_index + 1;
134: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_COMMENTS;
135: END IF;
136:
137: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,p_old_MODIFIER_LIST_rec.context)
138: THEN
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CONTEXT;
141: END IF;

Line 143: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,p_old_MODIFIER_LIST_rec.created_by)

139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CONTEXT;
141: END IF;
142:
143: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,p_old_MODIFIER_LIST_rec.created_by)
144: THEN
145: l_index := l_index + 1;
146: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATED_BY;
147: END IF;

Line 149: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,p_old_MODIFIER_LIST_rec.creation_date)

145: l_index := l_index + 1;
146: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATED_BY;
147: END IF;
148:
149: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,p_old_MODIFIER_LIST_rec.creation_date)
150: THEN
151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATION_DATE;
153: END IF;

Line 155: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,p_old_MODIFIER_LIST_rec.currency_code)

151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATION_DATE;
153: END IF;
154:
155: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,p_old_MODIFIER_LIST_rec.currency_code)
156: THEN
157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CURRENCY;
159: END IF;

Line 161: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,p_old_MODIFIER_LIST_rec.discount_lines_flag)

157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CURRENCY;
159: END IF;
160:
161: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,p_old_MODIFIER_LIST_rec.discount_lines_flag)
162: THEN
163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DISCOUNT_LINES;
165: END IF;

Line 167: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,p_old_MODIFIER_LIST_rec.end_date_active)

163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DISCOUNT_LINES;
165: END IF;
166:
167: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,p_old_MODIFIER_LIST_rec.end_date_active)
168: THEN
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE;
171: END IF;

Line 173: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,p_old_MODIFIER_LIST_rec.freight_terms_code)

169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE;
171: END IF;
172:
173: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,p_old_MODIFIER_LIST_rec.freight_terms_code)
174: THEN
175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_FREIGHT_TERMS;
177: END IF;

Line 179: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,p_old_MODIFIER_LIST_rec.gsa_indicator)

175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_FREIGHT_TERMS;
177: END IF;
178:
179: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,p_old_MODIFIER_LIST_rec.gsa_indicator)
180: THEN
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GSA_INDICATOR;
183: END IF;

Line 185: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)

181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GSA_INDICATOR;
183: END IF;
184:
185: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
186: THEN
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
189: END IF;

Line 191: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)

187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
189: END IF;
190:
191: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
192: THEN
193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
195: END IF;

Line 197: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)

193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
195: END IF;
196:
197: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
198: THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
201: END IF;

Line 203: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,p_old_MODIFIER_LIST_rec.list_header_id)

199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
201: END IF;
202:
203: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,p_old_MODIFIER_LIST_rec.list_header_id)
204: THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_HEADER;
207: END IF;

Line 209: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,p_old_MODIFIER_LIST_rec.list_type_code)

205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_HEADER;
207: END IF;
208:
209: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,p_old_MODIFIER_LIST_rec.list_type_code)
210: THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_TYPE;
213: END IF;

Line 215: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,p_old_MODIFIER_LIST_rec.program_application_id)

211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_TYPE;
213: END IF;
214:
215: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,p_old_MODIFIER_LIST_rec.program_application_id)
216: THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_APPLICATION;
219: END IF;

Line 221: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,p_old_MODIFIER_LIST_rec.program_id)

217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_APPLICATION;
219: END IF;
220:
221: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,p_old_MODIFIER_LIST_rec.program_id)
222: THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM;
225: END IF;

Line 227: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)

223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM;
225: END IF;
226:
227: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
228: THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
231: END IF;

Line 233: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,p_old_MODIFIER_LIST_rec.prorate_flag)

229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
231: END IF;
232:
233: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,p_old_MODIFIER_LIST_rec.prorate_flag)
234: THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PRORATE;
237: END IF;

Line 239: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,p_old_MODIFIER_LIST_rec.request_id)

235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PRORATE;
237: END IF;
238:
239: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,p_old_MODIFIER_LIST_rec.request_id)
240: THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_REQUEST;
243: END IF;

Line 245: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,p_old_MODIFIER_LIST_rec.rounding_factor)

241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_REQUEST;
243: END IF;
244:
245: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,p_old_MODIFIER_LIST_rec.rounding_factor)
246: THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ROUNDING_FACTOR;
249: END IF;

Line 251: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,p_old_MODIFIER_LIST_rec.ship_method_code)

247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ROUNDING_FACTOR;
249: END IF;
250:
251: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,p_old_MODIFIER_LIST_rec.ship_method_code)
252: THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHIP_METHOD;
255: END IF;

Line 257: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,p_old_MODIFIER_LIST_rec.start_date_active)

253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHIP_METHOD;
255: END IF;
256:
257: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,p_old_MODIFIER_LIST_rec.start_date_active)
258: THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE;
261: END IF;

Line 263: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,p_old_MODIFIER_LIST_rec.terms_id)

259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE;
261: END IF;
262:
263: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,p_old_MODIFIER_LIST_rec.terms_id)
264: THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_TERMS;
267: END IF;

Line 269: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,p_old_MODIFIER_LIST_rec.source_system_code)

265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_TERMS;
267: END IF;
268:
269: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,p_old_MODIFIER_LIST_rec.source_system_code)
270: THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
273: END IF;

Line 275: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,p_old_MODIFIER_LIST_rec.pte_code)

271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
273: END IF;
274:
275: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,p_old_MODIFIER_LIST_rec.pte_code)
276: THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PTE_CODE;
279: END IF;

Line 281: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,p_old_MODIFIER_LIST_rec.active_flag)

277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PTE_CODE;
279: END IF;
280:
281: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,p_old_MODIFIER_LIST_rec.active_flag)
282: THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_FLAG;
285: END IF;

Line 287: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,p_old_MODIFIER_LIST_rec.parent_list_header_id)

283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_FLAG;
285: END IF;
286:
287: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,p_old_MODIFIER_LIST_rec.parent_list_header_id)
288: THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PARENT_LIST_HEADER_ID;
291: END IF;

Line 293: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,p_old_MODIFIER_LIST_rec.start_date_active_first)

289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PARENT_LIST_HEADER_ID;
291: END IF;
292:
293: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,p_old_MODIFIER_LIST_rec.start_date_active_first)
294: THEN
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_FIRST;
297: END IF;

Line 299: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,p_old_MODIFIER_LIST_rec.end_date_active_first)

295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_FIRST;
297: END IF;
298:
299: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,p_old_MODIFIER_LIST_rec.end_date_active_first)
300: THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_FIRST;
303: END IF;

Line 305: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,p_old_MODIFIER_LIST_rec.active_date_first_type)

301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_FIRST;
303: END IF;
304:
305: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,p_old_MODIFIER_LIST_rec.active_date_first_type)
306: THEN
307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_FIRST_TYPE;
309: END IF;

Line 311: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,p_old_MODIFIER_LIST_rec.start_date_active_second)

307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_FIRST_TYPE;
309: END IF;
310:
311: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,p_old_MODIFIER_LIST_rec.start_date_active_second)
312: THEN
313: l_index := l_index + 1;
314: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_SECOND;
315: END IF;

Line 317: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,p_old_MODIFIER_LIST_rec.global_flag)

313: l_index := l_index + 1;
314: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_SECOND;
315: END IF;
316:
317: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,p_old_MODIFIER_LIST_rec.global_flag)
318: THEN
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GLOBAL_FLAG;
321: END IF;

Line 324: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,p_old_MODIFIER_LIST_rec.end_date_active_second)

320: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GLOBAL_FLAG;
321: END IF;
322:
323:
324: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,p_old_MODIFIER_LIST_rec.end_date_active_second)
325: THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_SECOND;
328: END IF;

Line 330: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,p_old_MODIFIER_LIST_rec.active_date_second_type)

326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_SECOND;
328: END IF;
329:
330: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,p_old_MODIFIER_LIST_rec.active_date_second_type)
331: THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_SECOND_TYPE;
334: END IF;

Line 336: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,p_old_MODIFIER_LIST_rec.ask_for_flag)

332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_SECOND_TYPE;
334: END IF;
335:
336: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,p_old_MODIFIER_LIST_rec.ask_for_flag)
337: THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ASK_FOR;
340: END IF;

Line 342: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.name,p_old_MODIFIER_LIST_rec.name)

338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ASK_FOR;
340: END IF;
341:
342: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.name,p_old_MODIFIER_LIST_rec.name)
343: THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_NAME;
346: END IF;

Line 348: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.description,p_old_MODIFIER_LIST_rec.description)

344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_NAME;
346: END IF;
347:
348: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.description,p_old_MODIFIER_LIST_rec.description)
349: THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DESCRIPTION;
352: END IF;

Line 355: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code, p_old_MODIFIER_LIST_rec.list_source_code)

351: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DESCRIPTION;
352: END IF;
353:
354: -- Blanket Pricing
355: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code, p_old_MODIFIER_LIST_rec.list_source_code)
356: THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_SOURCE_CODE;
359: END IF;

Line 361: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref, p_old_MODIFIER_LIST_rec.orig_system_header_ref)

357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_SOURCE_CODE;
359: END IF;
360:
361: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref, p_old_MODIFIER_LIST_rec.orig_system_header_ref)
362: THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORIG_SYSTEM_HEADER_REF;
365: END IF;

Line 367: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,p_old_MODIFIER_LIST_rec.shareable_flag)

363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORIG_SYSTEM_HEADER_REF;
365: END IF;
366:
367: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,p_old_MODIFIER_LIST_rec.shareable_flag)
368: THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHAREABLE_FLAG;
371: END IF;

Line 374: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.org_id,p_old_MODIFIER_LIST_rec.org_id)

370: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHAREABLE_FLAG;
371: END IF;
372:
373: --added for MOAC
374: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.org_id,p_old_MODIFIER_LIST_rec.org_id)
375: THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORG_ID;
378: END IF;

Line 579: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,p_old_MODIFIER_LIST_rec.attribute1)

575: -- Load out record
576:
577: x_MODIFIER_LIST_rec := p_MODIFIER_LIST_rec;
578:
579: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,p_old_MODIFIER_LIST_rec.attribute1)
580: THEN
581: NULL;
582: END IF;
583:

Line 584: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,p_old_MODIFIER_LIST_rec.attribute10)

580: THEN
581: NULL;
582: END IF;
583:
584: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,p_old_MODIFIER_LIST_rec.attribute10)
585: THEN
586: NULL;
587: END IF;
588:

Line 589: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,p_old_MODIFIER_LIST_rec.attribute11)

585: THEN
586: NULL;
587: END IF;
588:
589: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,p_old_MODIFIER_LIST_rec.attribute11)
590: THEN
591: NULL;
592: END IF;
593:

Line 594: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,p_old_MODIFIER_LIST_rec.attribute12)

590: THEN
591: NULL;
592: END IF;
593:
594: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,p_old_MODIFIER_LIST_rec.attribute12)
595: THEN
596: NULL;
597: END IF;
598:

Line 599: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,p_old_MODIFIER_LIST_rec.attribute13)

595: THEN
596: NULL;
597: END IF;
598:
599: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,p_old_MODIFIER_LIST_rec.attribute13)
600: THEN
601: NULL;
602: END IF;
603:

Line 604: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,p_old_MODIFIER_LIST_rec.attribute14)

600: THEN
601: NULL;
602: END IF;
603:
604: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,p_old_MODIFIER_LIST_rec.attribute14)
605: THEN
606: NULL;
607: END IF;
608:

Line 609: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,p_old_MODIFIER_LIST_rec.attribute15)

605: THEN
606: NULL;
607: END IF;
608:
609: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,p_old_MODIFIER_LIST_rec.attribute15)
610: THEN
611: NULL;
612: END IF;
613:

Line 614: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,p_old_MODIFIER_LIST_rec.attribute2)

610: THEN
611: NULL;
612: END IF;
613:
614: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,p_old_MODIFIER_LIST_rec.attribute2)
615: THEN
616: NULL;
617: END IF;
618:

Line 619: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,p_old_MODIFIER_LIST_rec.attribute3)

615: THEN
616: NULL;
617: END IF;
618:
619: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,p_old_MODIFIER_LIST_rec.attribute3)
620: THEN
621: NULL;
622: END IF;
623:

Line 624: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,p_old_MODIFIER_LIST_rec.attribute4)

620: THEN
621: NULL;
622: END IF;
623:
624: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,p_old_MODIFIER_LIST_rec.attribute4)
625: THEN
626: NULL;
627: END IF;
628:

Line 629: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,p_old_MODIFIER_LIST_rec.attribute5)

625: THEN
626: NULL;
627: END IF;
628:
629: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,p_old_MODIFIER_LIST_rec.attribute5)
630: THEN
631: NULL;
632: END IF;
633:

Line 634: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,p_old_MODIFIER_LIST_rec.attribute6)

630: THEN
631: NULL;
632: END IF;
633:
634: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,p_old_MODIFIER_LIST_rec.attribute6)
635: THEN
636: NULL;
637: END IF;
638:

Line 639: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,p_old_MODIFIER_LIST_rec.attribute7)

635: THEN
636: NULL;
637: END IF;
638:
639: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,p_old_MODIFIER_LIST_rec.attribute7)
640: THEN
641: NULL;
642: END IF;
643:

Line 644: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,p_old_MODIFIER_LIST_rec.attribute8)

640: THEN
641: NULL;
642: END IF;
643:
644: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,p_old_MODIFIER_LIST_rec.attribute8)
645: THEN
646: NULL;
647: END IF;
648:

Line 649: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,p_old_MODIFIER_LIST_rec.attribute9)

645: THEN
646: NULL;
647: END IF;
648:
649: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,p_old_MODIFIER_LIST_rec.attribute9)
650: THEN
651: NULL;
652: END IF;
653:

Line 654: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,p_old_MODIFIER_LIST_rec.automatic_flag)

650: THEN
651: NULL;
652: END IF;
653:
654: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,p_old_MODIFIER_LIST_rec.automatic_flag)
655: THEN
656: -- NULL;
657: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
658: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 661: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

657: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
658: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
659: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
660: qp_delayed_requests_pvt.log_request(
661: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
662: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
663: p_request_unique_key1 => NULL,
664: p_request_unique_key2 => 'UD',
665: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 665: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

661: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
662: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
663: p_request_unique_key1 => NULL,
664: p_request_unique_key2 => 'UD',
665: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
666: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
667: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
668: x_return_status => x_MODIFIER_LIST_rec.return_status);
669: END IF;

Line 667: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

663: p_request_unique_key1 => NULL,
664: p_request_unique_key2 => 'UD',
665: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
666: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
667: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
668: x_return_status => x_MODIFIER_LIST_rec.return_status);
669: END IF;
670: END IF;
671: END IF;

Line 674: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,p_old_MODIFIER_LIST_rec.comments)

670: END IF;
671: END IF;
672: END IF;
673:
674: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,p_old_MODIFIER_LIST_rec.comments)
675: THEN
676: NULL;
677: END IF;
678:

Line 679: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,p_old_MODIFIER_LIST_rec.context)

675: THEN
676: NULL;
677: END IF;
678:
679: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,p_old_MODIFIER_LIST_rec.context)
680: THEN
681: NULL;
682: END IF;
683:

Line 684: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,p_old_MODIFIER_LIST_rec.created_by)

680: THEN
681: NULL;
682: END IF;
683:
684: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,p_old_MODIFIER_LIST_rec.created_by)
685: THEN
686: NULL;
687: END IF;
688:

Line 689: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,p_old_MODIFIER_LIST_rec.creation_date)

685: THEN
686: NULL;
687: END IF;
688:
689: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,p_old_MODIFIER_LIST_rec.creation_date)
690: THEN
691: NULL;
692: END IF;
693:

Line 694: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,p_old_MODIFIER_LIST_rec.currency_code)

690: THEN
691: NULL;
692: END IF;
693:
694: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,p_old_MODIFIER_LIST_rec.currency_code)
695: THEN
696: -- NULL;
697: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
698: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 700: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

696: -- NULL;
697: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
698: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
699: qp_delayed_requests_pvt.log_request(
700: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
701: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
702: p_request_unique_key1 => NULL,
703: p_request_unique_key2 => 'UD',
704: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 704: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

700: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
701: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
702: p_request_unique_key1 => NULL,
703: p_request_unique_key2 => 'UD',
704: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
705: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
706: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
707: x_return_status => x_MODIFIER_LIST_rec.return_status);
708: END IF;

Line 706: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

702: p_request_unique_key1 => NULL,
703: p_request_unique_key2 => 'UD',
704: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
705: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
706: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
707: x_return_status => x_MODIFIER_LIST_rec.return_status);
708: END IF;
709: END IF;
710: -- Pattern

Line 716: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

712: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
713: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
714: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
715: qp_delayed_requests_pvt.log_request(
716: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
717: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
718: p_request_unique_key1 => NULL,
719: p_request_unique_key2 => 'UD',
720: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 720: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

716: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
717: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
718: p_request_unique_key1 => NULL,
719: p_request_unique_key2 => 'UD',
720: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
721: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
722: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
723: x_return_status => x_MODIFIER_LIST_rec.return_status);
724: END IF;

Line 722: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

718: p_request_unique_key1 => NULL,
719: p_request_unique_key2 => 'UD',
720: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
721: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
722: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
723: x_return_status => x_MODIFIER_LIST_rec.return_status);
724: END IF;
725: END IF;
726: END IF;

Line 729: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,p_old_MODIFIER_LIST_rec.discount_lines_flag)

725: END IF;
726: END IF;
727: END IF;
728:
729: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,p_old_MODIFIER_LIST_rec.discount_lines_flag)
730: THEN
731: NULL;
732: END IF;
733:

Line 734: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,p_old_MODIFIER_LIST_rec.end_date_active)

730: THEN
731: NULL;
732: END IF;
733:
734: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,p_old_MODIFIER_LIST_rec.end_date_active)
735: THEN
736: -- NULL;
737: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
738: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 741: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

737: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
738: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
739: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
740: qp_delayed_requests_pvt.log_request(
741: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
742: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
743: p_request_unique_key1 => NULL,
744: p_request_unique_key2 => 'UD',
745: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 745: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

741: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
742: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
743: p_request_unique_key1 => NULL,
744: p_request_unique_key2 => 'UD',
745: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
746: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
747: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
748: x_return_status => x_MODIFIER_LIST_rec.return_status);
749: END IF;

Line 747: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

743: p_request_unique_key1 => NULL,
744: p_request_unique_key2 => 'UD',
745: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
746: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
747: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
748: x_return_status => x_MODIFIER_LIST_rec.return_status);
749: END IF;
750: END IF;
751: END IF;

Line 754: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,p_old_MODIFIER_LIST_rec.freight_terms_code)

750: END IF;
751: END IF;
752: END IF;
753:
754: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,p_old_MODIFIER_LIST_rec.freight_terms_code)
755: THEN
756: NULL;
757: END IF;
758:

Line 759: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,p_old_MODIFIER_LIST_rec.gsa_indicator)

755: THEN
756: NULL;
757: END IF;
758:
759: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,p_old_MODIFIER_LIST_rec.gsa_indicator)
760: THEN
761: NULL;
762: END IF;
763:

Line 764: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)

760: THEN
761: NULL;
762: END IF;
763:
764: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
765: THEN
766: NULL;
767: END IF;
768:

Line 769: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)

765: THEN
766: NULL;
767: END IF;
768:
769: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
770: THEN
771: NULL;
772: END IF;
773:

Line 774: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)

770: THEN
771: NULL;
772: END IF;
773:
774: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
775: THEN
776: NULL;
777: END IF;
778:

Line 779: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,p_old_MODIFIER_LIST_rec.list_header_id)

775: THEN
776: NULL;
777: END IF;
778:
779: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,p_old_MODIFIER_LIST_rec.list_header_id)
780: THEN
781: NULL;
782: END IF;
783:

Line 784: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,p_old_MODIFIER_LIST_rec.list_type_code)

780: THEN
781: NULL;
782: END IF;
783:
784: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,p_old_MODIFIER_LIST_rec.list_type_code)
785: THEN
786: NULL;
787: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
788: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 790: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

786: NULL;
787: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
788: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
789: qp_delayed_requests_pvt.log_request(
790: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
791: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
792: p_request_unique_key1 => NULL,
793: p_request_unique_key2 => 'UD',
794: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 794: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

790: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
791: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
792: p_request_unique_key1 => NULL,
793: p_request_unique_key2 => 'UD',
794: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
795: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
796: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
797: x_return_status => x_MODIFIER_LIST_rec.return_status);
798: END IF;

Line 796: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

792: p_request_unique_key1 => NULL,
793: p_request_unique_key2 => 'UD',
794: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
795: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
796: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
797: x_return_status => x_MODIFIER_LIST_rec.return_status);
798: END IF;
799: END IF;
800: -- Pattern

Line 807: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

803: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
804: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
805: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
806: qp_delayed_requests_pvt.log_request(
807: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
808: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
809: p_request_unique_key1 => NULL,
810: p_request_unique_key2 => 'UD',
811: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 811: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

807: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
808: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
809: p_request_unique_key1 => NULL,
810: p_request_unique_key2 => 'UD',
811: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
812: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
813: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
814: x_return_status => x_MODIFIER_LIST_rec.return_status);
815: END IF;

Line 813: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

809: p_request_unique_key1 => NULL,
810: p_request_unique_key2 => 'UD',
811: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
812: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
813: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
814: x_return_status => x_MODIFIER_LIST_rec.return_status);
815: END IF;
816: END IF;
817: END IF;

Line 820: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,p_old_MODIFIER_LIST_rec.program_application_id)

816: END IF;
817: END IF;
818: END IF;
819:
820: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,p_old_MODIFIER_LIST_rec.program_application_id)
821: THEN
822: NULL;
823: END IF;
824:

Line 825: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,p_old_MODIFIER_LIST_rec.program_id)

821: THEN
822: NULL;
823: END IF;
824:
825: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,p_old_MODIFIER_LIST_rec.program_id)
826: THEN
827: NULL;
828: END IF;
829:

Line 830: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)

826: THEN
827: NULL;
828: END IF;
829:
830: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
831: THEN
832: NULL;
833: END IF;
834:

Line 835: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,p_old_MODIFIER_LIST_rec.prorate_flag)

831: THEN
832: NULL;
833: END IF;
834:
835: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,p_old_MODIFIER_LIST_rec.prorate_flag)
836: THEN
837: NULL;
838: END IF;
839:

Line 840: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,p_old_MODIFIER_LIST_rec.request_id)

836: THEN
837: NULL;
838: END IF;
839:
840: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,p_old_MODIFIER_LIST_rec.request_id)
841: THEN
842: NULL;
843: END IF;
844:

Line 845: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,p_old_MODIFIER_LIST_rec.rounding_factor)

841: THEN
842: NULL;
843: END IF;
844:
845: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,p_old_MODIFIER_LIST_rec.rounding_factor)
846: THEN
847: NULL;
848: END IF;
849:

Line 850: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,p_old_MODIFIER_LIST_rec.ship_method_code)

846: THEN
847: NULL;
848: END IF;
849:
850: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,p_old_MODIFIER_LIST_rec.ship_method_code)
851: THEN
852: NULL;
853: END IF;
854:

Line 855: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,p_old_MODIFIER_LIST_rec.start_date_active)

851: THEN
852: NULL;
853: END IF;
854:
855: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,p_old_MODIFIER_LIST_rec.start_date_active)
856: THEN
857: -- NULL;
858: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
859: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 862: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

858: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
859: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
860: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
861: qp_delayed_requests_pvt.log_request(
862: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
863: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
864: p_request_unique_key1 => NULL,
865: p_request_unique_key2 => 'UD',
866: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 866: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

862: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
863: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
864: p_request_unique_key1 => NULL,
865: p_request_unique_key2 => 'UD',
866: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
867: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
868: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
869: x_return_status => x_MODIFIER_LIST_rec.return_status);
870: END IF;

Line 868: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

864: p_request_unique_key1 => NULL,
865: p_request_unique_key2 => 'UD',
866: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
867: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
868: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
869: x_return_status => x_MODIFIER_LIST_rec.return_status);
870: END IF;
871: END IF;
872: END IF;

Line 875: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,p_old_MODIFIER_LIST_rec.terms_id)

871: END IF;
872: END IF;
873: END IF;
874:
875: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,p_old_MODIFIER_LIST_rec.terms_id)
876: THEN
877: NULL;
878: END IF;
879:

Line 880: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,p_old_MODIFIER_LIST_rec.source_system_code)

876: THEN
877: NULL;
878: END IF;
879:
880: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,p_old_MODIFIER_LIST_rec.source_system_code)
881: THEN
882: NULL;
883: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
884: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 886: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

882: NULL;
883: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
884: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
885: qp_delayed_requests_pvt.log_request(
886: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
887: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
888: p_request_unique_key1 => NULL,
889: p_request_unique_key2 => 'UD',
890: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 890: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

886: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
887: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
888: p_request_unique_key1 => NULL,
889: p_request_unique_key2 => 'UD',
890: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
891: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
892: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
893: x_return_status => x_MODIFIER_LIST_rec.return_status);
894: END IF;

Line 892: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

888: p_request_unique_key1 => NULL,
889: p_request_unique_key2 => 'UD',
890: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
891: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
892: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
893: x_return_status => x_MODIFIER_LIST_rec.return_status);
894: END IF;
895: END IF;
896: -- Pattern

Line 902: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

898: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
899: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'Y' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
900: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
901: qp_delayed_requests_pvt.log_request(
902: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
903: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
904: p_request_unique_key1 => NULL,
905: p_request_unique_key2 => 'UD',
906: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 906: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 908: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

904: p_request_unique_key1 => NULL,
905: p_request_unique_key2 => 'UD',
906: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
907: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
908: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
909: x_return_status => x_MODIFIER_LIST_rec.return_status);
910: END IF;
911: END IF;
912: END IF;

Line 915: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,p_old_MODIFIER_LIST_rec.pte_code)

911: END IF;
912: END IF;
913: END IF;
914:
915: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,p_old_MODIFIER_LIST_rec.pte_code)
916: THEN
917: NULL;
918: END IF;
919:

Line 920: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,p_old_MODIFIER_LIST_rec.active_flag)

916: THEN
917: NULL;
918: END IF;
919:
920: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,p_old_MODIFIER_LIST_rec.active_flag)
921: THEN
922: NULL;
923:
924: --hw

Line 928: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

924: --hw
925: -- log delayed request for changed lines for active flag change
926: if QP_PERF_PVT.enabled = 'Y' then
927: qp_delayed_requests_pvt.log_request(
928: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
929: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
930: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
931: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
932: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,

Line 930: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

926: if QP_PERF_PVT.enabled = 'Y' then
927: qp_delayed_requests_pvt.log_request(
928: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
929: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
930: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
931: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
932: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,
933: p_param1 => p_MODIFIER_LIST_rec.active_flag,
934: x_return_status => x_MODIFIER_LIST_rec.return_status);

Line 932: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,

928: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
929: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
930: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
931: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
932: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,
933: p_param1 => p_MODIFIER_LIST_rec.active_flag,
934: x_return_status => x_MODIFIER_LIST_rec.return_status);
935: end if;
936:

Line 939: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

935: end if;
936:
937: --hvop
938: qp_delayed_requests_pvt.log_request(
939: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
940: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
941: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
942: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
943: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

Line 941: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

937: --hvop
938: qp_delayed_requests_pvt.log_request(
939: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
940: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
941: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
942: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
943: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
944: x_return_status => x_MODIFIER_LIST_rec.return_status);
945: --hvop

Line 943: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

939: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
940: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
941: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
942: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
943: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
944: x_return_status => x_MODIFIER_LIST_rec.return_status);
945: --hvop
946: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
947: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 949: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

945: --hvop
946: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
947: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
948: qp_delayed_requests_pvt.log_request(
949: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
950: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
951: p_request_unique_key1 => NULL,
952: p_request_unique_key2 => 'UD',
953: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 953: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

949: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
950: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
951: p_request_unique_key1 => NULL,
952: p_request_unique_key2 => 'UD',
953: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
954: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
955: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
956: x_return_status => x_MODIFIER_LIST_rec.return_status);
957: END IF;

Line 955: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

951: p_request_unique_key1 => NULL,
952: p_request_unique_key2 => 'UD',
953: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
954: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
955: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
956: x_return_status => x_MODIFIER_LIST_rec.return_status);
957: END IF;
958: END IF; --Java Engine Installed
959: -- Pattern

Line 965: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

961: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
962: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
963: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
964: qp_delayed_requests_pvt.log_request(
965: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
966: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
967: p_request_unique_key1 => NULL,
968: p_request_unique_key2 => 'UD',
969: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 969: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

965: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
966: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
967: p_request_unique_key1 => NULL,
968: p_request_unique_key2 => 'UD',
969: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
970: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
971: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
972: x_return_status => x_MODIFIER_LIST_rec.return_status);
973: END IF;

Line 971: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

967: p_request_unique_key1 => NULL,
968: p_request_unique_key2 => 'UD',
969: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
970: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
971: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
972: x_return_status => x_MODIFIER_LIST_rec.return_status);
973: END IF;
974: END IF;
975: END IF;

Line 978: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

974: END IF;
975: END IF;
976: --to populate rltd_Exists,oid_exists,prg_exists and qp_basic_modifiers_setup
977: --performance profile
978: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
979:
980: BEGIN
981: select 'Y' into l_modifiers_exist
982: from qp_list_lines

Line 997: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

993: FOR I in l_pricing_phase_cur(p_MODIFIER_LIST_rec.list_header_id)
994: LOOP
995:
996: qp_delayed_requests_PVT.log_request(
997: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
998: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
999: p_param1 => I.pricing_phase_id,
1000: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1001: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,

Line 1000: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

996: qp_delayed_requests_PVT.log_request(
997: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
998: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
999: p_param1 => I.pricing_phase_id,
1000: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1001: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1002: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,
1003: x_return_status => x_MODIFIER_LIST_rec.return_status);
1004: END LOOP;

Line 1002: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,

998: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
999: p_param1 => I.pricing_phase_id,
1000: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1001: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1002: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,
1003: x_return_status => x_MODIFIER_LIST_rec.return_status);
1004: END LOOP;
1005:
1006: qp_delayed_requests_pvt.log_request(

Line 1007: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

1003: x_return_status => x_MODIFIER_LIST_rec.return_status);
1004: END LOOP;
1005:
1006: qp_delayed_requests_pvt.log_request(
1007: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1008: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1009: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1010: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1011: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

Line 1009: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1005:
1006: qp_delayed_requests_pvt.log_request(
1007: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1008: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1009: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1010: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1011: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
1012: x_return_status => x_MODIFIER_LIST_rec.return_status);
1013: END IF;

Line 1011: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

1007: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1008: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1009: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1010: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1011: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
1012: x_return_status => x_MODIFIER_LIST_rec.return_status);
1013: END IF;
1014: END IF;
1015:

Line 1016: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

1012: x_return_status => x_MODIFIER_LIST_rec.return_status);
1013: END IF;
1014: END IF;
1015:
1016: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1017:
1018: Update QP_QUALIFIERS
1019: set active_flag = p_MODIFIER_LIST_rec.active_flag
1020: where list_header_id = p_MODIFIER_LIST_rec.list_header_id;

Line 1099: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,p_old_MODIFIER_LIST_rec.parent_list_header_id)

1095:
1096: END IF;
1097: END IF;
1098:
1099: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,p_old_MODIFIER_LIST_rec.parent_list_header_id)
1100: THEN
1101: NULL;
1102: END IF;
1103:

Line 1104: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,p_old_MODIFIER_LIST_rec.start_date_active_first)

1100: THEN
1101: NULL;
1102: END IF;
1103:
1104: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,p_old_MODIFIER_LIST_rec.start_date_active_first)
1105: THEN
1106: -- NULL;
1107: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1108: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 1111: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1107: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1108: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
1109: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1110: qp_delayed_requests_pvt.log_request(
1111: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1112: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1113: p_request_unique_key1 => NULL,
1114: p_request_unique_key2 => 'UD',
1115: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1115: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1111: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1112: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1113: p_request_unique_key1 => NULL,
1114: p_request_unique_key2 => 'UD',
1115: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1116: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1117: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1118: x_return_status => x_MODIFIER_LIST_rec.return_status);
1119: END IF;

Line 1117: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1113: p_request_unique_key1 => NULL,
1114: p_request_unique_key2 => 'UD',
1115: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1116: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1117: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1118: x_return_status => x_MODIFIER_LIST_rec.return_status);
1119: END IF;
1120: END IF;
1121: END IF;

Line 1124: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,p_old_MODIFIER_LIST_rec.end_date_active_first)

1120: END IF;
1121: END IF;
1122: END IF;
1123:
1124: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,p_old_MODIFIER_LIST_rec.end_date_active_first)
1125: THEN
1126: -- NULL;
1127: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1128: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 1131: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1127: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1128: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
1129: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1130: qp_delayed_requests_pvt.log_request(
1131: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1132: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1133: p_request_unique_key1 => NULL,
1134: p_request_unique_key2 => 'UD',
1135: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1135: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1131: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1132: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1133: p_request_unique_key1 => NULL,
1134: p_request_unique_key2 => 'UD',
1135: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1136: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1137: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1138: x_return_status => x_MODIFIER_LIST_rec.return_status);
1139: END IF;

Line 1137: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1133: p_request_unique_key1 => NULL,
1134: p_request_unique_key2 => 'UD',
1135: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1136: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1137: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1138: x_return_status => x_MODIFIER_LIST_rec.return_status);
1139: END IF;
1140: END IF;
1141: END IF;

Line 1144: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,p_old_MODIFIER_LIST_rec.active_date_first_type)

1140: END IF;
1141: END IF;
1142: END IF;
1143:
1144: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,p_old_MODIFIER_LIST_rec.active_date_first_type)
1145: THEN
1146: -- NULL;
1147: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1148: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 1151: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1147: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1148: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
1149: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1150: qp_delayed_requests_pvt.log_request(
1151: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1152: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1153: p_request_unique_key1 => NULL,
1154: p_request_unique_key2 => 'UD',
1155: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1155: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1151: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1152: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1153: p_request_unique_key1 => NULL,
1154: p_request_unique_key2 => 'UD',
1155: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1156: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1157: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1158: x_return_status => x_MODIFIER_LIST_rec.return_status);
1159: END IF;

Line 1157: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1153: p_request_unique_key1 => NULL,
1154: p_request_unique_key2 => 'UD',
1155: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1156: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1157: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1158: x_return_status => x_MODIFIER_LIST_rec.return_status);
1159: END IF;
1160: END IF;
1161: END IF;

Line 1164: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,p_old_MODIFIER_LIST_rec.start_date_active_second)

1160: END IF;
1161: END IF;
1162: END IF;
1163:
1164: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,p_old_MODIFIER_LIST_rec.start_date_active_second)
1165: THEN
1166: -- NULL;
1167: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1168: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 1171: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1167: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1168: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
1169: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1170: qp_delayed_requests_pvt.log_request(
1171: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1172: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1173: p_request_unique_key1 => NULL,
1174: p_request_unique_key2 => 'UD',
1175: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1175: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1171: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1172: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1173: p_request_unique_key1 => NULL,
1174: p_request_unique_key2 => 'UD',
1175: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1176: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1177: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1178: x_return_status => x_MODIFIER_LIST_rec.return_status);
1179: END IF;

Line 1177: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1173: p_request_unique_key1 => NULL,
1174: p_request_unique_key2 => 'UD',
1175: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1176: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1177: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1178: x_return_status => x_MODIFIER_LIST_rec.return_status);
1179: END IF;
1180: END IF;
1181: END IF;

Line 1184: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,p_old_MODIFIER_LIST_rec.global_flag)

1180: END IF;
1181: END IF;
1182: END IF;
1183:
1184: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,p_old_MODIFIER_LIST_rec.global_flag)
1185: THEN
1186: -- NULL;
1187: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1188: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 1191: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1187: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1188: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
1189: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1190: qp_delayed_requests_pvt.log_request(
1191: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1192: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1193: p_request_unique_key1 => NULL,
1194: p_request_unique_key2 => 'UD',
1195: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1195: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1191: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1192: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1193: p_request_unique_key1 => NULL,
1194: p_request_unique_key2 => 'UD',
1195: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1196: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1197: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1198: x_return_status => x_MODIFIER_LIST_rec.return_status);
1199: END IF;

Line 1197: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1193: p_request_unique_key1 => NULL,
1194: p_request_unique_key2 => 'UD',
1195: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1196: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1197: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1198: x_return_status => x_MODIFIER_LIST_rec.return_status);
1199: END IF;
1200: END IF;
1201: END IF;

Line 1205: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,p_old_MODIFIER_LIST_rec.end_date_active_second)

1201: END IF;
1202: END IF;
1203:
1204:
1205: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,p_old_MODIFIER_LIST_rec.end_date_active_second)
1206: THEN
1207: -- NULL;
1208: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1209: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 1212: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1208: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1209: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
1210: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1211: qp_delayed_requests_pvt.log_request(
1212: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1213: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1214: p_request_unique_key1 => NULL,
1215: p_request_unique_key2 => 'UD',
1216: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1216: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1212: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1213: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1214: p_request_unique_key1 => NULL,
1215: p_request_unique_key2 => 'UD',
1216: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1217: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1218: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1219: x_return_status => x_MODIFIER_LIST_rec.return_status);
1220: END IF;

Line 1218: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1214: p_request_unique_key1 => NULL,
1215: p_request_unique_key2 => 'UD',
1216: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1217: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1218: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1219: x_return_status => x_MODIFIER_LIST_rec.return_status);
1220: END IF;
1221: END IF;
1222: END IF;

Line 1225: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,p_old_MODIFIER_LIST_rec.active_date_second_type)

1221: END IF;
1222: END IF;
1223: END IF;
1224:
1225: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,p_old_MODIFIER_LIST_rec.active_date_second_type)
1226: THEN
1227: -- NULL;
1228: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1229: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN

Line 1232: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1228: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1229: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B'THEN
1230: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1231: qp_delayed_requests_pvt.log_request(
1232: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1233: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1234: p_request_unique_key1 => NULL,
1235: p_request_unique_key2 => 'UD',
1236: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1236: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1232: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1233: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1234: p_request_unique_key1 => NULL,
1235: p_request_unique_key2 => 'UD',
1236: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1237: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1238: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1239: x_return_status => x_MODIFIER_LIST_rec.return_status);
1240: END IF;

Line 1238: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1234: p_request_unique_key1 => NULL,
1235: p_request_unique_key2 => 'UD',
1236: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1237: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1238: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1239: x_return_status => x_MODIFIER_LIST_rec.return_status);
1240: END IF;
1241: END IF;
1242: END IF;

Line 1245: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,p_old_MODIFIER_LIST_rec.ask_for_flag)

1241: END IF;
1242: END IF;
1243: END IF;
1244:
1245: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,p_old_MODIFIER_LIST_rec.ask_for_flag)
1246: THEN
1247: NULL;
1248: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1249: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 1251: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1247: NULL;
1248: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1249: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1250: qp_delayed_requests_pvt.log_request(
1251: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1252: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1253: p_request_unique_key1 => NULL,
1254: p_request_unique_key2 => 'UD',
1255: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1255: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1251: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1252: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1253: p_request_unique_key1 => NULL,
1254: p_request_unique_key2 => 'UD',
1255: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1256: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1257: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1258: x_return_status => x_MODIFIER_LIST_rec.return_status);
1259: END IF;

Line 1257: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1253: p_request_unique_key1 => NULL,
1254: p_request_unique_key2 => 'UD',
1255: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1256: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1257: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1258: x_return_status => x_MODIFIER_LIST_rec.return_status);
1259: END IF;
1260: END IF;
1261: -- Pattern

Line 1267: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1263: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1264: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1265: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1266: qp_delayed_requests_pvt.log_request(
1267: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1268: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1269: p_request_unique_key1 => NULL,
1270: p_request_unique_key2 => 'UD',
1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1267: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1268: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1269: p_request_unique_key1 => NULL,
1270: p_request_unique_key2 => 'UD',
1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1272: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1273: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1274: x_return_status => x_MODIFIER_LIST_rec.return_status);
1275: END IF;

Line 1273: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1269: p_request_unique_key1 => NULL,
1270: p_request_unique_key2 => 'UD',
1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1272: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1273: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1274: x_return_status => x_MODIFIER_LIST_rec.return_status);
1275: END IF;
1276: END IF;
1277: END IF;

Line 1280: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.name,p_old_MODIFIER_LIST_rec.name)

1276: END IF;
1277: END IF;
1278: END IF;
1279:
1280: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.name,p_old_MODIFIER_LIST_rec.name)
1281: THEN
1282: NULL;
1283: END IF;
1284:

Line 1285: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.description,p_old_MODIFIER_LIST_rec.description)

1281: THEN
1282: NULL;
1283: END IF;
1284:
1285: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.description,p_old_MODIFIER_LIST_rec.description)
1286: THEN
1287: NULL;
1288: END IF;
1289:

Line 1291: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code, p_old_MODIFIER_LIST_rec.list_source_code)

1287: NULL;
1288: END IF;
1289:
1290: -- Blanket Pricing
1291: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code, p_old_MODIFIER_LIST_rec.list_source_code)
1292: THEN
1293: NULL;
1294: END IF;
1295:

Line 1296: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref, p_old_MODIFIER_LIST_rec.orig_system_header_ref)

1292: THEN
1293: NULL;
1294: END IF;
1295:
1296: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref, p_old_MODIFIER_LIST_rec.orig_system_header_ref)
1297: THEN
1298: NULL;
1299: END IF;
1300:

Line 1301: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag, p_old_MODIFIER_LIST_rec.shareable_flag)

1297: THEN
1298: NULL;
1299: END IF;
1300:
1301: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag, p_old_MODIFIER_LIST_rec.shareable_flag)
1302: THEN
1303: NULL;
1304: END IF;
1305:

Line 1307: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.org_id, p_old_MODIFIER_LIST_rec.org_id)

1303: NULL;
1304: END IF;
1305:
1306: --added for MOAC
1307: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.org_id, p_old_MODIFIER_LIST_rec.org_id)
1308: THEN
1309: NULL;
1310: END IF;
1311:

Line 2624: IF QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,

2620: AND LANGUAGE = userenv('LANG');
2621:
2622: -- Row locked. Compare IN attributes to DB attributes.
2623:
2624: IF QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,
2625: l_MODIFIER_LIST_rec.attribute1)
2626: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2627: l_MODIFIER_LIST_rec.attribute10)
2628: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,

Line 2626: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,

2622: -- Row locked. Compare IN attributes to DB attributes.
2623:
2624: IF QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,
2625: l_MODIFIER_LIST_rec.attribute1)
2626: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2627: l_MODIFIER_LIST_rec.attribute10)
2628: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2629: l_MODIFIER_LIST_rec.attribute11)
2630: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,

Line 2628: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,

2624: IF QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,
2625: l_MODIFIER_LIST_rec.attribute1)
2626: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2627: l_MODIFIER_LIST_rec.attribute10)
2628: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2629: l_MODIFIER_LIST_rec.attribute11)
2630: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2631: l_MODIFIER_LIST_rec.attribute12)
2632: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,

Line 2630: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,

2626: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2627: l_MODIFIER_LIST_rec.attribute10)
2628: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2629: l_MODIFIER_LIST_rec.attribute11)
2630: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2631: l_MODIFIER_LIST_rec.attribute12)
2632: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2633: l_MODIFIER_LIST_rec.attribute13)
2634: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,

Line 2632: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,

2628: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2629: l_MODIFIER_LIST_rec.attribute11)
2630: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2631: l_MODIFIER_LIST_rec.attribute12)
2632: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2633: l_MODIFIER_LIST_rec.attribute13)
2634: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2635: l_MODIFIER_LIST_rec.attribute14)
2636: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,

Line 2634: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,

2630: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2631: l_MODIFIER_LIST_rec.attribute12)
2632: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2633: l_MODIFIER_LIST_rec.attribute13)
2634: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2635: l_MODIFIER_LIST_rec.attribute14)
2636: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2637: l_MODIFIER_LIST_rec.attribute15)
2638: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,

Line 2636: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,

2632: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2633: l_MODIFIER_LIST_rec.attribute13)
2634: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2635: l_MODIFIER_LIST_rec.attribute14)
2636: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2637: l_MODIFIER_LIST_rec.attribute15)
2638: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2639: l_MODIFIER_LIST_rec.attribute2)
2640: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,

Line 2638: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,

2634: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2635: l_MODIFIER_LIST_rec.attribute14)
2636: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2637: l_MODIFIER_LIST_rec.attribute15)
2638: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2639: l_MODIFIER_LIST_rec.attribute2)
2640: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2641: l_MODIFIER_LIST_rec.attribute3)
2642: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,

Line 2640: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,

2636: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2637: l_MODIFIER_LIST_rec.attribute15)
2638: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2639: l_MODIFIER_LIST_rec.attribute2)
2640: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2641: l_MODIFIER_LIST_rec.attribute3)
2642: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2643: l_MODIFIER_LIST_rec.attribute4)
2644: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,

Line 2642: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,

2638: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2639: l_MODIFIER_LIST_rec.attribute2)
2640: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2641: l_MODIFIER_LIST_rec.attribute3)
2642: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2643: l_MODIFIER_LIST_rec.attribute4)
2644: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2645: l_MODIFIER_LIST_rec.attribute5)
2646: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,

Line 2644: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,

2640: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2641: l_MODIFIER_LIST_rec.attribute3)
2642: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2643: l_MODIFIER_LIST_rec.attribute4)
2644: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2645: l_MODIFIER_LIST_rec.attribute5)
2646: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2647: l_MODIFIER_LIST_rec.attribute6)
2648: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,

Line 2646: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,

2642: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2643: l_MODIFIER_LIST_rec.attribute4)
2644: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2645: l_MODIFIER_LIST_rec.attribute5)
2646: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2647: l_MODIFIER_LIST_rec.attribute6)
2648: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2649: l_MODIFIER_LIST_rec.attribute7)
2650: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,

Line 2648: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,

2644: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2645: l_MODIFIER_LIST_rec.attribute5)
2646: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2647: l_MODIFIER_LIST_rec.attribute6)
2648: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2649: l_MODIFIER_LIST_rec.attribute7)
2650: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2651: l_MODIFIER_LIST_rec.attribute8)
2652: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,

Line 2650: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,

2646: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2647: l_MODIFIER_LIST_rec.attribute6)
2648: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2649: l_MODIFIER_LIST_rec.attribute7)
2650: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2651: l_MODIFIER_LIST_rec.attribute8)
2652: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2653: l_MODIFIER_LIST_rec.attribute9)
2654: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,

Line 2652: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,

2648: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2649: l_MODIFIER_LIST_rec.attribute7)
2650: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2651: l_MODIFIER_LIST_rec.attribute8)
2652: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2653: l_MODIFIER_LIST_rec.attribute9)
2654: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2655: l_MODIFIER_LIST_rec.automatic_flag)
2656: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,

Line 2654: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,

2650: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2651: l_MODIFIER_LIST_rec.attribute8)
2652: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2653: l_MODIFIER_LIST_rec.attribute9)
2654: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2655: l_MODIFIER_LIST_rec.automatic_flag)
2656: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2657: l_MODIFIER_LIST_rec.comments)
2658: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,

Line 2656: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,

2652: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2653: l_MODIFIER_LIST_rec.attribute9)
2654: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2655: l_MODIFIER_LIST_rec.automatic_flag)
2656: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2657: l_MODIFIER_LIST_rec.comments)
2658: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2659: l_MODIFIER_LIST_rec.context)
2660: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,

Line 2658: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,

2654: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2655: l_MODIFIER_LIST_rec.automatic_flag)
2656: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2657: l_MODIFIER_LIST_rec.comments)
2658: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2659: l_MODIFIER_LIST_rec.context)
2660: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2661: l_MODIFIER_LIST_rec.created_by)
2662: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,

Line 2660: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,

2656: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2657: l_MODIFIER_LIST_rec.comments)
2658: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2659: l_MODIFIER_LIST_rec.context)
2660: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2661: l_MODIFIER_LIST_rec.created_by)
2662: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2663: -- l_MODIFIER_LIST_rec.creation_date)
2664: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,

Line 2662: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,

2658: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2659: l_MODIFIER_LIST_rec.context)
2660: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2661: l_MODIFIER_LIST_rec.created_by)
2662: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2663: -- l_MODIFIER_LIST_rec.creation_date)
2664: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2665: l_MODIFIER_LIST_rec.currency_code)
2666: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,

Line 2664: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,

2660: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2661: l_MODIFIER_LIST_rec.created_by)
2662: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2663: -- l_MODIFIER_LIST_rec.creation_date)
2664: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2665: l_MODIFIER_LIST_rec.currency_code)
2666: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2667: l_MODIFIER_LIST_rec.discount_lines_flag)
2668: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,

Line 2666: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,

2662: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2663: -- l_MODIFIER_LIST_rec.creation_date)
2664: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2665: l_MODIFIER_LIST_rec.currency_code)
2666: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2667: l_MODIFIER_LIST_rec.discount_lines_flag)
2668: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2669: l_MODIFIER_LIST_rec.end_date_active)
2670: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,

Line 2668: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,

2664: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2665: l_MODIFIER_LIST_rec.currency_code)
2666: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2667: l_MODIFIER_LIST_rec.discount_lines_flag)
2668: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2669: l_MODIFIER_LIST_rec.end_date_active)
2670: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2671: l_MODIFIER_LIST_rec.freight_terms_code)
2672: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,

Line 2670: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,

2666: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2667: l_MODIFIER_LIST_rec.discount_lines_flag)
2668: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2669: l_MODIFIER_LIST_rec.end_date_active)
2670: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2671: l_MODIFIER_LIST_rec.freight_terms_code)
2672: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2673: l_MODIFIER_LIST_rec.gsa_indicator)
2674: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,

Line 2672: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,

2668: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2669: l_MODIFIER_LIST_rec.end_date_active)
2670: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2671: l_MODIFIER_LIST_rec.freight_terms_code)
2672: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2673: l_MODIFIER_LIST_rec.gsa_indicator)
2674: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2675: l_MODIFIER_LIST_rec.last_updated_by)
2676: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,

Line 2674: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,

2670: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2671: l_MODIFIER_LIST_rec.freight_terms_code)
2672: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2673: l_MODIFIER_LIST_rec.gsa_indicator)
2674: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2675: l_MODIFIER_LIST_rec.last_updated_by)
2676: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2677: -- l_MODIFIER_LIST_rec.last_update_date)
2678: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,

Line 2676: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,

2672: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2673: l_MODIFIER_LIST_rec.gsa_indicator)
2674: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2675: l_MODIFIER_LIST_rec.last_updated_by)
2676: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2677: -- l_MODIFIER_LIST_rec.last_update_date)
2678: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2679: l_MODIFIER_LIST_rec.last_update_login)
2680: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,

Line 2678: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,

2674: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2675: l_MODIFIER_LIST_rec.last_updated_by)
2676: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2677: -- l_MODIFIER_LIST_rec.last_update_date)
2678: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2679: l_MODIFIER_LIST_rec.last_update_login)
2680: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2681: l_MODIFIER_LIST_rec.list_header_id)
2682: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,

Line 2680: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,

2676: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2677: -- l_MODIFIER_LIST_rec.last_update_date)
2678: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2679: l_MODIFIER_LIST_rec.last_update_login)
2680: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2681: l_MODIFIER_LIST_rec.list_header_id)
2682: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2683: l_MODIFIER_LIST_rec.list_type_code)
2684: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,

Line 2682: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,

2678: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2679: l_MODIFIER_LIST_rec.last_update_login)
2680: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2681: l_MODIFIER_LIST_rec.list_header_id)
2682: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2683: l_MODIFIER_LIST_rec.list_type_code)
2684: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2685: -- l_MODIFIER_LIST_rec.program_application_id)
2686: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,

Line 2684: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,

2680: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2681: l_MODIFIER_LIST_rec.list_header_id)
2682: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2683: l_MODIFIER_LIST_rec.list_type_code)
2684: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2685: -- l_MODIFIER_LIST_rec.program_application_id)
2686: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2687: -- l_MODIFIER_LIST_rec.program_id)
2688: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,

Line 2686: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,

2682: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2683: l_MODIFIER_LIST_rec.list_type_code)
2684: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2685: -- l_MODIFIER_LIST_rec.program_application_id)
2686: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2687: -- l_MODIFIER_LIST_rec.program_id)
2688: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2689: -- l_MODIFIER_LIST_rec.program_update_date)
2690: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,

Line 2688: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,

2684: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2685: -- l_MODIFIER_LIST_rec.program_application_id)
2686: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2687: -- l_MODIFIER_LIST_rec.program_id)
2688: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2689: -- l_MODIFIER_LIST_rec.program_update_date)
2690: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2691: l_MODIFIER_LIST_rec.prorate_flag)
2692: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,

Line 2690: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,

2686: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2687: -- l_MODIFIER_LIST_rec.program_id)
2688: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2689: -- l_MODIFIER_LIST_rec.program_update_date)
2690: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2691: l_MODIFIER_LIST_rec.prorate_flag)
2692: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2693: -- l_MODIFIER_LIST_rec.request_id)
2694: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,

Line 2692: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,

2688: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2689: -- l_MODIFIER_LIST_rec.program_update_date)
2690: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2691: l_MODIFIER_LIST_rec.prorate_flag)
2692: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2693: -- l_MODIFIER_LIST_rec.request_id)
2694: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2695: l_MODIFIER_LIST_rec.rounding_factor)
2696: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,

Line 2694: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,

2690: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2691: l_MODIFIER_LIST_rec.prorate_flag)
2692: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2693: -- l_MODIFIER_LIST_rec.request_id)
2694: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2695: l_MODIFIER_LIST_rec.rounding_factor)
2696: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2697: l_MODIFIER_LIST_rec.ship_method_code)
2698: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,

Line 2696: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,

2692: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2693: -- l_MODIFIER_LIST_rec.request_id)
2694: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2695: l_MODIFIER_LIST_rec.rounding_factor)
2696: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2697: l_MODIFIER_LIST_rec.ship_method_code)
2698: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2699: l_MODIFIER_LIST_rec.start_date_active)
2700: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,

Line 2698: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,

2694: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2695: l_MODIFIER_LIST_rec.rounding_factor)
2696: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2697: l_MODIFIER_LIST_rec.ship_method_code)
2698: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2699: l_MODIFIER_LIST_rec.start_date_active)
2700: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2701: l_MODIFIER_LIST_rec.terms_id)
2702: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,

Line 2700: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,

2696: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2697: l_MODIFIER_LIST_rec.ship_method_code)
2698: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2699: l_MODIFIER_LIST_rec.start_date_active)
2700: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2701: l_MODIFIER_LIST_rec.terms_id)
2702: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2703: l_MODIFIER_LIST_rec.source_system_code)
2704: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,

Line 2702: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,

2698: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2699: l_MODIFIER_LIST_rec.start_date_active)
2700: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2701: l_MODIFIER_LIST_rec.terms_id)
2702: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2703: l_MODIFIER_LIST_rec.source_system_code)
2704: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2705: l_MODIFIER_LIST_rec.pte_code)
2706: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,

Line 2704: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,

2700: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2701: l_MODIFIER_LIST_rec.terms_id)
2702: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2703: l_MODIFIER_LIST_rec.source_system_code)
2704: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2705: l_MODIFIER_LIST_rec.pte_code)
2706: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2707: l_MODIFIER_LIST_rec.active_flag)
2708: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,

Line 2706: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,

2702: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2703: l_MODIFIER_LIST_rec.source_system_code)
2704: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2705: l_MODIFIER_LIST_rec.pte_code)
2706: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2707: l_MODIFIER_LIST_rec.active_flag)
2708: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2709: l_MODIFIER_LIST_rec.parent_list_header_id)
2710: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,

Line 2708: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,

2704: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2705: l_MODIFIER_LIST_rec.pte_code)
2706: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2707: l_MODIFIER_LIST_rec.active_flag)
2708: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2709: l_MODIFIER_LIST_rec.parent_list_header_id)
2710: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2711: l_MODIFIER_LIST_rec.start_date_active_first)
2712: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,

Line 2710: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,

2706: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2707: l_MODIFIER_LIST_rec.active_flag)
2708: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2709: l_MODIFIER_LIST_rec.parent_list_header_id)
2710: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2711: l_MODIFIER_LIST_rec.start_date_active_first)
2712: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2713: l_MODIFIER_LIST_rec.end_date_active_first)
2714: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,

Line 2712: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,

2708: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2709: l_MODIFIER_LIST_rec.parent_list_header_id)
2710: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2711: l_MODIFIER_LIST_rec.start_date_active_first)
2712: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2713: l_MODIFIER_LIST_rec.end_date_active_first)
2714: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2715: l_MODIFIER_LIST_rec.active_date_first_type)
2716: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,

Line 2714: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,

2710: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2711: l_MODIFIER_LIST_rec.start_date_active_first)
2712: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2713: l_MODIFIER_LIST_rec.end_date_active_first)
2714: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2715: l_MODIFIER_LIST_rec.active_date_first_type)
2716: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2717: l_MODIFIER_LIST_rec.start_date_active_second)
2718: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,

Line 2716: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,

2712: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2713: l_MODIFIER_LIST_rec.end_date_active_first)
2714: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2715: l_MODIFIER_LIST_rec.active_date_first_type)
2716: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2717: l_MODIFIER_LIST_rec.start_date_active_second)
2718: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2719: l_MODIFIER_LIST_rec.global_flag)
2720: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,

Line 2718: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,

2714: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2715: l_MODIFIER_LIST_rec.active_date_first_type)
2716: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2717: l_MODIFIER_LIST_rec.start_date_active_second)
2718: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2719: l_MODIFIER_LIST_rec.global_flag)
2720: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2721: l_MODIFIER_LIST_rec.end_date_active_second)
2722: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,

Line 2720: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,

2716: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2717: l_MODIFIER_LIST_rec.start_date_active_second)
2718: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2719: l_MODIFIER_LIST_rec.global_flag)
2720: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2721: l_MODIFIER_LIST_rec.end_date_active_second)
2722: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2723: l_MODIFIER_LIST_rec.active_date_second_type)
2724: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,

Line 2722: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,

2718: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2719: l_MODIFIER_LIST_rec.global_flag)
2720: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2721: l_MODIFIER_LIST_rec.end_date_active_second)
2722: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2723: l_MODIFIER_LIST_rec.active_date_second_type)
2724: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2725: l_MODIFIER_LIST_rec.ask_for_flag)
2726: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,

Line 2724: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,

2720: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2721: l_MODIFIER_LIST_rec.end_date_active_second)
2722: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2723: l_MODIFIER_LIST_rec.active_date_second_type)
2724: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2725: l_MODIFIER_LIST_rec.ask_for_flag)
2726: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2727: l_MODIFIER_LIST_rec.list_source_code)
2728: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,

Line 2726: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,

2722: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2723: l_MODIFIER_LIST_rec.active_date_second_type)
2724: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2725: l_MODIFIER_LIST_rec.ask_for_flag)
2726: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2727: l_MODIFIER_LIST_rec.list_source_code)
2728: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
2729: l_MODIFIER_LIST_rec.orig_system_header_ref)
2730: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,

Line 2728: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,

2724: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2725: l_MODIFIER_LIST_rec.ask_for_flag)
2726: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2727: l_MODIFIER_LIST_rec.list_source_code)
2728: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
2729: l_MODIFIER_LIST_rec.orig_system_header_ref)
2730: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,
2731: l_MODIFIER_LIST_rec.shareable_flag)
2732: THEN

Line 2730: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,

2726: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2727: l_MODIFIER_LIST_rec.list_source_code)
2728: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
2729: l_MODIFIER_LIST_rec.orig_system_header_ref)
2730: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,
2731: l_MODIFIER_LIST_rec.shareable_flag)
2732: THEN
2733:
2734: -- Row has not changed. Set out parameter.

Line 2873: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,

2869:
2870: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2871: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND
2872: p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2873: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2874: p_old_MODIFIER_LIST_rec.automatic_flag)
2875: THEN
2876: l_MODIFIER_LIST_val_rec.automatic := QP_Id_To_Value.Automatic
2877: ( p_automatic_flag => p_MODIFIER_LIST_rec.automatic_flag

Line 2883: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,

2879: END IF;
2880:
2881: IF p_MODIFIER_LIST_rec.currency_code IS NOT NULL AND
2882: p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2883: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2884: p_old_MODIFIER_LIST_rec.currency_code)
2885: THEN
2886: l_MODIFIER_LIST_val_rec.currency := QP_Id_To_Value.Currency
2887: ( p_currency_code => p_MODIFIER_LIST_rec.currency_code

Line 2893: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,

2889: END IF;
2890:
2891: IF p_MODIFIER_LIST_rec.discount_lines_flag IS NOT NULL AND
2892: p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2893: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2894: p_old_MODIFIER_LIST_rec.discount_lines_flag)
2895: THEN
2896: l_MODIFIER_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines
2897: ( p_discount_lines_flag => p_MODIFIER_LIST_rec.discount_lines_flag

Line 2903: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,

2899: END IF;
2900:
2901: IF p_MODIFIER_LIST_rec.freight_terms_code IS NOT NULL AND
2902: p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2903: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2904: p_old_MODIFIER_LIST_rec.freight_terms_code)
2905: THEN
2906: l_MODIFIER_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms
2907: ( p_freight_terms_code => p_MODIFIER_LIST_rec.freight_terms_code

Line 2913: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,

2909: END IF;
2910:
2911: IF p_MODIFIER_LIST_rec.list_header_id IS NOT NULL AND
2912: p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2913: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2914: p_old_MODIFIER_LIST_rec.list_header_id)
2915: THEN
2916: l_MODIFIER_LIST_val_rec.list_header := QP_Id_To_Value.List_Header
2917: ( p_list_header_id => p_MODIFIER_LIST_rec.list_header_id

Line 2923: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,

2919: END IF;
2920:
2921: IF p_MODIFIER_LIST_rec.list_type_code IS NOT NULL AND
2922: p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2923: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2924: p_old_MODIFIER_LIST_rec.list_type_code)
2925: THEN
2926: l_MODIFIER_LIST_val_rec.list_type := QP_Id_To_Value.List_Type
2927: ( p_list_type_code => p_MODIFIER_LIST_rec.list_type_code

Line 2933: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,

2929: END IF;
2930:
2931: IF p_MODIFIER_LIST_rec.prorate_flag IS NOT NULL AND
2932: p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2933: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2934: p_old_MODIFIER_LIST_rec.prorate_flag)
2935: THEN
2936: l_MODIFIER_LIST_val_rec.prorate := QP_Id_To_Value.Prorate
2937: ( p_prorate_flag => p_MODIFIER_LIST_rec.prorate_flag

Line 2943: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,

2939: END IF;
2940:
2941: IF p_MODIFIER_LIST_rec.ship_method_code IS NOT NULL AND
2942: p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2943: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2944: p_old_MODIFIER_LIST_rec.ship_method_code)
2945: THEN
2946: l_MODIFIER_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method
2947: ( p_ship_method_code => p_MODIFIER_LIST_rec.ship_method_code

Line 2953: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,

2949: END IF;
2950:
2951: IF p_MODIFIER_LIST_rec.terms_id IS NOT NULL AND
2952: p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2953: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2954: p_old_MODIFIER_LIST_rec.terms_id)
2955: THEN
2956: l_MODIFIER_LIST_val_rec.terms := QP_Id_To_Value.Terms
2957: ( p_terms_id => p_MODIFIER_LIST_rec.terms_id