eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_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: END IF;
658:

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

655: THEN
656: NULL;
657: END IF;
658:
659: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,p_old_MODIFIER_LIST_rec.comments)
660: THEN
661: NULL;
662: END IF;
663:

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

660: THEN
661: NULL;
662: END IF;
663:
664: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,p_old_MODIFIER_LIST_rec.context)
665: THEN
666: NULL;
667: END IF;
668:

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

665: THEN
666: NULL;
667: END IF;
668:
669: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,p_old_MODIFIER_LIST_rec.created_by)
670: THEN
671: NULL;
672: END IF;
673:

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

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

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

675: THEN
676: NULL;
677: END IF;
678:
679: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,p_old_MODIFIER_LIST_rec.currency_code)
680: THEN
681: -- NULL;
682: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
683: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 685: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

681: -- NULL;
682: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
683: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
684: qp_delayed_requests_pvt.log_request(
685: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
686: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
687: p_request_unique_key1 => NULL,
688: p_request_unique_key2 => 'UD',
689: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 689: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

685: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
686: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
687: p_request_unique_key1 => NULL,
688: p_request_unique_key2 => 'UD',
689: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
690: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
691: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
692: x_return_status => x_MODIFIER_LIST_rec.return_status);
693: END IF;

Line 691: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

687: p_request_unique_key1 => NULL,
688: p_request_unique_key2 => 'UD',
689: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
690: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
691: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
692: x_return_status => x_MODIFIER_LIST_rec.return_status);
693: END IF;
694: END IF;
695: -- Pattern

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

694: END IF;
695: -- Pattern
696: END IF;
697:
698: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,p_old_MODIFIER_LIST_rec.discount_lines_flag)
699: THEN
700: NULL;
701: END IF;
702:

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

699: THEN
700: NULL;
701: END IF;
702:
703: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,p_old_MODIFIER_LIST_rec.end_date_active)
704: THEN
705: NULL;
706: END IF;
707:

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

704: THEN
705: NULL;
706: END IF;
707:
708: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,p_old_MODIFIER_LIST_rec.freight_terms_code)
709: THEN
710: NULL;
711: END IF;
712:

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

709: THEN
710: NULL;
711: END IF;
712:
713: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,p_old_MODIFIER_LIST_rec.gsa_indicator)
714: THEN
715: NULL;
716: END IF;
717:

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

714: THEN
715: NULL;
716: END IF;
717:
718: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
719: THEN
720: NULL;
721: END IF;
722:

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

719: THEN
720: NULL;
721: END IF;
722:
723: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
724: THEN
725: NULL;
726: END IF;
727:

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

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

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

729: THEN
730: NULL;
731: END IF;
732:
733: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,p_old_MODIFIER_LIST_rec.list_header_id)
734: THEN
735: NULL;
736: END IF;
737:

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

734: THEN
735: NULL;
736: END IF;
737:
738: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,p_old_MODIFIER_LIST_rec.list_type_code)
739: THEN
740: NULL;
741: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
742: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 744: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

740: NULL;
741: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
742: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
743: qp_delayed_requests_pvt.log_request(
744: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
745: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
746: p_request_unique_key1 => NULL,
747: p_request_unique_key2 => 'UD',
748: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 748: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 750: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

746: p_request_unique_key1 => NULL,
747: p_request_unique_key2 => 'UD',
748: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
749: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
750: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
751: x_return_status => x_MODIFIER_LIST_rec.return_status);
752: END IF;
753: END IF;
754: -- Pattern

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

753: END IF;
754: -- Pattern
755: END IF;
756:
757: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,p_old_MODIFIER_LIST_rec.program_application_id)
758: THEN
759: NULL;
760: END IF;
761:

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

758: THEN
759: NULL;
760: END IF;
761:
762: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,p_old_MODIFIER_LIST_rec.program_id)
763: THEN
764: NULL;
765: END IF;
766:

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

763: THEN
764: NULL;
765: END IF;
766:
767: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
768: THEN
769: NULL;
770: END IF;
771:

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

768: THEN
769: NULL;
770: END IF;
771:
772: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,p_old_MODIFIER_LIST_rec.prorate_flag)
773: THEN
774: NULL;
775: END IF;
776:

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

773: THEN
774: NULL;
775: END IF;
776:
777: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,p_old_MODIFIER_LIST_rec.request_id)
778: THEN
779: NULL;
780: END IF;
781:

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

778: THEN
779: NULL;
780: END IF;
781:
782: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,p_old_MODIFIER_LIST_rec.rounding_factor)
783: THEN
784: NULL;
785: END IF;
786:

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

783: THEN
784: NULL;
785: END IF;
786:
787: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,p_old_MODIFIER_LIST_rec.ship_method_code)
788: THEN
789: NULL;
790: END IF;
791:

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

788: THEN
789: NULL;
790: END IF;
791:
792: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,p_old_MODIFIER_LIST_rec.start_date_active)
793: THEN
794: NULL;
795: END IF;
796:

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

793: THEN
794: NULL;
795: END IF;
796:
797: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,p_old_MODIFIER_LIST_rec.terms_id)
798: THEN
799: NULL;
800: END IF;
801:

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

798: THEN
799: NULL;
800: END IF;
801:
802: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,p_old_MODIFIER_LIST_rec.source_system_code)
803: THEN
804: NULL;
805: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
806: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 808: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

804: NULL;
805: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
806: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
807: qp_delayed_requests_pvt.log_request(
808: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
809: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
810: p_request_unique_key1 => NULL,
811: p_request_unique_key2 => 'UD',
812: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 812: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

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

Line 814: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

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

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

817: END IF;
818: -- Pattern
819: END IF;
820:
821: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,p_old_MODIFIER_LIST_rec.pte_code)
822: THEN
823: NULL;
824: END IF;
825:

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

822: THEN
823: NULL;
824: END IF;
825:
826: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,p_old_MODIFIER_LIST_rec.active_flag)
827: THEN
828: NULL;
829:
830: --hw

Line 834: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

830: --hw
831: -- log delayed request for changed lines for active flag change
832: if QP_PERF_PVT.enabled = 'Y' then
833: qp_delayed_requests_pvt.log_request(
834: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
835: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
837: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
838: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,

Line 836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

832: if QP_PERF_PVT.enabled = 'Y' then
833: qp_delayed_requests_pvt.log_request(
834: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
835: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
837: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
838: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,
839: p_param1 => p_MODIFIER_LIST_rec.active_flag,
840: x_return_status => x_MODIFIER_LIST_rec.return_status);

Line 838: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,

834: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
835: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
836: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
837: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
838: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT,
839: p_param1 => p_MODIFIER_LIST_rec.active_flag,
840: x_return_status => x_MODIFIER_LIST_rec.return_status);
841: end if;
842:

Line 845: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

841: end if;
842:
843: --hvop
844: qp_delayed_requests_pvt.log_request(
845: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
846: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
847: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
848: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
849: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

Line 847: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

843: --hvop
844: qp_delayed_requests_pvt.log_request(
845: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
846: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
847: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
848: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
849: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
850: x_return_status => x_MODIFIER_LIST_rec.return_status);
851: --hvop

Line 849: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

845: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
846: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
847: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
848: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
849: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
850: x_return_status => x_MODIFIER_LIST_rec.return_status);
851: --hvop
852: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
853: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 855: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

851: --hvop
852: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
853: IF (p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
854: qp_delayed_requests_pvt.log_request(
855: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
856: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
857: p_request_unique_key1 => NULL,
858: p_request_unique_key2 => 'UD',
859: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 859: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

855: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
856: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
857: p_request_unique_key1 => NULL,
858: p_request_unique_key2 => 'UD',
859: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
860: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
861: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
862: x_return_status => x_MODIFIER_LIST_rec.return_status);
863: END IF;

Line 861: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

857: p_request_unique_key1 => NULL,
858: p_request_unique_key2 => 'UD',
859: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
860: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
861: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
862: x_return_status => x_MODIFIER_LIST_rec.return_status);
863: END IF;
864: END IF; --Java Engine Installed
865: -- Pattern

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

864: END IF; --Java Engine Installed
865: -- Pattern
866: --to populate rltd_Exists,oid_exists,prg_exists and qp_basic_modifiers_setup
867: --performance profile
868: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
869:
870: BEGIN
871: select 'Y' into l_modifiers_exist
872: from qp_list_lines

Line 887: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

883: FOR I in l_pricing_phase_cur(p_MODIFIER_LIST_rec.list_header_id)
884: LOOP
885:
886: qp_delayed_requests_PVT.log_request(
887: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
888: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
889: p_param1 => I.pricing_phase_id,
890: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
891: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,

Line 890: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

886: qp_delayed_requests_PVT.log_request(
887: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
888: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
889: p_param1 => I.pricing_phase_id,
890: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
891: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
892: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,
893: x_return_status => x_MODIFIER_LIST_rec.return_status);
894: END LOOP;

Line 892: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,

888: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
889: p_param1 => I.pricing_phase_id,
890: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
891: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
892: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE,
893: x_return_status => x_MODIFIER_LIST_rec.return_status);
894: END LOOP;
895:
896: qp_delayed_requests_pvt.log_request(

Line 897: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

893: x_return_status => x_MODIFIER_LIST_rec.return_status);
894: END LOOP;
895:
896: qp_delayed_requests_pvt.log_request(
897: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
898: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
899: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
900: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
901: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

Line 899: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

895:
896: qp_delayed_requests_pvt.log_request(
897: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
898: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
899: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
900: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
901: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
902: x_return_status => x_MODIFIER_LIST_rec.return_status);
903: END IF;

Line 901: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,

897: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
898: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
899: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
900: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
901: p_request_type => QP_GLOBALS.G_UPDATE_HVOP,
902: x_return_status => x_MODIFIER_LIST_rec.return_status);
903: END IF;
904: END IF;
905:

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

902: x_return_status => x_MODIFIER_LIST_rec.return_status);
903: END IF;
904: END IF;
905:
906: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
907:
908: Update QP_QUALIFIERS
909: set active_flag = p_MODIFIER_LIST_rec.active_flag
910: where list_header_id = p_MODIFIER_LIST_rec.list_header_id;

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

985:
986: END IF;
987: END IF;
988:
989: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,p_old_MODIFIER_LIST_rec.parent_list_header_id)
990: THEN
991: NULL;
992: END IF;
993:

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

990: THEN
991: NULL;
992: END IF;
993:
994: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,p_old_MODIFIER_LIST_rec.start_date_active_first)
995: THEN
996: NULL;
997: END IF;
998:

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

995: THEN
996: NULL;
997: END IF;
998:
999: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,p_old_MODIFIER_LIST_rec.end_date_active_first)
1000: THEN
1001: NULL;
1002: END IF;
1003:

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

1000: THEN
1001: NULL;
1002: END IF;
1003:
1004: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,p_old_MODIFIER_LIST_rec.active_date_first_type)
1005: THEN
1006: NULL;
1007: END IF;
1008:

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

1005: THEN
1006: NULL;
1007: END IF;
1008:
1009: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,p_old_MODIFIER_LIST_rec.start_date_active_second)
1010: THEN
1011: NULL;
1012: END IF;
1013:

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

1010: THEN
1011: NULL;
1012: END IF;
1013:
1014: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,p_old_MODIFIER_LIST_rec.global_flag)
1015: THEN
1016: NULL;
1017: END IF;
1018:

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

1016: NULL;
1017: END IF;
1018:
1019:
1020: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,p_old_MODIFIER_LIST_rec.end_date_active_second)
1021: THEN
1022: NULL;
1023: END IF;
1024:

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

1021: THEN
1022: NULL;
1023: END IF;
1024:
1025: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,p_old_MODIFIER_LIST_rec.active_date_second_type)
1026: THEN
1027: NULL;
1028: END IF;
1029:

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

1026: THEN
1027: NULL;
1028: END IF;
1029:
1030: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,p_old_MODIFIER_LIST_rec.ask_for_flag)
1031: THEN
1032: NULL;
1033: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1034: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 1036: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1032: NULL;
1033: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1034: IF(p_MODIFIER_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
1035: qp_delayed_requests_pvt.log_request(
1036: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1037: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1038: p_request_unique_key1 => NULL,
1039: p_request_unique_key2 => 'UD',
1040: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1040: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1036: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1037: p_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1038: p_request_unique_key1 => NULL,
1039: p_request_unique_key2 => 'UD',
1040: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1041: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1042: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1043: x_return_status => x_MODIFIER_LIST_rec.return_status);
1044: END IF;

Line 1042: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

1038: p_request_unique_key1 => NULL,
1039: p_request_unique_key2 => 'UD',
1040: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1041: p_requesting_entity_id => p_MODIFIER_LIST_rec.list_header_id,
1042: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
1043: x_return_status => x_MODIFIER_LIST_rec.return_status);
1044: END IF;
1045: END IF;
1046: -- Pattern

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

1045: END IF;
1046: -- Pattern
1047: END IF;
1048:
1049: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.name,p_old_MODIFIER_LIST_rec.name)
1050: THEN
1051: NULL;
1052: END IF;
1053:

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

1050: THEN
1051: NULL;
1052: END IF;
1053:
1054: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.description,p_old_MODIFIER_LIST_rec.description)
1055: THEN
1056: NULL;
1057: END IF;
1058:

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

1056: NULL;
1057: END IF;
1058:
1059: -- Blanket Pricing
1060: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code, p_old_MODIFIER_LIST_rec.list_source_code)
1061: THEN
1062: NULL;
1063: END IF;
1064:

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

1061: THEN
1062: NULL;
1063: END IF;
1064:
1065: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref, p_old_MODIFIER_LIST_rec.orig_system_header_ref)
1066: THEN
1067: NULL;
1068: END IF;
1069:

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

1066: THEN
1067: NULL;
1068: END IF;
1069:
1070: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag, p_old_MODIFIER_LIST_rec.shareable_flag)
1071: THEN
1072: NULL;
1073: END IF;
1074:

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

1072: NULL;
1073: END IF;
1074:
1075: --added for MOAC
1076: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.org_id, p_old_MODIFIER_LIST_rec.org_id)
1077: THEN
1078: NULL;
1079: END IF;
1080:

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

2389: AND LANGUAGE = userenv('LANG');
2390:
2391: -- Row locked. Compare IN attributes to DB attributes.
2392:
2393: IF QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,
2394: l_MODIFIER_LIST_rec.attribute1)
2395: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2396: l_MODIFIER_LIST_rec.attribute10)
2397: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,

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

2391: -- Row locked. Compare IN attributes to DB attributes.
2392:
2393: IF QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,
2394: l_MODIFIER_LIST_rec.attribute1)
2395: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2396: l_MODIFIER_LIST_rec.attribute10)
2397: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2398: l_MODIFIER_LIST_rec.attribute11)
2399: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,

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

2393: IF QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,
2394: l_MODIFIER_LIST_rec.attribute1)
2395: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2396: l_MODIFIER_LIST_rec.attribute10)
2397: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2398: l_MODIFIER_LIST_rec.attribute11)
2399: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2400: l_MODIFIER_LIST_rec.attribute12)
2401: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,

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

2395: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,
2396: l_MODIFIER_LIST_rec.attribute10)
2397: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2398: l_MODIFIER_LIST_rec.attribute11)
2399: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2400: l_MODIFIER_LIST_rec.attribute12)
2401: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2402: l_MODIFIER_LIST_rec.attribute13)
2403: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,

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

2397: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,
2398: l_MODIFIER_LIST_rec.attribute11)
2399: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2400: l_MODIFIER_LIST_rec.attribute12)
2401: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2402: l_MODIFIER_LIST_rec.attribute13)
2403: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2404: l_MODIFIER_LIST_rec.attribute14)
2405: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,

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

2399: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,
2400: l_MODIFIER_LIST_rec.attribute12)
2401: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2402: l_MODIFIER_LIST_rec.attribute13)
2403: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2404: l_MODIFIER_LIST_rec.attribute14)
2405: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2406: l_MODIFIER_LIST_rec.attribute15)
2407: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,

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

2401: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,
2402: l_MODIFIER_LIST_rec.attribute13)
2403: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2404: l_MODIFIER_LIST_rec.attribute14)
2405: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2406: l_MODIFIER_LIST_rec.attribute15)
2407: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2408: l_MODIFIER_LIST_rec.attribute2)
2409: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,

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

2403: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,
2404: l_MODIFIER_LIST_rec.attribute14)
2405: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2406: l_MODIFIER_LIST_rec.attribute15)
2407: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2408: l_MODIFIER_LIST_rec.attribute2)
2409: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2410: l_MODIFIER_LIST_rec.attribute3)
2411: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,

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

2405: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,
2406: l_MODIFIER_LIST_rec.attribute15)
2407: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2408: l_MODIFIER_LIST_rec.attribute2)
2409: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2410: l_MODIFIER_LIST_rec.attribute3)
2411: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2412: l_MODIFIER_LIST_rec.attribute4)
2413: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,

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

2407: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,
2408: l_MODIFIER_LIST_rec.attribute2)
2409: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2410: l_MODIFIER_LIST_rec.attribute3)
2411: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2412: l_MODIFIER_LIST_rec.attribute4)
2413: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2414: l_MODIFIER_LIST_rec.attribute5)
2415: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,

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

2409: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,
2410: l_MODIFIER_LIST_rec.attribute3)
2411: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2412: l_MODIFIER_LIST_rec.attribute4)
2413: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2414: l_MODIFIER_LIST_rec.attribute5)
2415: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2416: l_MODIFIER_LIST_rec.attribute6)
2417: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,

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

2411: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,
2412: l_MODIFIER_LIST_rec.attribute4)
2413: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2414: l_MODIFIER_LIST_rec.attribute5)
2415: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2416: l_MODIFIER_LIST_rec.attribute6)
2417: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2418: l_MODIFIER_LIST_rec.attribute7)
2419: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,

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

2413: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,
2414: l_MODIFIER_LIST_rec.attribute5)
2415: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2416: l_MODIFIER_LIST_rec.attribute6)
2417: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2418: l_MODIFIER_LIST_rec.attribute7)
2419: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2420: l_MODIFIER_LIST_rec.attribute8)
2421: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,

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

2415: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,
2416: l_MODIFIER_LIST_rec.attribute6)
2417: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2418: l_MODIFIER_LIST_rec.attribute7)
2419: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2420: l_MODIFIER_LIST_rec.attribute8)
2421: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2422: l_MODIFIER_LIST_rec.attribute9)
2423: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,

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

2417: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,
2418: l_MODIFIER_LIST_rec.attribute7)
2419: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2420: l_MODIFIER_LIST_rec.attribute8)
2421: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2422: l_MODIFIER_LIST_rec.attribute9)
2423: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2424: l_MODIFIER_LIST_rec.automatic_flag)
2425: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,

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

2419: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,
2420: l_MODIFIER_LIST_rec.attribute8)
2421: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2422: l_MODIFIER_LIST_rec.attribute9)
2423: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2424: l_MODIFIER_LIST_rec.automatic_flag)
2425: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2426: l_MODIFIER_LIST_rec.comments)
2427: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,

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

2421: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,
2422: l_MODIFIER_LIST_rec.attribute9)
2423: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2424: l_MODIFIER_LIST_rec.automatic_flag)
2425: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2426: l_MODIFIER_LIST_rec.comments)
2427: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2428: l_MODIFIER_LIST_rec.context)
2429: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,

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

2423: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2424: l_MODIFIER_LIST_rec.automatic_flag)
2425: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2426: l_MODIFIER_LIST_rec.comments)
2427: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2428: l_MODIFIER_LIST_rec.context)
2429: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2430: l_MODIFIER_LIST_rec.created_by)
2431: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,

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

2425: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,
2426: l_MODIFIER_LIST_rec.comments)
2427: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2428: l_MODIFIER_LIST_rec.context)
2429: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2430: l_MODIFIER_LIST_rec.created_by)
2431: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2432: -- l_MODIFIER_LIST_rec.creation_date)
2433: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,

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

2427: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,
2428: l_MODIFIER_LIST_rec.context)
2429: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2430: l_MODIFIER_LIST_rec.created_by)
2431: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2432: -- l_MODIFIER_LIST_rec.creation_date)
2433: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2434: l_MODIFIER_LIST_rec.currency_code)
2435: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,

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

2429: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,
2430: l_MODIFIER_LIST_rec.created_by)
2431: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2432: -- l_MODIFIER_LIST_rec.creation_date)
2433: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2434: l_MODIFIER_LIST_rec.currency_code)
2435: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2436: l_MODIFIER_LIST_rec.discount_lines_flag)
2437: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,

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

2431: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,
2432: -- l_MODIFIER_LIST_rec.creation_date)
2433: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2434: l_MODIFIER_LIST_rec.currency_code)
2435: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2436: l_MODIFIER_LIST_rec.discount_lines_flag)
2437: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2438: l_MODIFIER_LIST_rec.end_date_active)
2439: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,

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

2433: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2434: l_MODIFIER_LIST_rec.currency_code)
2435: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2436: l_MODIFIER_LIST_rec.discount_lines_flag)
2437: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2438: l_MODIFIER_LIST_rec.end_date_active)
2439: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2440: l_MODIFIER_LIST_rec.freight_terms_code)
2441: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,

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

2435: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2436: l_MODIFIER_LIST_rec.discount_lines_flag)
2437: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2438: l_MODIFIER_LIST_rec.end_date_active)
2439: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2440: l_MODIFIER_LIST_rec.freight_terms_code)
2441: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2442: l_MODIFIER_LIST_rec.gsa_indicator)
2443: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,

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

2437: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,
2438: l_MODIFIER_LIST_rec.end_date_active)
2439: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2440: l_MODIFIER_LIST_rec.freight_terms_code)
2441: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2442: l_MODIFIER_LIST_rec.gsa_indicator)
2443: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2444: l_MODIFIER_LIST_rec.last_updated_by)
2445: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,

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

2439: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2440: l_MODIFIER_LIST_rec.freight_terms_code)
2441: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2442: l_MODIFIER_LIST_rec.gsa_indicator)
2443: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2444: l_MODIFIER_LIST_rec.last_updated_by)
2445: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2446: -- l_MODIFIER_LIST_rec.last_update_date)
2447: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,

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

2441: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,
2442: l_MODIFIER_LIST_rec.gsa_indicator)
2443: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2444: l_MODIFIER_LIST_rec.last_updated_by)
2445: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2446: -- l_MODIFIER_LIST_rec.last_update_date)
2447: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2448: l_MODIFIER_LIST_rec.last_update_login)
2449: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,

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

2443: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,
2444: l_MODIFIER_LIST_rec.last_updated_by)
2445: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2446: -- l_MODIFIER_LIST_rec.last_update_date)
2447: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2448: l_MODIFIER_LIST_rec.last_update_login)
2449: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2450: l_MODIFIER_LIST_rec.list_header_id)
2451: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,

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

2445: -- AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,
2446: -- l_MODIFIER_LIST_rec.last_update_date)
2447: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2448: l_MODIFIER_LIST_rec.last_update_login)
2449: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2450: l_MODIFIER_LIST_rec.list_header_id)
2451: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2452: l_MODIFIER_LIST_rec.list_type_code)
2453: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,

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

2447: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,
2448: l_MODIFIER_LIST_rec.last_update_login)
2449: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2450: l_MODIFIER_LIST_rec.list_header_id)
2451: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2452: l_MODIFIER_LIST_rec.list_type_code)
2453: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2454: -- l_MODIFIER_LIST_rec.program_application_id)
2455: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,

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

2449: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2450: l_MODIFIER_LIST_rec.list_header_id)
2451: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2452: l_MODIFIER_LIST_rec.list_type_code)
2453: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2454: -- l_MODIFIER_LIST_rec.program_application_id)
2455: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2456: -- l_MODIFIER_LIST_rec.program_id)
2457: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,

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

2451: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2452: l_MODIFIER_LIST_rec.list_type_code)
2453: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2454: -- l_MODIFIER_LIST_rec.program_application_id)
2455: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2456: -- l_MODIFIER_LIST_rec.program_id)
2457: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2458: -- l_MODIFIER_LIST_rec.program_update_date)
2459: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,

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

2453: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,
2454: -- l_MODIFIER_LIST_rec.program_application_id)
2455: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2456: -- l_MODIFIER_LIST_rec.program_id)
2457: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2458: -- l_MODIFIER_LIST_rec.program_update_date)
2459: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2460: l_MODIFIER_LIST_rec.prorate_flag)
2461: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,

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

2455: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,
2456: -- l_MODIFIER_LIST_rec.program_id)
2457: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2458: -- l_MODIFIER_LIST_rec.program_update_date)
2459: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2460: l_MODIFIER_LIST_rec.prorate_flag)
2461: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2462: -- l_MODIFIER_LIST_rec.request_id)
2463: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,

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

2457: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,
2458: -- l_MODIFIER_LIST_rec.program_update_date)
2459: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2460: l_MODIFIER_LIST_rec.prorate_flag)
2461: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2462: -- l_MODIFIER_LIST_rec.request_id)
2463: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2464: l_MODIFIER_LIST_rec.rounding_factor)
2465: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,

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

2459: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2460: l_MODIFIER_LIST_rec.prorate_flag)
2461: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2462: -- l_MODIFIER_LIST_rec.request_id)
2463: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2464: l_MODIFIER_LIST_rec.rounding_factor)
2465: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2466: l_MODIFIER_LIST_rec.ship_method_code)
2467: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,

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

2461: --AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,
2462: -- l_MODIFIER_LIST_rec.request_id)
2463: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2464: l_MODIFIER_LIST_rec.rounding_factor)
2465: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2466: l_MODIFIER_LIST_rec.ship_method_code)
2467: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2468: l_MODIFIER_LIST_rec.start_date_active)
2469: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,

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

2463: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,
2464: l_MODIFIER_LIST_rec.rounding_factor)
2465: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2466: l_MODIFIER_LIST_rec.ship_method_code)
2467: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2468: l_MODIFIER_LIST_rec.start_date_active)
2469: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2470: l_MODIFIER_LIST_rec.terms_id)
2471: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,

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

2465: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2466: l_MODIFIER_LIST_rec.ship_method_code)
2467: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2468: l_MODIFIER_LIST_rec.start_date_active)
2469: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2470: l_MODIFIER_LIST_rec.terms_id)
2471: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2472: l_MODIFIER_LIST_rec.source_system_code)
2473: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,

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

2467: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,
2468: l_MODIFIER_LIST_rec.start_date_active)
2469: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2470: l_MODIFIER_LIST_rec.terms_id)
2471: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2472: l_MODIFIER_LIST_rec.source_system_code)
2473: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2474: l_MODIFIER_LIST_rec.pte_code)
2475: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,

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

2469: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2470: l_MODIFIER_LIST_rec.terms_id)
2471: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2472: l_MODIFIER_LIST_rec.source_system_code)
2473: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2474: l_MODIFIER_LIST_rec.pte_code)
2475: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2476: l_MODIFIER_LIST_rec.active_flag)
2477: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,

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

2471: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,
2472: l_MODIFIER_LIST_rec.source_system_code)
2473: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2474: l_MODIFIER_LIST_rec.pte_code)
2475: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2476: l_MODIFIER_LIST_rec.active_flag)
2477: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2478: l_MODIFIER_LIST_rec.parent_list_header_id)
2479: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,

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

2473: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,
2474: l_MODIFIER_LIST_rec.pte_code)
2475: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2476: l_MODIFIER_LIST_rec.active_flag)
2477: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2478: l_MODIFIER_LIST_rec.parent_list_header_id)
2479: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2480: l_MODIFIER_LIST_rec.start_date_active_first)
2481: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,

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

2475: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,
2476: l_MODIFIER_LIST_rec.active_flag)
2477: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2478: l_MODIFIER_LIST_rec.parent_list_header_id)
2479: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2480: l_MODIFIER_LIST_rec.start_date_active_first)
2481: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2482: l_MODIFIER_LIST_rec.end_date_active_first)
2483: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,

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

2477: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,
2478: l_MODIFIER_LIST_rec.parent_list_header_id)
2479: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2480: l_MODIFIER_LIST_rec.start_date_active_first)
2481: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2482: l_MODIFIER_LIST_rec.end_date_active_first)
2483: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2484: l_MODIFIER_LIST_rec.active_date_first_type)
2485: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,

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

2479: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,
2480: l_MODIFIER_LIST_rec.start_date_active_first)
2481: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2482: l_MODIFIER_LIST_rec.end_date_active_first)
2483: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2484: l_MODIFIER_LIST_rec.active_date_first_type)
2485: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2486: l_MODIFIER_LIST_rec.start_date_active_second)
2487: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,

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

2481: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,
2482: l_MODIFIER_LIST_rec.end_date_active_first)
2483: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2484: l_MODIFIER_LIST_rec.active_date_first_type)
2485: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2486: l_MODIFIER_LIST_rec.start_date_active_second)
2487: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2488: l_MODIFIER_LIST_rec.global_flag)
2489: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,

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

2483: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,
2484: l_MODIFIER_LIST_rec.active_date_first_type)
2485: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2486: l_MODIFIER_LIST_rec.start_date_active_second)
2487: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2488: l_MODIFIER_LIST_rec.global_flag)
2489: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2490: l_MODIFIER_LIST_rec.end_date_active_second)
2491: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,

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

2485: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,
2486: l_MODIFIER_LIST_rec.start_date_active_second)
2487: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2488: l_MODIFIER_LIST_rec.global_flag)
2489: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2490: l_MODIFIER_LIST_rec.end_date_active_second)
2491: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2492: l_MODIFIER_LIST_rec.active_date_second_type)
2493: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,

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

2487: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,
2488: l_MODIFIER_LIST_rec.global_flag)
2489: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2490: l_MODIFIER_LIST_rec.end_date_active_second)
2491: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2492: l_MODIFIER_LIST_rec.active_date_second_type)
2493: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2494: l_MODIFIER_LIST_rec.ask_for_flag)
2495: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,

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

2489: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,
2490: l_MODIFIER_LIST_rec.end_date_active_second)
2491: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2492: l_MODIFIER_LIST_rec.active_date_second_type)
2493: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2494: l_MODIFIER_LIST_rec.ask_for_flag)
2495: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2496: l_MODIFIER_LIST_rec.list_source_code)
2497: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,

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

2491: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,
2492: l_MODIFIER_LIST_rec.active_date_second_type)
2493: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2494: l_MODIFIER_LIST_rec.ask_for_flag)
2495: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2496: l_MODIFIER_LIST_rec.list_source_code)
2497: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
2498: l_MODIFIER_LIST_rec.orig_system_header_ref)
2499: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,

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

2493: AND QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,
2494: l_MODIFIER_LIST_rec.ask_for_flag)
2495: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2496: l_MODIFIER_LIST_rec.list_source_code)
2497: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
2498: l_MODIFIER_LIST_rec.orig_system_header_ref)
2499: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,
2500: l_MODIFIER_LIST_rec.shareable_flag)
2501: THEN

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

2495: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code,
2496: l_MODIFIER_LIST_rec.list_source_code)
2497: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref,
2498: l_MODIFIER_LIST_rec.orig_system_header_ref)
2499: AND QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,
2500: l_MODIFIER_LIST_rec.shareable_flag)
2501: THEN
2502:
2503: -- Row has not changed. Set out parameter.

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

2581:
2582: oe_debug_pub.add('BEGIN get_values in QPXUMLHB');
2583: IF p_MODIFIER_LIST_rec.automatic_flag IS NOT NULL AND
2584: p_MODIFIER_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
2585: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,
2586: p_old_MODIFIER_LIST_rec.automatic_flag)
2587: THEN
2588: l_MODIFIER_LIST_val_rec.automatic := QP_Id_To_Value.Automatic
2589: ( p_automatic_flag => p_MODIFIER_LIST_rec.automatic_flag

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

2591: END IF;
2592:
2593: IF p_MODIFIER_LIST_rec.currency_code IS NOT NULL AND
2594: p_MODIFIER_LIST_rec.currency_code <> FND_API.G_MISS_CHAR AND
2595: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,
2596: p_old_MODIFIER_LIST_rec.currency_code)
2597: THEN
2598: l_MODIFIER_LIST_val_rec.currency := QP_Id_To_Value.Currency
2599: ( p_currency_code => p_MODIFIER_LIST_rec.currency_code

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

2601: END IF;
2602:
2603: IF p_MODIFIER_LIST_rec.discount_lines_flag IS NOT NULL AND
2604: p_MODIFIER_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR AND
2605: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,
2606: p_old_MODIFIER_LIST_rec.discount_lines_flag)
2607: THEN
2608: l_MODIFIER_LIST_val_rec.discount_lines := QP_Id_To_Value.Discount_Lines
2609: ( p_discount_lines_flag => p_MODIFIER_LIST_rec.discount_lines_flag

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

2611: END IF;
2612:
2613: IF p_MODIFIER_LIST_rec.freight_terms_code IS NOT NULL AND
2614: p_MODIFIER_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR AND
2615: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,
2616: p_old_MODIFIER_LIST_rec.freight_terms_code)
2617: THEN
2618: l_MODIFIER_LIST_val_rec.freight_terms := QP_Id_To_Value.Freight_Terms
2619: ( p_freight_terms_code => p_MODIFIER_LIST_rec.freight_terms_code

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

2621: END IF;
2622:
2623: IF p_MODIFIER_LIST_rec.list_header_id IS NOT NULL AND
2624: p_MODIFIER_LIST_rec.list_header_id <> FND_API.G_MISS_NUM AND
2625: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,
2626: p_old_MODIFIER_LIST_rec.list_header_id)
2627: THEN
2628: l_MODIFIER_LIST_val_rec.list_header := QP_Id_To_Value.List_Header
2629: ( p_list_header_id => p_MODIFIER_LIST_rec.list_header_id

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

2631: END IF;
2632:
2633: IF p_MODIFIER_LIST_rec.list_type_code IS NOT NULL AND
2634: p_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR AND
2635: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,
2636: p_old_MODIFIER_LIST_rec.list_type_code)
2637: THEN
2638: l_MODIFIER_LIST_val_rec.list_type := QP_Id_To_Value.List_Type
2639: ( p_list_type_code => p_MODIFIER_LIST_rec.list_type_code

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

2641: END IF;
2642:
2643: IF p_MODIFIER_LIST_rec.prorate_flag IS NOT NULL AND
2644: p_MODIFIER_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR AND
2645: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,
2646: p_old_MODIFIER_LIST_rec.prorate_flag)
2647: THEN
2648: l_MODIFIER_LIST_val_rec.prorate := QP_Id_To_Value.Prorate
2649: ( p_prorate_flag => p_MODIFIER_LIST_rec.prorate_flag

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

2651: END IF;
2652:
2653: IF p_MODIFIER_LIST_rec.ship_method_code IS NOT NULL AND
2654: p_MODIFIER_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR AND
2655: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,
2656: p_old_MODIFIER_LIST_rec.ship_method_code)
2657: THEN
2658: l_MODIFIER_LIST_val_rec.ship_method := QP_Id_To_Value.Ship_Method
2659: ( p_ship_method_code => p_MODIFIER_LIST_rec.ship_method_code

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

2661: END IF;
2662:
2663: IF p_MODIFIER_LIST_rec.terms_id IS NOT NULL AND
2664: p_MODIFIER_LIST_rec.terms_id <> FND_API.G_MISS_NUM AND
2665: NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,
2666: p_old_MODIFIER_LIST_rec.terms_id)
2667: THEN
2668: l_MODIFIER_LIST_val_rec.terms := QP_Id_To_Value.Terms
2669: ( p_terms_id => p_MODIFIER_LIST_rec.terms_id