APPS.QP_MODIFIERS_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_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: oe_debug_pub.add('BEGIN Clear_dependent_Attr in QPXUMLLB');

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

Line 34: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)

30: -- every changed attribute clear its dependent fields.
31:
32: IF p_attr_id = FND_API.G_MISS_NUM THEN
33:
34: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)
35: THEN
36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ARITHMETIC_OPERATOR;
38: END IF;

Line 40: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,p_old_MODIFIERS_rec.attribute1)

36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ARITHMETIC_OPERATOR;
38: END IF;
39:
40: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,p_old_MODIFIERS_rec.attribute1)
41: THEN
42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE1;
44: END IF;

Line 46: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,p_old_MODIFIERS_rec.attribute10)

42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE1;
44: END IF;
45:
46: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,p_old_MODIFIERS_rec.attribute10)
47: THEN
48: l_index := l_index + 1;
49: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE10;
50: END IF;

Line 52: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,p_old_MODIFIERS_rec.attribute11)

48: l_index := l_index + 1;
49: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE10;
50: END IF;
51:
52: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,p_old_MODIFIERS_rec.attribute11)
53: THEN
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE11;
56: END IF;

Line 58: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,p_old_MODIFIERS_rec.attribute12)

54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE11;
56: END IF;
57:
58: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,p_old_MODIFIERS_rec.attribute12)
59: THEN
60: l_index := l_index + 1;
61: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE12;
62: END IF;

Line 64: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,p_old_MODIFIERS_rec.attribute13)

60: l_index := l_index + 1;
61: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE12;
62: END IF;
63:
64: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,p_old_MODIFIERS_rec.attribute13)
65: THEN
66: l_index := l_index + 1;
67: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE13;
68: END IF;

Line 70: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,p_old_MODIFIERS_rec.attribute14)

66: l_index := l_index + 1;
67: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE13;
68: END IF;
69:
70: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,p_old_MODIFIERS_rec.attribute14)
71: THEN
72: l_index := l_index + 1;
73: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE14;
74: END IF;

Line 76: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,p_old_MODIFIERS_rec.attribute15)

72: l_index := l_index + 1;
73: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE14;
74: END IF;
75:
76: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,p_old_MODIFIERS_rec.attribute15)
77: THEN
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE15;
80: END IF;

Line 82: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,p_old_MODIFIERS_rec.attribute2)

78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE15;
80: END IF;
81:
82: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,p_old_MODIFIERS_rec.attribute2)
83: THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE2;
86: END IF;

Line 88: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,p_old_MODIFIERS_rec.attribute3)

84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE2;
86: END IF;
87:
88: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,p_old_MODIFIERS_rec.attribute3)
89: THEN
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE3;
92: END IF;

Line 94: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,p_old_MODIFIERS_rec.attribute4)

90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE3;
92: END IF;
93:
94: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,p_old_MODIFIERS_rec.attribute4)
95: THEN
96: l_index := l_index + 1;
97: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE4;
98: END IF;

Line 100: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,p_old_MODIFIERS_rec.attribute5)

96: l_index := l_index + 1;
97: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE4;
98: END IF;
99:
100: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,p_old_MODIFIERS_rec.attribute5)
101: THEN
102: l_index := l_index + 1;
103: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE5;
104: END IF;

Line 106: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,p_old_MODIFIERS_rec.attribute6)

102: l_index := l_index + 1;
103: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE5;
104: END IF;
105:
106: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,p_old_MODIFIERS_rec.attribute6)
107: THEN
108: l_index := l_index + 1;
109: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE6;
110: END IF;

Line 112: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,p_old_MODIFIERS_rec.attribute7)

108: l_index := l_index + 1;
109: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE6;
110: END IF;
111:
112: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,p_old_MODIFIERS_rec.attribute7)
113: THEN
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE7;
116: END IF;

Line 118: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,p_old_MODIFIERS_rec.attribute8)

114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE7;
116: END IF;
117:
118: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,p_old_MODIFIERS_rec.attribute8)
119: THEN
120: l_index := l_index + 1;
121: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE8;
122: END IF;

Line 124: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,p_old_MODIFIERS_rec.attribute9)

120: l_index := l_index + 1;
121: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE8;
122: END IF;
123:
124: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,p_old_MODIFIERS_rec.attribute9)
125: THEN
126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE9;
128: END IF;

Line 130: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,p_old_MODIFIERS_rec.automatic_flag)

126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE9;
128: END IF;
129:
130: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,p_old_MODIFIERS_rec.automatic_flag)
131: THEN
132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_AUTOMATIC;
134: END IF;

Line 136: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,p_old_MODIFIERS_rec.base_qty)

132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_AUTOMATIC;
134: END IF;
135:
136: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,p_old_MODIFIERS_rec.base_qty)
137: THEN
138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_QTY;
140: END IF;

Line 142: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)

138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_QTY;
140: END IF;
141: */
142: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)
143: THEN
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_PHASE;
146: END IF;

Line 148: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,p_old_MODIFIERS_rec.base_uom_code)

144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_PHASE;
146: END IF;
147:
148: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,p_old_MODIFIERS_rec.base_uom_code)
149: THEN
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_UOM;
152: END IF;

Line 154: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.comments,p_old_MODIFIERS_rec.comments)

150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_UOM;
152: END IF;
153: */
154: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.comments,p_old_MODIFIERS_rec.comments)
155: THEN
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_COMMENTS;
158: END IF;

Line 160: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.context,p_old_MODIFIERS_rec.context)

156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_COMMENTS;
158: END IF;
159:
160: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.context,p_old_MODIFIERS_rec.context)
161: THEN
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CONTEXT;
164: END IF;

Line 166: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,p_old_MODIFIERS_rec.created_by)

162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CONTEXT;
164: END IF;
165:
166: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,p_old_MODIFIERS_rec.created_by)
167: THEN
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATED_BY;
170: END IF;

Line 172: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,p_old_MODIFIERS_rec.creation_date)

168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATED_BY;
170: END IF;
171:
172: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,p_old_MODIFIERS_rec.creation_date)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATION_DATE;
176: END IF;

Line 178: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,p_old_MODIFIERS_rec.effective_period_uom)

174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATION_DATE;
176: END IF;
177:
178: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,p_old_MODIFIERS_rec.effective_period_uom)
179: THEN
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EFFECTIVE_PERIOD_UOM;
182: END IF;

Line 184: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.end_date_active,p_old_MODIFIERS_rec.end_date_active)

180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EFFECTIVE_PERIOD_UOM;
182: END IF;
183:
184: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.end_date_active,p_old_MODIFIERS_rec.end_date_active)
185: THEN
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_END_DATE_ACTIVE;
188: END IF;

Line 190: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_accrual_rate,p_old_MODIFIERS_rec.estim_accrual_rate)

186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_END_DATE_ACTIVE;
188: END IF;
189:
190: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_accrual_rate,p_old_MODIFIERS_rec.estim_accrual_rate)
191: THEN
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_ACCRUAL_RATE;
194: END IF;

Line 196: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,p_old_MODIFIERS_rec.generate_using_formula_id)

192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_ACCRUAL_RATE;
194: END IF;
195:
196: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,p_old_MODIFIERS_rec.generate_using_formula_id)
197: THEN
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_GENERATE_USING_FORMULA;
200: END IF;

Line 202: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,p_old_MODIFIERS_rec.inventory_item_id)

198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_GENERATE_USING_FORMULA;
200: END IF;
201:
202: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,p_old_MODIFIERS_rec.inventory_item_id)
203: THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INVENTORY_ITEM;
206: END IF;

Line 208: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)

204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INVENTORY_ITEM;
206: END IF;
207:
208: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)
209: THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATED_BY;
212: END IF;

Line 214: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)

210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATED_BY;
212: END IF;
213:
214: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_DATE;
218: END IF;

Line 220: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)

216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_DATE;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
224: END IF;

Line 226: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)

222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
224: END IF;
225:
226: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
227: THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_HEADER;
230: END IF;

Line 232: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)

228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_HEADER;
230: END IF;
231:
232: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE;
236: END IF;

Line 238: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,p_old_MODIFIERS_rec.list_line_type_code)

234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE;
236: END IF;
237:
238: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,p_old_MODIFIERS_rec.list_line_type_code)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_TYPE;
242: END IF;

Line 244: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,p_old_MODIFIERS_rec.list_price)

240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_TYPE;
242: END IF;
243:
244: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,p_old_MODIFIERS_rec.list_price)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_PRICE;
248: END IF;

Line 250: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,p_old_MODIFIERS_rec.modifier_level_code)

246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_PRICE;
248: END IF;
249:
250: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,p_old_MODIFIERS_rec.modifier_level_code)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_MODIFIER_LEVEL;
254: END IF;

Line 256: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,p_old_MODIFIERS_rec.number_effective_periods)

252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_MODIFIER_LEVEL;
254: END IF;
255:
256: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,p_old_MODIFIERS_rec.number_effective_periods)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
260: END IF;

Line 262: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,p_old_MODIFIERS_rec.operand)

258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
260: END IF;
261:
262: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,p_old_MODIFIERS_rec.operand)
263: THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OPERAND;
266: END IF;

Line 268: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,p_old_MODIFIERS_rec.organization_id)

264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OPERAND;
266: END IF;
267:
268: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,p_old_MODIFIERS_rec.organization_id)
269: THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ORGANIZATION;
272: END IF;

Line 274: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,p_old_MODIFIERS_rec.override_flag)

270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ORGANIZATION;
272: END IF;
273:
274: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,p_old_MODIFIERS_rec.override_flag)
275: THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OVERRIDE;
278: END IF;

Line 280: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,p_old_MODIFIERS_rec.percent_price)

276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OVERRIDE;
278: END IF;
279:
280: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,p_old_MODIFIERS_rec.percent_price)
281: THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PERCENT_PRICE;
284: END IF;

Line 286: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,p_old_MODIFIERS_rec.price_break_type_code)

282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PERCENT_PRICE;
284: END IF;
285:
286: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,p_old_MODIFIERS_rec.price_break_type_code)
287: THEN
288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BREAK_TYPE;
290: END IF;

Line 292: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,p_old_MODIFIERS_rec.price_by_formula_id)

288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BREAK_TYPE;
290: END IF;
291:
292: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,p_old_MODIFIERS_rec.price_by_formula_id)
293: THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BY_FORMULA;
296: END IF;

Line 298: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,p_old_MODIFIERS_rec.primary_uom_flag)

294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BY_FORMULA;
296: END IF;
297:
298: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,p_old_MODIFIERS_rec.primary_uom_flag)
299: THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRIMARY_UOM;
302: END IF;

Line 304: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,p_old_MODIFIERS_rec.print_on_invoice_flag)

300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRIMARY_UOM;
302: END IF;
303:
304: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,p_old_MODIFIERS_rec.print_on_invoice_flag)
305: THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRINT_ON_INVOICE;
308: END IF;

Line 310: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,p_old_MODIFIERS_rec.program_application_id)

306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRINT_ON_INVOICE;
308: END IF;
309:
310: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,p_old_MODIFIERS_rec.program_application_id)
311: THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_APPLICATION;
314: END IF;

Line 316: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,p_old_MODIFIERS_rec.program_id)

312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_APPLICATION;
314: END IF;
315:
316: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,p_old_MODIFIERS_rec.program_id)
317: THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM;
320: END IF;

Line 322: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)

318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM;
320: END IF;
321:
322: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)
323: THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
326: END IF;

Line 328: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,p_old_MODIFIERS_rec.rebate_trxn_type_code)

324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
326: END IF;
327:
328: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,p_old_MODIFIERS_rec.rebate_trxn_type_code)
329: THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REBATE_TRANSACTION_TYPE;
332: END IF;

Line 334: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,p_old_MODIFIERS_rec.related_item_id)

330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REBATE_TRANSACTION_TYPE;
332: END IF;
333:
334: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,p_old_MODIFIERS_rec.related_item_id)
335: THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATED_ITEM;
338: END IF;

Line 340: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,p_old_MODIFIERS_rec.relationship_type_id)

336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATED_ITEM;
338: END IF;
339:
340: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,p_old_MODIFIERS_rec.relationship_type_id)
341: THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATIONSHIP_TYPE;
344: END IF;

Line 346: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,p_old_MODIFIERS_rec.reprice_flag)

342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATIONSHIP_TYPE;
344: END IF;
345:
346: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,p_old_MODIFIERS_rec.reprice_flag)
347: THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REPRICE;
350: END IF;

Line 352: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,p_old_MODIFIERS_rec.request_id)

348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REPRICE;
350: END IF;
351:
352: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,p_old_MODIFIERS_rec.request_id)
353: THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REQUEST;
356: END IF;

Line 358: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,p_old_MODIFIERS_rec.revision)

354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REQUEST;
356: END IF;
357:
358: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,p_old_MODIFIERS_rec.revision)
359: THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION;
362: END IF;

Line 364: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,p_old_MODIFIERS_rec.revision_date)

360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION;
362: END IF;
363:
364: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,p_old_MODIFIERS_rec.revision_date)
365: THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_DATE;
368: END IF;

Line 370: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,p_old_MODIFIERS_rec.revision_reason_code)

366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_DATE;
368: END IF;
369:
370: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,p_old_MODIFIERS_rec.revision_reason_code)
371: THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_REASON;
374: END IF;

Line 376: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.start_date_active,p_old_MODIFIERS_rec.start_date_active)

372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_REASON;
374: END IF;
375:
376: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.start_date_active,p_old_MODIFIERS_rec.start_date_active)
377: THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_START_DATE_ACTIVE;
380: END IF;

Line 382: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,p_old_MODIFIERS_rec.substitution_attribute)

378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_START_DATE_ACTIVE;
380: END IF;
381:
382: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,p_old_MODIFIERS_rec.substitution_attribute)
383: THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_ATTRIBUTE;
386: END IF;

Line 388: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,p_old_MODIFIERS_rec.substitution_context)

384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_ATTRIBUTE;
386: END IF;
387:
388: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,p_old_MODIFIERS_rec.substitution_context)
389: THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_CONTEXT;
392: END IF;

Line 394: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,p_old_MODIFIERS_rec.substitution_value)

390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_CONTEXT;
392: END IF;
393:
394: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,p_old_MODIFIERS_rec.substitution_value)
395: THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_VALUE;
398: END IF;

Line 400: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_flag,p_old_MODIFIERS_rec.accrual_flag)

396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_VALUE;
398: END IF;
399:
400: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_flag,p_old_MODIFIERS_rec.accrual_flag)
401: THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_FLAG;
404: END IF;

Line 406: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,p_old_MODIFIERS_rec.pricing_group_sequence)

402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_FLAG;
404: END IF;
405:
406: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,p_old_MODIFIERS_rec.pricing_group_sequence)
407: THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_GROUP_SEQUENCE;
410: END IF;

Line 412: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,p_old_MODIFIERS_rec.incompatibility_grp_code)

408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_GROUP_SEQUENCE;
410: END IF;
411:
412: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,p_old_MODIFIERS_rec.incompatibility_grp_code)
413: THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCOMPATIBILITY_GRP_CODE;
416: END IF;

Line 418: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,p_old_MODIFIERS_rec.list_line_no)

414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCOMPATIBILITY_GRP_CODE;
416: END IF;
417:
418: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,p_old_MODIFIERS_rec.list_line_no)
419: THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_NO;
422: END IF;

Line 424: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.product_precedence,p_old_MODIFIERS_rec.product_precedence)

420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_NO;
422: END IF;
423:
424: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.product_precedence,p_old_MODIFIERS_rec.product_precedence)
425: THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRODUCT_PRECEDENCE;
428: END IF;

Line 430: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,p_old_MODIFIERS_rec.expiration_period_start_date)

426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRODUCT_PRECEDENCE;
428: END IF;
429:
430: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,p_old_MODIFIERS_rec.expiration_period_start_date)
431: THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_START_DATE;
434: END IF;

Line 436: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,p_old_MODIFIERS_rec.number_expiration_periods)

432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_START_DATE;
434: END IF;
435:
436: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,p_old_MODIFIERS_rec.number_expiration_periods)
437: THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EXPIRATION_PERIODS;
440: END IF;

Line 442: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,p_old_MODIFIERS_rec.expiration_period_uom)

438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EXPIRATION_PERIODS;
440: END IF;
441:
442: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,p_old_MODIFIERS_rec.expiration_period_uom)
443: THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_UOM;
446: END IF;

Line 448: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,p_old_MODIFIERS_rec.expiration_date)

444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_UOM;
446: END IF;
447:
448: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,p_old_MODIFIERS_rec.expiration_date)
449: THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_DATE;
452: END IF;

Line 454: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,p_old_MODIFIERS_rec.estim_gl_value)

450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_DATE;
452: END IF;
453:
454: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,p_old_MODIFIERS_rec.estim_gl_value)
455: THEN
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_GL_VALUE;
458: END IF;

Line 460: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,p_old_MODIFIERS_rec.benefit_price_list_line_id)

456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_GL_VALUE;
458: END IF;
459:
460: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,p_old_MODIFIERS_rec.benefit_price_list_line_id)
461: THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_PRICE_LIST_LINE;
464: END IF;

Line 466: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,p_old_MODIFIERS_rec.recurring_flag)

462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_PRICE_LIST_LINE;
464: END IF;
465:
466: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,p_old_MODIFIERS_rec.recurring_flag)
467: THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RECURRING_FLAG;
470: END IF;

Line 472: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,p_old_MODIFIERS_rec.benefit_limit)

468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RECURRING_FLAG;
470: END IF;
471: */
472: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,p_old_MODIFIERS_rec.benefit_limit)
473: THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_LIMIT;
476: END IF;

Line 478: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,p_old_MODIFIERS_rec.charge_type_code)

474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_LIMIT;
476: END IF;
477:
478: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,p_old_MODIFIERS_rec.charge_type_code)
479: THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_TYPE;
482: END IF;

Line 484: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,p_old_MODIFIERS_rec.charge_subtype_code)

480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_TYPE;
482: END IF;
483:
484: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,p_old_MODIFIERS_rec.charge_subtype_code)
485: THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_SUBTYPE;
488: END IF;

Line 490: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,p_old_MODIFIERS_rec.benefit_qty)

486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_SUBTYPE;
488: END IF;
489:
490: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,p_old_MODIFIERS_rec.benefit_qty)
491: THEN
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_QTY;
494: END IF;

Line 496: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,p_old_MODIFIERS_rec.benefit_uom_code)

492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_QTY;
494: END IF;
495:
496: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,p_old_MODIFIERS_rec.benefit_uom_code)
497: THEN
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_UOM;
500: END IF;

Line 502: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,p_old_MODIFIERS_rec.accrual_conversion_rate)

498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_UOM;
500: END IF;
501:
502: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,p_old_MODIFIERS_rec.accrual_conversion_rate)
503: THEN
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_CONVERSION_RATE;
506: END IF;

Line 508: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,p_old_MODIFIERS_rec.proration_type_code)

504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_CONVERSION_RATE;
506: END IF;
507:
508: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,p_old_MODIFIERS_rec.proration_type_code)
509: THEN
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRORATION_TYPE;
512: END IF;

Line 514: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.include_on_returns_flag,p_old_MODIFIERS_rec.include_on_returns_flag)

510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRORATION_TYPE;
512: END IF;
513:
514: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.include_on_returns_flag,p_old_MODIFIERS_rec.include_on_returns_flag)
515: THEN
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCLUDE_ON_RETURNS_FLAG;
518: END IF;

Line 520: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.from_rltd_modifier_id,p_old_MODIFIERS_rec.from_rltd_modifier_id)

516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCLUDE_ON_RETURNS_FLAG;
518: END IF;
519:
520: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.from_rltd_modifier_id,p_old_MODIFIERS_rec.from_rltd_modifier_id)
521: THEN
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_FROM_RLTD_MODIFIER;
524: END IF;

Line 526: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.to_rltd_modifier_id,p_old_MODIFIERS_rec.to_rltd_modifier_id)

522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_FROM_RLTD_MODIFIER;
524: END IF;
525:
526: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.to_rltd_modifier_id,p_old_MODIFIERS_rec.to_rltd_modifier_id)
527: THEN
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_TO_RLTD_MODIFIER;
530: END IF;

Line 532: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_no,p_old_MODIFIERS_rec.rltd_modifier_grp_no)

528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_TO_RLTD_MODIFIER;
530: END IF;
531:
532: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_no,p_old_MODIFIERS_rec.rltd_modifier_grp_no)
533: THEN
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_NO;
536: END IF;

Line 538: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_type,p_old_MODIFIERS_rec.rltd_modifier_grp_type)

534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_NO;
536: END IF;
537:
538: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_type,p_old_MODIFIERS_rec.rltd_modifier_grp_type)
539: THEN
540: l_index := l_index + 1;
541: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_TYPE;
542: END IF;

Line 544: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_id,p_old_MODIFIERS_rec.rltd_modifier_id)

540: l_index := l_index + 1;
541: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_TYPE;
542: END IF;
543:
544: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_id,p_old_MODIFIERS_rec.rltd_modifier_id)
545: THEN
546: l_index := l_index + 1;
547: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_ID;
548: END IF;

Line 550: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.qualification_ind,p_old_MODIFIERS_rec.qualification_ind)

546: l_index := l_index + 1;
547: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_ID;
548: END IF;
549:
550: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.qualification_ind,p_old_MODIFIERS_rec.qualification_ind)
551: THEN
552: l_index := l_index + 1;
553: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_QUALIFICATION_IND;
554: END IF;

Line 556: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.net_amount_flag,p_old_MODIFIERS_rec.net_amount_flag)

552: l_index := l_index + 1;
553: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_QUALIFICATION_IND;
554: END IF;
555:
556: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.net_amount_flag,p_old_MODIFIERS_rec.net_amount_flag)
557: THEN
558: l_index := l_index + 1;
559: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NET_AMOUNT;
560: END IF;

Line 561: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accum_attribute,p_old_MODIFIERS_rec.accum_attribute)

557: THEN
558: l_index := l_index + 1;
559: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NET_AMOUNT;
560: END IF;
561: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accum_attribute,p_old_MODIFIERS_rec.accum_attribute)
562: THEN
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCUM_ATTRIBUTE;
565: END IF;

Line 567: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.continuous_price_break_flag,p_old_MODIFIERS_rec.continuous_price_break_flag)

563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCUM_ATTRIBUTE;
565: END IF;
566:
567: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.continuous_price_break_flag,p_old_MODIFIERS_rec.continuous_price_break_flag)
568: THEN
569: l_index := l_index + 1;
570: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CONTINUOUS_PRICE_BREAK_FLAG;
571: END IF;

Line 875: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)

871:
872: x_MODIFIERS_rec := p_MODIFIERS_rec;
873:
874: -- mkarya for bug 1874586, log the qualification indicator request before any other delayed requests
875: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
876: THEN
877: qp_delayed_requests_PVT.log_request(
878: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
879: p_entity_id => p_MODIFIERS_rec.list_line_id,

Line 878: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

874: -- mkarya for bug 1874586, log the qualification indicator request before any other delayed requests
875: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
876: THEN
877: qp_delayed_requests_PVT.log_request(
878: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
879: p_entity_id => p_MODIFIERS_rec.list_line_id,
880: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
881: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
882: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 880: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

876: THEN
877: qp_delayed_requests_PVT.log_request(
878: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
879: p_entity_id => p_MODIFIERS_rec.list_line_id,
880: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
881: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
882: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
883: x_return_status => l_return_status);
884: END IF;

Line 882: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

878: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
879: p_entity_id => p_MODIFIERS_rec.list_line_id,
880: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
881: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
882: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
883: x_return_status => l_return_status);
884: END IF;
885:
886: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)

Line 886: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)

882: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
883: x_return_status => l_return_status);
884: END IF;
885:
886: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)
887: THEN
888: NULL;
889: END IF;
890:

Line 891: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,p_old_MODIFIERS_rec.attribute1)

887: THEN
888: NULL;
889: END IF;
890:
891: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,p_old_MODIFIERS_rec.attribute1)
892: THEN
893: NULL;
894: END IF;
895:

Line 896: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,p_old_MODIFIERS_rec.attribute10)

892: THEN
893: NULL;
894: END IF;
895:
896: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,p_old_MODIFIERS_rec.attribute10)
897: THEN
898: NULL;
899: END IF;
900:

Line 901: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,p_old_MODIFIERS_rec.attribute11)

897: THEN
898: NULL;
899: END IF;
900:
901: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,p_old_MODIFIERS_rec.attribute11)
902: THEN
903: NULL;
904: END IF;
905:

Line 906: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,p_old_MODIFIERS_rec.attribute12)

902: THEN
903: NULL;
904: END IF;
905:
906: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,p_old_MODIFIERS_rec.attribute12)
907: THEN
908: NULL;
909: END IF;
910:

Line 911: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,p_old_MODIFIERS_rec.attribute13)

907: THEN
908: NULL;
909: END IF;
910:
911: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,p_old_MODIFIERS_rec.attribute13)
912: THEN
913: NULL;
914: END IF;
915:

Line 916: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,p_old_MODIFIERS_rec.attribute14)

912: THEN
913: NULL;
914: END IF;
915:
916: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,p_old_MODIFIERS_rec.attribute14)
917: THEN
918: NULL;
919: END IF;
920:

Line 921: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,p_old_MODIFIERS_rec.attribute15)

917: THEN
918: NULL;
919: END IF;
920:
921: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,p_old_MODIFIERS_rec.attribute15)
922: THEN
923: NULL;
924: END IF;
925:

Line 926: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,p_old_MODIFIERS_rec.attribute2)

922: THEN
923: NULL;
924: END IF;
925:
926: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,p_old_MODIFIERS_rec.attribute2)
927: THEN
928: NULL;
929: END IF;
930:

Line 931: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,p_old_MODIFIERS_rec.attribute3)

927: THEN
928: NULL;
929: END IF;
930:
931: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,p_old_MODIFIERS_rec.attribute3)
932: THEN
933: NULL;
934: END IF;
935:

Line 936: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,p_old_MODIFIERS_rec.attribute4)

932: THEN
933: NULL;
934: END IF;
935:
936: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,p_old_MODIFIERS_rec.attribute4)
937: THEN
938: NULL;
939: END IF;
940:

Line 941: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,p_old_MODIFIERS_rec.attribute5)

937: THEN
938: NULL;
939: END IF;
940:
941: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,p_old_MODIFIERS_rec.attribute5)
942: THEN
943: NULL;
944: END IF;
945:

Line 946: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,p_old_MODIFIERS_rec.attribute6)

942: THEN
943: NULL;
944: END IF;
945:
946: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,p_old_MODIFIERS_rec.attribute6)
947: THEN
948: NULL;
949: END IF;
950:

Line 951: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,p_old_MODIFIERS_rec.attribute7)

947: THEN
948: NULL;
949: END IF;
950:
951: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,p_old_MODIFIERS_rec.attribute7)
952: THEN
953: NULL;
954: END IF;
955:

Line 956: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,p_old_MODIFIERS_rec.attribute8)

952: THEN
953: NULL;
954: END IF;
955:
956: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,p_old_MODIFIERS_rec.attribute8)
957: THEN
958: NULL;
959: END IF;
960:

Line 961: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,p_old_MODIFIERS_rec.attribute9)

957: THEN
958: NULL;
959: END IF;
960:
961: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,p_old_MODIFIERS_rec.attribute9)
962: THEN
963: NULL;
964: END IF;
965:

Line 966: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,p_old_MODIFIERS_rec.automatic_flag)

962: THEN
963: NULL;
964: END IF;
965:
966: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,p_old_MODIFIERS_rec.automatic_flag)
967: THEN
968: NULL;
969: END IF;
970:

Line 971: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,p_old_MODIFIERS_rec.base_qty)

967: THEN
968: NULL;
969: END IF;
970:
971: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,p_old_MODIFIERS_rec.base_qty)
972: THEN
973: NULL;
974: END IF;
975: */

Line 976: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)

972: THEN
973: NULL;
974: END IF;
975: */
976: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)
977: THEN
978: NULL;
979: qp_delayed_requests_PVT.log_request(
980: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 980: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

976: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)
977: THEN
978: NULL;
979: qp_delayed_requests_PVT.log_request(
980: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
981: p_entity_id => p_MODIFIERS_rec.list_line_id,
982: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
983: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
984: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

Line 982: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

978: NULL;
979: qp_delayed_requests_PVT.log_request(
980: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
981: p_entity_id => p_MODIFIERS_rec.list_line_id,
982: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
983: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
984: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
985: x_return_status => l_return_status);
986:

Line 984: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

980: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
981: p_entity_id => p_MODIFIERS_rec.list_line_id,
982: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
983: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
984: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
985: x_return_status => l_return_status);
986:
987: qp_delayed_requests_PVT.log_request(
988: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 988: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

984: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
985: x_return_status => l_return_status);
986:
987: qp_delayed_requests_PVT.log_request(
988: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
989: p_entity_id => p_modifiers_rec.list_line_id,
990: p_param1 => p_modifiers_rec.list_header_id,
991: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
992: p_requesting_entity_id => p_modifiers_rec.list_line_id,

Line 991: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

987: qp_delayed_requests_PVT.log_request(
988: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
989: p_entity_id => p_modifiers_rec.list_line_id,
990: p_param1 => p_modifiers_rec.list_header_id,
991: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
992: p_requesting_entity_id => p_modifiers_rec.list_line_id,
993: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
994: x_return_status => l_return_status);
995:

Line 993: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,

989: p_entity_id => p_modifiers_rec.list_line_id,
990: p_param1 => p_modifiers_rec.list_header_id,
991: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
992: p_requesting_entity_id => p_modifiers_rec.list_line_id,
993: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
994: x_return_status => l_return_status);
995:
996: --hw
997: -- log the changed lines API delayed request for phase change;

Line 1000: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

996: --hw
997: -- log the changed lines API delayed request for phase change;
998: if QP_PERF_PVT.enabled = 'Y' then
999: qp_delayed_requests_pvt.log_request(
1000: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1001: p_entity_id => p_MODIFIERS_rec.list_line_id,
1002: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1003: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1004: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,

Line 1002: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

998: if QP_PERF_PVT.enabled = 'Y' then
999: qp_delayed_requests_pvt.log_request(
1000: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1001: p_entity_id => p_MODIFIERS_rec.list_line_id,
1002: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1003: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1004: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,
1005: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
1006: p_param2 => p_old_MODIFIERS_rec.pricing_phase_id,

Line 1004: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,

1000: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1001: p_entity_id => p_MODIFIERS_rec.list_line_id,
1002: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1003: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1004: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,
1005: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
1006: p_param2 => p_old_MODIFIERS_rec.pricing_phase_id,
1007: x_return_status => l_return_status);
1008: end if;

Line 1012: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,p_old_MODIFIERS_rec.base_uom_code)

1008: end if;
1009:
1010: END IF;
1011:
1012: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,p_old_MODIFIERS_rec.base_uom_code)
1013: THEN
1014: NULL;
1015: END IF;
1016: */

Line 1017: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.comments,p_old_MODIFIERS_rec.comments)

1013: THEN
1014: NULL;
1015: END IF;
1016: */
1017: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.comments,p_old_MODIFIERS_rec.comments)
1018: THEN
1019: NULL;
1020: END IF;
1021:

Line 1022: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.context,p_old_MODIFIERS_rec.context)

1018: THEN
1019: NULL;
1020: END IF;
1021:
1022: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.context,p_old_MODIFIERS_rec.context)
1023: THEN
1024: NULL;
1025: END IF;
1026:

Line 1027: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,p_old_MODIFIERS_rec.created_by)

1023: THEN
1024: NULL;
1025: END IF;
1026:
1027: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,p_old_MODIFIERS_rec.created_by)
1028: THEN
1029: NULL;
1030: END IF;
1031:

Line 1032: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,p_old_MODIFIERS_rec.creation_date)

1028: THEN
1029: NULL;
1030: END IF;
1031:
1032: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,p_old_MODIFIERS_rec.creation_date)
1033: THEN
1034: NULL;
1035: END IF;
1036:

Line 1037: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,p_old_MODIFIERS_rec.effective_period_uom)

1033: THEN
1034: NULL;
1035: END IF;
1036:
1037: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,p_old_MODIFIERS_rec.effective_period_uom)
1038: THEN
1039: NULL;
1040: END IF;
1041:

Line 1042: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.end_date_active,p_old_MODIFIERS_rec.end_date_active)

1038: THEN
1039: NULL;
1040: END IF;
1041:
1042: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.end_date_active,p_old_MODIFIERS_rec.end_date_active)
1043: THEN
1044: NULL;
1045: END IF;
1046:

Line 1047: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_accrual_rate,p_old_MODIFIERS_rec.estim_accrual_rate)

1043: THEN
1044: NULL;
1045: END IF;
1046:
1047: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_accrual_rate,p_old_MODIFIERS_rec.estim_accrual_rate)
1048: THEN
1049: NULL;
1050: END IF;
1051:

Line 1052: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,p_old_MODIFIERS_rec.generate_using_formula_id)

1048: THEN
1049: NULL;
1050: END IF;
1051:
1052: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,p_old_MODIFIERS_rec.generate_using_formula_id)
1053: THEN
1054: NULL;
1055: END IF;
1056:

Line 1057: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,p_old_MODIFIERS_rec.inventory_item_id)

1053: THEN
1054: NULL;
1055: END IF;
1056:
1057: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,p_old_MODIFIERS_rec.inventory_item_id)
1058: THEN
1059: NULL;
1060: END IF;
1061:

Line 1062: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)

1058: THEN
1059: NULL;
1060: END IF;
1061:
1062: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)
1063: THEN
1064: NULL;
1065: END IF;
1066:

Line 1067: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)

1063: THEN
1064: NULL;
1065: END IF;
1066:
1067: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)
1068: THEN
1069: NULL;
1070: END IF;
1071:

Line 1072: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)

1068: THEN
1069: NULL;
1070: END IF;
1071:
1072: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)
1073: THEN
1074: NULL;
1075: END IF;
1076:

Line 1079: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)

1075: END IF;
1076:
1077: --made changes by spgopal per rchellam's request
1078: --qualification_ind has to be updated in delayed request only once, this is duplication to avoid performance problem
1079: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
1080: THEN
1081: /*
1082: qp_delayed_requests_PVT.log_request(
1083: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

Line 1083: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

1079: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
1080: THEN
1081: /*
1082: qp_delayed_requests_PVT.log_request(
1083: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1084: p_entity_id => p_MODIFIERS_rec.list_header_id,
1085: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1086: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1087: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,

Line 1085: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

1081: /*
1082: qp_delayed_requests_PVT.log_request(
1083: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1084: p_entity_id => p_MODIFIERS_rec.list_header_id,
1085: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1086: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1087: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
1088: x_return_status => l_return_status);
1089: */

Line 1087: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,

1083: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1084: p_entity_id => p_MODIFIERS_rec.list_header_id,
1085: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1086: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1087: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
1088: x_return_status => l_return_status);
1089: */
1090: NULL;
1091: END IF;

Line 1094: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)

1090: NULL;
1091: END IF;
1092:
1093: /* mkarya for bug 1874586. Commenting out here and restoring the code at the begining of the procedure Apply_Attribute_Changes so that qualification_ind delayed requests are logged as first request
1094: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
1095: THEN
1096: qp_delayed_requests_PVT.log_request(
1097: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1098: p_entity_id => p_MODIFIERS_rec.list_line_id,

Line 1097: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

1093: /* mkarya for bug 1874586. Commenting out here and restoring the code at the begining of the procedure Apply_Attribute_Changes so that qualification_ind delayed requests are logged as first request
1094: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
1095: THEN
1096: qp_delayed_requests_PVT.log_request(
1097: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1098: p_entity_id => p_MODIFIERS_rec.list_line_id,
1099: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1100: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1101: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 1099: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

1095: THEN
1096: qp_delayed_requests_PVT.log_request(
1097: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1098: p_entity_id => p_MODIFIERS_rec.list_line_id,
1099: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1100: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1101: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1102: x_return_status => l_return_status);
1103: END IF;

Line 1101: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

1097: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1098: p_entity_id => p_MODIFIERS_rec.list_line_id,
1099: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1100: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1101: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1102: x_return_status => l_return_status);
1103: END IF;
1104: */
1105:

Line 1106: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,p_old_MODIFIERS_rec.list_line_type_code)

1102: x_return_status => l_return_status);
1103: END IF;
1104: */
1105:
1106: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,p_old_MODIFIERS_rec.list_line_type_code)
1107: THEN
1108: --added by svdeshmu
1109:
1110:

Line 1115: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

1111: --hvop
1112:
1113: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1114: qp_delayed_requests_PVT.log_request
1115: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1116: , p_entity_id => p_MODIFIERS_rec.list_line_id
1117: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1118: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1119: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id

Line 1118: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

1114: qp_delayed_requests_PVT.log_request
1115: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1116: , p_entity_id => p_MODIFIERS_rec.list_line_id
1117: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1118: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1119: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1120: , p_request_type =>QP_GLOBALS.G_UPDATE_HVOP
1121: , x_return_status => l_return_status
1122: );

Line 1120: , p_request_type =>QP_GLOBALS.G_UPDATE_HVOP

1116: , p_entity_id => p_MODIFIERS_rec.list_line_id
1117: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1118: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1119: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1120: , p_request_type =>QP_GLOBALS.G_UPDATE_HVOP
1121: , x_return_status => l_return_status
1122: );
1123: --hvop
1124: if p_MODIFIERS_rec.list_line_type_code in ('PBH' ,'OID' ,'PRG') then

Line 1128: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

1124: if p_MODIFIERS_rec.list_line_type_code in ('PBH' ,'OID' ,'PRG') then
1125:
1126: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1127: qp_delayed_requests_PVT.log_request
1128: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1129: , p_entity_id => p_MODIFIERS_rec.list_line_id
1130: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1131: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1132: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id

Line 1131: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

1127: qp_delayed_requests_PVT.log_request
1128: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1129: , p_entity_id => p_MODIFIERS_rec.list_line_id
1130: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1131: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1132: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1133: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1134: , x_return_status => l_return_status
1135: );

Line 1133: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD

1129: , p_entity_id => p_MODIFIERS_rec.list_line_id
1130: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1131: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1132: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1133: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1134: , x_return_status => l_return_status
1135: );
1136:
1137: else

Line 1140: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

1136:
1137: else
1138: -- Fix For Bug No - 5251238 This is a latent issue
1139: begin
1140: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1141: , p_entity_id => p_MODIFIERS_rec.list_line_id
1142: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1143: ) THEN
1144: QP_delayed_requests_pvt.Delete_Request

Line 1142: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD

1138: -- Fix For Bug No - 5251238 This is a latent issue
1139: begin
1140: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1141: , p_entity_id => p_MODIFIERS_rec.list_line_id
1142: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1143: ) THEN
1144: QP_delayed_requests_pvt.Delete_Request
1145: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1146: , p_entity_id => p_MODIFIERS_rec.list_line_id

Line 1145: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

1141: , p_entity_id => p_MODIFIERS_rec.list_line_id
1142: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1143: ) THEN
1144: QP_delayed_requests_pvt.Delete_Request
1145: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1146: , p_entity_id => p_MODIFIERS_rec.list_line_id
1147: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1148: , x_return_status => l_return_status
1149: );

Line 1147: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD

1143: ) THEN
1144: QP_delayed_requests_pvt.Delete_Request
1145: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1146: , p_entity_id => p_MODIFIERS_rec.list_line_id
1147: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1148: , x_return_status => l_return_status
1149: );
1150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1151: RAISE FND_API.G_EXC_ERROR;

Line 1163: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS

1159: if p_MODIFIERS_rec.list_line_type_code = 'PBH' then
1160:
1161: oe_debug_pub.add('calling log request for overlapping breaks QPXUMLL');
1162: qp_delayed_requests_PVT.log_request
1163: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1164: , p_entity_id => p_MODIFIERS_rec.list_line_id
1165: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1166: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1167: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS

Line 1165: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS

1161: oe_debug_pub.add('calling log request for overlapping breaks QPXUMLL');
1162: qp_delayed_requests_PVT.log_request
1163: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1164: , p_entity_id => p_MODIFIERS_rec.list_line_id
1165: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1166: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1167: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1168: , x_return_status => l_return_status
1169: );

Line 1167: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS

1163: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1164: , p_entity_id => p_MODIFIERS_rec.list_line_id
1165: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1166: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1167: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1168: , x_return_status => l_return_status
1169: );
1170:
1171: End If;

Line 1181: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,p_old_MODIFIERS_rec.list_price)

1177: NULL;
1178: END IF;
1179:
1180:
1181: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,p_old_MODIFIERS_rec.list_price)
1182: THEN
1183: NULL;
1184: END IF;
1185:

Line 1186: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,p_old_MODIFIERS_rec.modifier_level_code)

1182: THEN
1183: NULL;
1184: END IF;
1185:
1186: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,p_old_MODIFIERS_rec.modifier_level_code)
1187: THEN
1188: NULL;
1189: -- mkarya for attribute manager
1190: -- Log a delayed request to validate that if header level qualifier exist then at least

Line 1197: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1193: oe_debug_pub.add('Logging a request G_CHECK_LINE_FOR_HEADER_QUAL for modifier level change');
1194: -- Bug 2419504, log this request only if attribute manager is installed
1195: IF qp_util.attrmgr_installed = 'Y' then
1196: qp_delayed_requests_PVT.log_request(
1197: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1198: p_entity_id => p_MODIFIERS_rec.list_header_id,
1199: p_request_unique_key1 => -1,
1200: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1201: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,

Line 1200: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

1196: qp_delayed_requests_PVT.log_request(
1197: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1198: p_entity_id => p_MODIFIERS_rec.list_header_id,
1199: p_request_unique_key1 => -1,
1200: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1201: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1202: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
1203: x_return_status => l_return_status);
1204: END IF;

Line 1202: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,

1198: p_entity_id => p_MODIFIERS_rec.list_header_id,
1199: p_request_unique_key1 => -1,
1200: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1201: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1202: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
1203: x_return_status => l_return_status);
1204: END IF;
1205: END IF;
1206:

Line 1207: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,p_old_MODIFIERS_rec.number_effective_periods)

1203: x_return_status => l_return_status);
1204: END IF;
1205: END IF;
1206:
1207: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,p_old_MODIFIERS_rec.number_effective_periods)
1208: THEN
1209: NULL;
1210: END IF;
1211:

Line 1212: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,p_old_MODIFIERS_rec.operand)

1208: THEN
1209: NULL;
1210: END IF;
1211:
1212: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,p_old_MODIFIERS_rec.operand)
1213: THEN
1214: NULL;
1215: END IF;
1216:

Line 1217: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,p_old_MODIFIERS_rec.organization_id)

1213: THEN
1214: NULL;
1215: END IF;
1216:
1217: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,p_old_MODIFIERS_rec.organization_id)
1218: THEN
1219: NULL;
1220: END IF;
1221:

Line 1222: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,p_old_MODIFIERS_rec.override_flag)

1218: THEN
1219: NULL;
1220: END IF;
1221:
1222: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,p_old_MODIFIERS_rec.override_flag)
1223: THEN
1224: NULL;
1225: END IF;
1226:

Line 1227: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,p_old_MODIFIERS_rec.percent_price)

1223: THEN
1224: NULL;
1225: END IF;
1226:
1227: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,p_old_MODIFIERS_rec.percent_price)
1228: THEN
1229: NULL;
1230: END IF;
1231:

Line 1232: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,p_old_MODIFIERS_rec.price_break_type_code)

1228: THEN
1229: NULL;
1230: END IF;
1231:
1232: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,p_old_MODIFIERS_rec.price_break_type_code)
1233: THEN
1234: NULL;
1235: END IF;
1236:

Line 1237: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,p_old_MODIFIERS_rec.price_by_formula_id)

1233: THEN
1234: NULL;
1235: END IF;
1236:
1237: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,p_old_MODIFIERS_rec.price_by_formula_id)
1238: THEN
1239: NULL;
1240: END IF;
1241:

Line 1242: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,p_old_MODIFIERS_rec.primary_uom_flag)

1238: THEN
1239: NULL;
1240: END IF;
1241:
1242: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,p_old_MODIFIERS_rec.primary_uom_flag)
1243: THEN
1244: NULL;
1245: END IF;
1246:

Line 1247: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,p_old_MODIFIERS_rec.print_on_invoice_flag)

1243: THEN
1244: NULL;
1245: END IF;
1246:
1247: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,p_old_MODIFIERS_rec.print_on_invoice_flag)
1248: THEN
1249: NULL;
1250: END IF;
1251:

Line 1252: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,p_old_MODIFIERS_rec.program_application_id)

1248: THEN
1249: NULL;
1250: END IF;
1251:
1252: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,p_old_MODIFIERS_rec.program_application_id)
1253: THEN
1254: NULL;
1255: END IF;
1256:

Line 1257: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,p_old_MODIFIERS_rec.program_id)

1253: THEN
1254: NULL;
1255: END IF;
1256:
1257: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,p_old_MODIFIERS_rec.program_id)
1258: THEN
1259: NULL;
1260: END IF;
1261:

Line 1262: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)

1258: THEN
1259: NULL;
1260: END IF;
1261:
1262: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)
1263: THEN
1264: NULL;
1265: END IF;
1266:

Line 1267: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,p_old_MODIFIERS_rec.rebate_trxn_type_code)

1263: THEN
1264: NULL;
1265: END IF;
1266:
1267: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,p_old_MODIFIERS_rec.rebate_trxn_type_code)
1268: THEN
1269: NULL;
1270: END IF;
1271:

Line 1272: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,p_old_MODIFIERS_rec.related_item_id)

1268: THEN
1269: NULL;
1270: END IF;
1271:
1272: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,p_old_MODIFIERS_rec.related_item_id)
1273: THEN
1274: NULL;
1275: END IF;
1276:

Line 1277: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,p_old_MODIFIERS_rec.relationship_type_id)

1273: THEN
1274: NULL;
1275: END IF;
1276:
1277: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,p_old_MODIFIERS_rec.relationship_type_id)
1278: THEN
1279: NULL;
1280: END IF;
1281:

Line 1282: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,p_old_MODIFIERS_rec.reprice_flag)

1278: THEN
1279: NULL;
1280: END IF;
1281:
1282: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,p_old_MODIFIERS_rec.reprice_flag)
1283: THEN
1284: NULL;
1285: END IF;
1286:

Line 1287: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,p_old_MODIFIERS_rec.request_id)

1283: THEN
1284: NULL;
1285: END IF;
1286:
1287: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,p_old_MODIFIERS_rec.request_id)
1288: THEN
1289: NULL;
1290: END IF;
1291:

Line 1292: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,p_old_MODIFIERS_rec.revision)

1288: THEN
1289: NULL;
1290: END IF;
1291:
1292: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,p_old_MODIFIERS_rec.revision)
1293: THEN
1294: NULL;
1295: END IF;
1296:

Line 1297: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,p_old_MODIFIERS_rec.revision_date)

1293: THEN
1294: NULL;
1295: END IF;
1296:
1297: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,p_old_MODIFIERS_rec.revision_date)
1298: THEN
1299: NULL;
1300: END IF;
1301:

Line 1302: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,p_old_MODIFIERS_rec.revision_reason_code)

1298: THEN
1299: NULL;
1300: END IF;
1301:
1302: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,p_old_MODIFIERS_rec.revision_reason_code)
1303: THEN
1304: NULL;
1305: END IF;
1306:

Line 1307: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.start_date_active,p_old_MODIFIERS_rec.start_date_active)

1303: THEN
1304: NULL;
1305: END IF;
1306:
1307: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.start_date_active,p_old_MODIFIERS_rec.start_date_active)
1308: THEN
1309: NULL;
1310: END IF;
1311:

Line 1312: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,p_old_MODIFIERS_rec.substitution_attribute)

1308: THEN
1309: NULL;
1310: END IF;
1311:
1312: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,p_old_MODIFIERS_rec.substitution_attribute)
1313: THEN
1314: NULL;
1315: END IF;
1316:

Line 1317: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,p_old_MODIFIERS_rec.substitution_context)

1313: THEN
1314: NULL;
1315: END IF;
1316:
1317: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,p_old_MODIFIERS_rec.substitution_context)
1318: THEN
1319: NULL;
1320: END IF;
1321:

Line 1322: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,p_old_MODIFIERS_rec.substitution_value)

1318: THEN
1319: NULL;
1320: END IF;
1321:
1322: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,p_old_MODIFIERS_rec.substitution_value)
1323: THEN
1324: NULL;
1325: END IF;
1326:

Line 1327: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_flag,p_old_MODIFIERS_rec.accrual_flag)

1323: THEN
1324: NULL;
1325: END IF;
1326:
1327: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_flag,p_old_MODIFIERS_rec.accrual_flag)
1328: THEN
1329: NULL;
1330: END IF;
1331:

Line 1332: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,p_old_MODIFIERS_rec.pricing_group_sequence)

1328: THEN
1329: NULL;
1330: END IF;
1331:
1332: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,p_old_MODIFIERS_rec.pricing_group_sequence)
1333: THEN
1334: NULL;
1335: END IF;
1336:

Line 1337: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,p_old_MODIFIERS_rec.incompatibility_grp_code)

1333: THEN
1334: NULL;
1335: END IF;
1336:
1337: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,p_old_MODIFIERS_rec.incompatibility_grp_code)
1338: THEN
1339: NULL;
1340: END IF;
1341:

Line 1342: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,p_old_MODIFIERS_rec.list_line_no)

1338: THEN
1339: NULL;
1340: END IF;
1341:
1342: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,p_old_MODIFIERS_rec.list_line_no)
1343: THEN
1344: NULL;
1345: END IF;
1346:

Line 1347: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.product_precedence,p_old_MODIFIERS_rec.product_precedence)

1343: THEN
1344: NULL;
1345: END IF;
1346:
1347: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.product_precedence,p_old_MODIFIERS_rec.product_precedence)
1348: THEN
1349: -- bug 3703391 - update effective_precedence in qp_attribute_groups when no product is given but line qualifier given
1350: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1351: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN

Line 1353: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1349: -- bug 3703391 - update effective_precedence in qp_attribute_groups when no product is given but line qualifier given
1350: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1351: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
1352: qp_delayed_requests_pvt.log_request(
1353: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1354: p_entity_id => p_MODIFIERS_rec.list_header_id,
1355: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1356: p_request_unique_key2 => 'U',
1357: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 1357: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1353: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1354: p_entity_id => p_MODIFIERS_rec.list_header_id,
1355: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1356: p_request_unique_key2 => 'U',
1357: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1358: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1359: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1360: x_return_status => l_return_status);
1361: END IF;

Line 1359: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

1355: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1356: p_request_unique_key2 => 'U',
1357: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1358: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1359: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1360: x_return_status => l_return_status);
1361: END IF;
1362: END IF;
1363: NULL;

Line 1366: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,p_old_MODIFIERS_rec.expiration_period_start_date)

1362: END IF;
1363: NULL;
1364: END IF;
1365:
1366: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,p_old_MODIFIERS_rec.expiration_period_start_date)
1367: THEN
1368: NULL;
1369: END IF;
1370:

Line 1371: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,p_old_MODIFIERS_rec.number_expiration_periods)

1367: THEN
1368: NULL;
1369: END IF;
1370:
1371: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,p_old_MODIFIERS_rec.number_expiration_periods)
1372: THEN
1373: NULL;
1374: END IF;
1375:

Line 1376: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,p_old_MODIFIERS_rec.expiration_period_uom)

1372: THEN
1373: NULL;
1374: END IF;
1375:
1376: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,p_old_MODIFIERS_rec.expiration_period_uom)
1377: THEN
1378: NULL;
1379: END IF;
1380:

Line 1381: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,p_old_MODIFIERS_rec.expiration_date)

1377: THEN
1378: NULL;
1379: END IF;
1380:
1381: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,p_old_MODIFIERS_rec.expiration_date)
1382: THEN
1383: NULL;
1384: END IF;
1385:

Line 1386: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,p_old_MODIFIERS_rec.estim_gl_value)

1382: THEN
1383: NULL;
1384: END IF;
1385:
1386: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,p_old_MODIFIERS_rec.estim_gl_value)
1387: THEN
1388: NULL;
1389: END IF;
1390:

Line 1391: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,p_old_MODIFIERS_rec.benefit_price_list_line_id)

1387: THEN
1388: NULL;
1389: END IF;
1390:
1391: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,p_old_MODIFIERS_rec.benefit_price_list_line_id)
1392: THEN
1393: NULL;
1394: END IF;
1395:

Line 1396: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,p_old_MODIFIERS_rec.recurring_flag)

1392: THEN
1393: NULL;
1394: END IF;
1395:
1396: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,p_old_MODIFIERS_rec.recurring_flag)
1397: THEN
1398: NULL;
1399: END IF;
1400: */

Line 1401: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,p_old_MODIFIERS_rec.benefit_limit)

1397: THEN
1398: NULL;
1399: END IF;
1400: */
1401: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,p_old_MODIFIERS_rec.benefit_limit)
1402: THEN
1403: NULL;
1404: END IF;
1405:

Line 1406: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,p_old_MODIFIERS_rec.charge_type_code)

1402: THEN
1403: NULL;
1404: END IF;
1405:
1406: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,p_old_MODIFIERS_rec.charge_type_code)
1407: THEN
1408: NULL;
1409: END IF;
1410:

Line 1411: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,p_old_MODIFIERS_rec.charge_subtype_code)

1407: THEN
1408: NULL;
1409: END IF;
1410:
1411: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,p_old_MODIFIERS_rec.charge_subtype_code)
1412: THEN
1413: NULL;
1414: END IF;
1415:

Line 1416: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,p_old_MODIFIERS_rec.benefit_qty)

1412: THEN
1413: NULL;
1414: END IF;
1415:
1416: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,p_old_MODIFIERS_rec.benefit_qty)
1417: THEN
1418: NULL;
1419: END IF;
1420:

Line 1421: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,p_old_MODIFIERS_rec.benefit_uom_code)

1417: THEN
1418: NULL;
1419: END IF;
1420:
1421: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,p_old_MODIFIERS_rec.benefit_uom_code)
1422: THEN
1423: NULL;
1424: END IF;
1425:

Line 1426: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,p_old_MODIFIERS_rec.accrual_conversion_rate)

1422: THEN
1423: NULL;
1424: END IF;
1425:
1426: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,p_old_MODIFIERS_rec.accrual_conversion_rate)
1427: THEN
1428: NULL;
1429: END IF;
1430:

Line 1431: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,p_old_MODIFIERS_rec.proration_type_code)

1427: THEN
1428: NULL;
1429: END IF;
1430:
1431: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,p_old_MODIFIERS_rec.proration_type_code)
1432: THEN
1433: NULL;
1434: END IF;
1435:

Line 1436: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.include_on_returns_flag,p_old_MODIFIERS_rec.include_on_returns_flag)

1432: THEN
1433: NULL;
1434: END IF;
1435:
1436: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.include_on_returns_flag,p_old_MODIFIERS_rec.include_on_returns_flag)
1437: THEN
1438: NULL;
1439: END IF;
1440:

Line 1441: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.from_rltd_modifier_id,p_old_MODIFIERS_rec.from_rltd_modifier_id)

1437: THEN
1438: NULL;
1439: END IF;
1440:
1441: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.from_rltd_modifier_id,p_old_MODIFIERS_rec.from_rltd_modifier_id)
1442: THEN
1443: NULL;
1444: END IF;
1445:

Line 1446: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.to_rltd_modifier_id,p_old_MODIFIERS_rec.to_rltd_modifier_id)

1442: THEN
1443: NULL;
1444: END IF;
1445:
1446: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.to_rltd_modifier_id,p_old_MODIFIERS_rec.to_rltd_modifier_id)
1447: THEN
1448: NULL;
1449: END IF;
1450:

Line 1451: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_no,p_old_MODIFIERS_rec.rltd_modifier_grp_no)

1447: THEN
1448: NULL;
1449: END IF;
1450:
1451: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_no,p_old_MODIFIERS_rec.rltd_modifier_grp_no)
1452: THEN
1453: NULL;
1454: END IF;
1455:

Line 1456: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_type,p_old_MODIFIERS_rec.rltd_modifier_grp_type)

1452: THEN
1453: NULL;
1454: END IF;
1455:
1456: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_type,p_old_MODIFIERS_rec.rltd_modifier_grp_type)
1457: THEN
1458: NULL;
1459: END IF;
1460:

Line 1461: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_id,p_old_MODIFIERS_rec.rltd_modifier_id)

1457: THEN
1458: NULL;
1459: END IF;
1460:
1461: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_id,p_old_MODIFIERS_rec.rltd_modifier_id)
1462: THEN
1463: NULL;
1464: END IF;
1465:

Line 1466: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accum_attribute,p_old_MODIFIERS_rec.accum_attribute)

1462: THEN
1463: NULL;
1464: END IF;
1465:
1466: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accum_attribute,p_old_MODIFIERS_rec.accum_attribute)
1467: THEN
1468: NULL;
1469: END IF;
1470:

Line 1471: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.continuous_price_break_flag,p_old_MODIFIERS_rec.continuous_price_break_flag)

1467: THEN
1468: NULL;
1469: END IF;
1470:
1471: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.continuous_price_break_flag,p_old_MODIFIERS_rec.continuous_price_break_flag)
1472: THEN
1473: NULL;
1474: END IF;
1475:

Line 3608: QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,

3604:
3605: -- Row locked. Compare IN attributes to DB attributes.
3606:
3607: IF
3608: QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,
3609: l_MODIFIERS_rec.arithmetic_operator)
3610:
3611: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3612: l_MODIFIERS_rec.attribute1)

Line 3611: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,

3607: IF
3608: QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,
3609: l_MODIFIERS_rec.arithmetic_operator)
3610:
3611: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3612: l_MODIFIERS_rec.attribute1)
3613: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3614: l_MODIFIERS_rec.attribute10)
3615: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,

Line 3613: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,

3609: l_MODIFIERS_rec.arithmetic_operator)
3610:
3611: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3612: l_MODIFIERS_rec.attribute1)
3613: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3614: l_MODIFIERS_rec.attribute10)
3615: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3616: l_MODIFIERS_rec.attribute11)
3617: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,

Line 3615: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,

3611: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3612: l_MODIFIERS_rec.attribute1)
3613: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3614: l_MODIFIERS_rec.attribute10)
3615: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3616: l_MODIFIERS_rec.attribute11)
3617: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3618: l_MODIFIERS_rec.attribute12)
3619: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,

Line 3617: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,

3613: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3614: l_MODIFIERS_rec.attribute10)
3615: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3616: l_MODIFIERS_rec.attribute11)
3617: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3618: l_MODIFIERS_rec.attribute12)
3619: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3620: l_MODIFIERS_rec.attribute13)
3621: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,

Line 3619: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,

3615: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3616: l_MODIFIERS_rec.attribute11)
3617: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3618: l_MODIFIERS_rec.attribute12)
3619: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3620: l_MODIFIERS_rec.attribute13)
3621: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3622: l_MODIFIERS_rec.attribute14)
3623: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,

Line 3621: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,

3617: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3618: l_MODIFIERS_rec.attribute12)
3619: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3620: l_MODIFIERS_rec.attribute13)
3621: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3622: l_MODIFIERS_rec.attribute14)
3623: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3624: l_MODIFIERS_rec.attribute15)
3625: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,

Line 3623: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,

3619: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3620: l_MODIFIERS_rec.attribute13)
3621: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3622: l_MODIFIERS_rec.attribute14)
3623: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3624: l_MODIFIERS_rec.attribute15)
3625: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3626: l_MODIFIERS_rec.attribute2)
3627: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,

Line 3625: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,

3621: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3622: l_MODIFIERS_rec.attribute14)
3623: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3624: l_MODIFIERS_rec.attribute15)
3625: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3626: l_MODIFIERS_rec.attribute2)
3627: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3628: l_MODIFIERS_rec.attribute3)
3629: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,

Line 3627: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,

3623: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3624: l_MODIFIERS_rec.attribute15)
3625: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3626: l_MODIFIERS_rec.attribute2)
3627: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3628: l_MODIFIERS_rec.attribute3)
3629: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3630: l_MODIFIERS_rec.attribute4)
3631: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,

Line 3629: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,

3625: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3626: l_MODIFIERS_rec.attribute2)
3627: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3628: l_MODIFIERS_rec.attribute3)
3629: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3630: l_MODIFIERS_rec.attribute4)
3631: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3632: l_MODIFIERS_rec.attribute5)
3633: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,

Line 3631: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,

3627: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3628: l_MODIFIERS_rec.attribute3)
3629: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3630: l_MODIFIERS_rec.attribute4)
3631: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3632: l_MODIFIERS_rec.attribute5)
3633: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3634: l_MODIFIERS_rec.attribute6)
3635: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,

Line 3633: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,

3629: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3630: l_MODIFIERS_rec.attribute4)
3631: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3632: l_MODIFIERS_rec.attribute5)
3633: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3634: l_MODIFIERS_rec.attribute6)
3635: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3636: l_MODIFIERS_rec.attribute7)
3637: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,

Line 3635: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,

3631: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3632: l_MODIFIERS_rec.attribute5)
3633: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3634: l_MODIFIERS_rec.attribute6)
3635: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3636: l_MODIFIERS_rec.attribute7)
3637: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,
3638: l_MODIFIERS_rec.attribute8)
3639: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,

Line 3637: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,

3633: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3634: l_MODIFIERS_rec.attribute6)
3635: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3636: l_MODIFIERS_rec.attribute7)
3637: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,
3638: l_MODIFIERS_rec.attribute8)
3639: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,
3640: l_MODIFIERS_rec.attribute9)
3641:

Line 3639: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,

3635: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3636: l_MODIFIERS_rec.attribute7)
3637: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,
3638: l_MODIFIERS_rec.attribute8)
3639: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,
3640: l_MODIFIERS_rec.attribute9)
3641:
3642: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3643: l_MODIFIERS_rec.automatic_flag)

Line 3642: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,

3638: l_MODIFIERS_rec.attribute8)
3639: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,
3640: l_MODIFIERS_rec.attribute9)
3641:
3642: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3643: l_MODIFIERS_rec.automatic_flag)
3644: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,
3645: -- l_MODIFIERS_rec.base_qty)
3646: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,

Line 3644: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,

3640: l_MODIFIERS_rec.attribute9)
3641:
3642: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3643: l_MODIFIERS_rec.automatic_flag)
3644: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,
3645: -- l_MODIFIERS_rec.base_qty)
3646: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,
3647: l_MODIFIERS_rec.pricing_phase_id)
3648:

Line 3646: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,

3642: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3643: l_MODIFIERS_rec.automatic_flag)
3644: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,
3645: -- l_MODIFIERS_rec.base_qty)
3646: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,
3647: l_MODIFIERS_rec.pricing_phase_id)
3648:
3649: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3650: -- l_MODIFIERS_rec.base_uom_code)

Line 3649: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,

3645: -- l_MODIFIERS_rec.base_qty)
3646: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,
3647: l_MODIFIERS_rec.pricing_phase_id)
3648:
3649: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3650: -- l_MODIFIERS_rec.base_uom_code)
3651: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3652: l_MODIFIERS_rec.comments) --bug 7321894
3653: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,

Line 3651: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),

3647: l_MODIFIERS_rec.pricing_phase_id)
3648:
3649: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3650: -- l_MODIFIERS_rec.base_uom_code)
3651: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3652: l_MODIFIERS_rec.comments) --bug 7321894
3653: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3654: l_MODIFIERS_rec.context)
3655: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,

Line 3653: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,

3649: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3650: -- l_MODIFIERS_rec.base_uom_code)
3651: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3652: l_MODIFIERS_rec.comments) --bug 7321894
3653: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3654: l_MODIFIERS_rec.context)
3655: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3656: -- l_MODIFIERS_rec.created_by)
3657: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,

Line 3655: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,

3651: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3652: l_MODIFIERS_rec.comments) --bug 7321894
3653: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3654: l_MODIFIERS_rec.context)
3655: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3656: -- l_MODIFIERS_rec.created_by)
3657: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3658: -- l_MODIFIERS_rec.creation_date)
3659: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,

Line 3657: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,

3653: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3654: l_MODIFIERS_rec.context)
3655: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3656: -- l_MODIFIERS_rec.created_by)
3657: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3658: -- l_MODIFIERS_rec.creation_date)
3659: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3660: l_MODIFIERS_rec.effective_period_uom)
3661: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

Line 3659: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,

3655: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3656: -- l_MODIFIERS_rec.created_by)
3657: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3658: -- l_MODIFIERS_rec.creation_date)
3659: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3660: l_MODIFIERS_rec.effective_period_uom)
3661: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3662: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3663: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),

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

3657: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3658: -- l_MODIFIERS_rec.creation_date)
3659: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3660: l_MODIFIERS_rec.effective_period_uom)
3661: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3662: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3663: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3664: l_MODIFIERS_rec.estim_accrual_rate)
3665: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,

Line 3663: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),

3659: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3660: l_MODIFIERS_rec.effective_period_uom)
3661: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3662: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3663: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3664: l_MODIFIERS_rec.estim_accrual_rate)
3665: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3666: l_MODIFIERS_rec.generate_using_formula_id)
3667: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,

Line 3665: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,

3661: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3662: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3663: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3664: l_MODIFIERS_rec.estim_accrual_rate)
3665: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3666: l_MODIFIERS_rec.generate_using_formula_id)
3667: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3668: l_MODIFIERS_rec.inventory_item_id)
3669: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,

Line 3667: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,

3663: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3664: l_MODIFIERS_rec.estim_accrual_rate)
3665: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3666: l_MODIFIERS_rec.generate_using_formula_id)
3667: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3668: l_MODIFIERS_rec.inventory_item_id)
3669: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3670: -- l_MODIFIERS_rec.last_updated_by)
3671: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,

Line 3669: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,

3665: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3666: l_MODIFIERS_rec.generate_using_formula_id)
3667: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3668: l_MODIFIERS_rec.inventory_item_id)
3669: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3670: -- l_MODIFIERS_rec.last_updated_by)
3671: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,
3672: -- l_MODIFIERS_rec.last_update_date)
3673: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,

Line 3671: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,

3667: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3668: l_MODIFIERS_rec.inventory_item_id)
3669: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3670: -- l_MODIFIERS_rec.last_updated_by)
3671: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,
3672: -- l_MODIFIERS_rec.last_update_date)
3673: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,
3674: -- l_MODIFIERS_rec.last_update_login)
3675:

Line 3673: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,

3669: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3670: -- l_MODIFIERS_rec.last_updated_by)
3671: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,
3672: -- l_MODIFIERS_rec.last_update_date)
3673: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,
3674: -- l_MODIFIERS_rec.last_update_login)
3675:
3676: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3677: l_MODIFIERS_rec.list_header_id)

Line 3676: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),

3672: -- l_MODIFIERS_rec.last_update_date)
3673: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,
3674: -- l_MODIFIERS_rec.last_update_login)
3675:
3676: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3677: l_MODIFIERS_rec.list_header_id)
3678: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3679: l_MODIFIERS_rec.list_line_id)
3680: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,

Line 3678: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,

3674: -- l_MODIFIERS_rec.last_update_login)
3675:
3676: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3677: l_MODIFIERS_rec.list_header_id)
3678: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3679: l_MODIFIERS_rec.list_line_id)
3680: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3681: l_MODIFIERS_rec.list_line_type_code)
3682: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,

Line 3680: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,

3676: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3677: l_MODIFIERS_rec.list_header_id)
3678: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3679: l_MODIFIERS_rec.list_line_id)
3680: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3681: l_MODIFIERS_rec.list_line_type_code)
3682: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,
3683: -- l_MODIFIERS_rec.list_price)
3684: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,

Line 3682: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,

3678: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3679: l_MODIFIERS_rec.list_line_id)
3680: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3681: l_MODIFIERS_rec.list_line_type_code)
3682: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,
3683: -- l_MODIFIERS_rec.list_price)
3684: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3685: l_MODIFIERS_rec.modifier_level_code)
3686:

Line 3684: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,

3680: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3681: l_MODIFIERS_rec.list_line_type_code)
3682: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,
3683: -- l_MODIFIERS_rec.list_price)
3684: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3685: l_MODIFIERS_rec.modifier_level_code)
3686:
3687: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,
3688: l_MODIFIERS_rec.number_effective_periods)

Line 3687: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,

3683: -- l_MODIFIERS_rec.list_price)
3684: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3685: l_MODIFIERS_rec.modifier_level_code)
3686:
3687: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,
3688: l_MODIFIERS_rec.number_effective_periods)
3689:
3690: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,
3691: l_MODIFIERS_rec.operand)

Line 3690: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,

3686:
3687: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,
3688: l_MODIFIERS_rec.number_effective_periods)
3689:
3690: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,
3691: l_MODIFIERS_rec.operand)
3692:
3693: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3694: l_MODIFIERS_rec.organization_id)

Line 3693: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,

3689:
3690: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,
3691: l_MODIFIERS_rec.operand)
3692:
3693: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3694: l_MODIFIERS_rec.organization_id)
3695: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3696: l_MODIFIERS_rec.override_flag)
3697: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,

Line 3695: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,

3691: l_MODIFIERS_rec.operand)
3692:
3693: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3694: l_MODIFIERS_rec.organization_id)
3695: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3696: l_MODIFIERS_rec.override_flag)
3697: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3698: l_MODIFIERS_rec.percent_price)
3699: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,

Line 3697: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,

3693: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3694: l_MODIFIERS_rec.organization_id)
3695: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3696: l_MODIFIERS_rec.override_flag)
3697: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3698: l_MODIFIERS_rec.percent_price)
3699: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3700: l_MODIFIERS_rec.price_break_type_code)
3701: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,

Line 3699: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,

3695: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3696: l_MODIFIERS_rec.override_flag)
3697: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3698: l_MODIFIERS_rec.percent_price)
3699: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3700: l_MODIFIERS_rec.price_break_type_code)
3701: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3702: l_MODIFIERS_rec.price_by_formula_id)
3703: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),

Line 3701: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,

3697: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3698: l_MODIFIERS_rec.percent_price)
3699: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3700: l_MODIFIERS_rec.price_break_type_code)
3701: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3702: l_MODIFIERS_rec.price_by_formula_id)
3703: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3704: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3705: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,

Line 3703: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),

3699: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3700: l_MODIFIERS_rec.price_break_type_code)
3701: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3702: l_MODIFIERS_rec.price_by_formula_id)
3703: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3704: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3705: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
3706: l_MODIFIERS_rec.print_on_invoice_flag)
3707: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,

Line 3705: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,

3701: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3702: l_MODIFIERS_rec.price_by_formula_id)
3703: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3704: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3705: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
3706: l_MODIFIERS_rec.print_on_invoice_flag)
3707: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3708: -- l_MODIFIERS_rec.program_application_id)
3709: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,

Line 3707: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,

3703: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3704: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3705: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
3706: l_MODIFIERS_rec.print_on_invoice_flag)
3707: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3708: -- l_MODIFIERS_rec.program_application_id)
3709: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3710: -- l_MODIFIERS_rec.program_id)
3711: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,

Line 3709: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,

3705: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
3706: l_MODIFIERS_rec.print_on_invoice_flag)
3707: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3708: -- l_MODIFIERS_rec.program_application_id)
3709: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3710: -- l_MODIFIERS_rec.program_id)
3711: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3712: -- l_MODIFIERS_rec.program_update_date)
3713: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,

Line 3711: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,

3707: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3708: -- l_MODIFIERS_rec.program_application_id)
3709: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3710: -- l_MODIFIERS_rec.program_id)
3711: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3712: -- l_MODIFIERS_rec.program_update_date)
3713: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3714: l_MODIFIERS_rec.rebate_trxn_type_code)
3715: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,

Line 3713: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,

3709: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3710: -- l_MODIFIERS_rec.program_id)
3711: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3712: -- l_MODIFIERS_rec.program_update_date)
3713: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3714: l_MODIFIERS_rec.rebate_trxn_type_code)
3715: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3716: l_MODIFIERS_rec.related_item_id)
3717: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,

Line 3715: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,

3711: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3712: -- l_MODIFIERS_rec.program_update_date)
3713: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3714: l_MODIFIERS_rec.rebate_trxn_type_code)
3715: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3716: l_MODIFIERS_rec.related_item_id)
3717: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3718: l_MODIFIERS_rec.relationship_type_id)
3719: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,

Line 3717: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,

3713: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3714: l_MODIFIERS_rec.rebate_trxn_type_code)
3715: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3716: l_MODIFIERS_rec.related_item_id)
3717: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3718: l_MODIFIERS_rec.relationship_type_id)
3719: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3720: l_MODIFIERS_rec.reprice_flag)
3721: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,

Line 3719: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,

3715: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3716: l_MODIFIERS_rec.related_item_id)
3717: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3718: l_MODIFIERS_rec.relationship_type_id)
3719: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3720: l_MODIFIERS_rec.reprice_flag)
3721: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3722: -- l_MODIFIERS_rec.request_id)
3723: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,

Line 3721: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,

3717: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3718: l_MODIFIERS_rec.relationship_type_id)
3719: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3720: l_MODIFIERS_rec.reprice_flag)
3721: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3722: -- l_MODIFIERS_rec.request_id)
3723: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3724: l_MODIFIERS_rec.revision)
3725: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,

Line 3723: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,

3719: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3720: l_MODIFIERS_rec.reprice_flag)
3721: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3722: -- l_MODIFIERS_rec.request_id)
3723: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3724: l_MODIFIERS_rec.revision)
3725: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3726: l_MODIFIERS_rec.revision_date)
3727: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,

Line 3725: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,

3721: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3722: -- l_MODIFIERS_rec.request_id)
3723: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3724: l_MODIFIERS_rec.revision)
3725: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3726: l_MODIFIERS_rec.revision_date)
3727: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3728: l_MODIFIERS_rec.revision_reason_code)
3729: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

Line 3727: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,

3723: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3724: l_MODIFIERS_rec.revision)
3725: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3726: l_MODIFIERS_rec.revision_date)
3727: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3728: l_MODIFIERS_rec.revision_reason_code)
3729: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3730: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3731: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,

Line 3729: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),

3725: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3726: l_MODIFIERS_rec.revision_date)
3727: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3728: l_MODIFIERS_rec.revision_reason_code)
3729: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3730: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3731: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3732: l_MODIFIERS_rec.substitution_attribute)
3733: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,

Line 3731: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,

3727: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3728: l_MODIFIERS_rec.revision_reason_code)
3729: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3730: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3731: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3732: l_MODIFIERS_rec.substitution_attribute)
3733: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,
3734: l_MODIFIERS_rec.substitution_context)
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,

Line 3733: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,

3729: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3730: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3731: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3732: l_MODIFIERS_rec.substitution_attribute)
3733: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,
3734: l_MODIFIERS_rec.substitution_context)
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,
3736: l_MODIFIERS_rec.substitution_value)
3737:

Line 3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,

3731: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3732: l_MODIFIERS_rec.substitution_attribute)
3733: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,
3734: l_MODIFIERS_rec.substitution_context)
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,
3736: l_MODIFIERS_rec.substitution_value)
3737:
3738: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3739: l_MODIFIERS_rec.accrual_flag)

Line 3738: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),

3734: l_MODIFIERS_rec.substitution_context)
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,
3736: l_MODIFIERS_rec.substitution_value)
3737:
3738: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3739: l_MODIFIERS_rec.accrual_flag)
3740: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3741: l_MODIFIERS_rec.pricing_group_sequence)
3742: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,

Line 3740: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,

3736: l_MODIFIERS_rec.substitution_value)
3737:
3738: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3739: l_MODIFIERS_rec.accrual_flag)
3740: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3741: l_MODIFIERS_rec.pricing_group_sequence)
3742: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3743: l_MODIFIERS_rec.incompatibility_grp_code)
3744: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,

Line 3742: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,

3738: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3739: l_MODIFIERS_rec.accrual_flag)
3740: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3741: l_MODIFIERS_rec.pricing_group_sequence)
3742: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3743: l_MODIFIERS_rec.incompatibility_grp_code)
3744: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3745: l_MODIFIERS_rec.list_line_no)
3746: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),

Line 3744: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,

3740: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3741: l_MODIFIERS_rec.pricing_group_sequence)
3742: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3743: l_MODIFIERS_rec.incompatibility_grp_code)
3744: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3745: l_MODIFIERS_rec.list_line_no)
3746: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3747: l_MODIFIERS_rec.product_precedence)
3748: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,

Line 3746: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),

3742: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3743: l_MODIFIERS_rec.incompatibility_grp_code)
3744: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3745: l_MODIFIERS_rec.list_line_no)
3746: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3747: l_MODIFIERS_rec.product_precedence)
3748: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3749: l_MODIFIERS_rec.expiration_period_start_date)
3750: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,

Line 3748: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,

3744: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3745: l_MODIFIERS_rec.list_line_no)
3746: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3747: l_MODIFIERS_rec.product_precedence)
3748: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3749: l_MODIFIERS_rec.expiration_period_start_date)
3750: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3751: l_MODIFIERS_rec.number_expiration_periods)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,

Line 3750: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,

3746: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3747: l_MODIFIERS_rec.product_precedence)
3748: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3749: l_MODIFIERS_rec.expiration_period_start_date)
3750: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3751: l_MODIFIERS_rec.number_expiration_periods)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3753: l_MODIFIERS_rec.expiration_period_uom)
3754: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,

Line 3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,

3748: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3749: l_MODIFIERS_rec.expiration_period_start_date)
3750: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3751: l_MODIFIERS_rec.number_expiration_periods)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3753: l_MODIFIERS_rec.expiration_period_uom)
3754: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3755: l_MODIFIERS_rec.expiration_date)
3756: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,

Line 3754: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,

3750: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3751: l_MODIFIERS_rec.number_expiration_periods)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3753: l_MODIFIERS_rec.expiration_period_uom)
3754: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3755: l_MODIFIERS_rec.expiration_date)
3756: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3757: l_MODIFIERS_rec.estim_gl_value)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,

Line 3756: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,

3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3753: l_MODIFIERS_rec.expiration_period_uom)
3754: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3755: l_MODIFIERS_rec.expiration_date)
3756: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3757: l_MODIFIERS_rec.estim_gl_value)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3759: l_MODIFIERS_rec.benefit_price_list_line_id)
3760: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,

Line 3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,

3754: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3755: l_MODIFIERS_rec.expiration_date)
3756: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3757: l_MODIFIERS_rec.estim_gl_value)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3759: l_MODIFIERS_rec.benefit_price_list_line_id)
3760: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3761: -- l_MODIFIERS_rec.recurring_flag)
3762: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,

Line 3760: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,

3756: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3757: l_MODIFIERS_rec.estim_gl_value)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3759: l_MODIFIERS_rec.benefit_price_list_line_id)
3760: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3761: -- l_MODIFIERS_rec.recurring_flag)
3762: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3763: l_MODIFIERS_rec.benefit_limit)
3764: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,

Line 3762: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,

3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3759: l_MODIFIERS_rec.benefit_price_list_line_id)
3760: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3761: -- l_MODIFIERS_rec.recurring_flag)
3762: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3763: l_MODIFIERS_rec.benefit_limit)
3764: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3765: l_MODIFIERS_rec.charge_type_code)
3766: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,

Line 3764: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,

3760: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3761: -- l_MODIFIERS_rec.recurring_flag)
3762: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3763: l_MODIFIERS_rec.benefit_limit)
3764: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3765: l_MODIFIERS_rec.charge_type_code)
3766: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3767: l_MODIFIERS_rec.charge_subtype_code)
3768: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,

Line 3766: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,

3762: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3763: l_MODIFIERS_rec.benefit_limit)
3764: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3765: l_MODIFIERS_rec.charge_type_code)
3766: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3767: l_MODIFIERS_rec.charge_subtype_code)
3768: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3769: l_MODIFIERS_rec.benefit_qty)
3770: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,

Line 3768: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,

3764: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3765: l_MODIFIERS_rec.charge_type_code)
3766: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3767: l_MODIFIERS_rec.charge_subtype_code)
3768: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3769: l_MODIFIERS_rec.benefit_qty)
3770: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3771: l_MODIFIERS_rec.benefit_uom_code)
3772: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,

Line 3770: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,

3766: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3767: l_MODIFIERS_rec.charge_subtype_code)
3768: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3769: l_MODIFIERS_rec.benefit_qty)
3770: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3771: l_MODIFIERS_rec.benefit_uom_code)
3772: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3773: l_MODIFIERS_rec.accrual_conversion_rate)
3774: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,

Line 3772: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,

3768: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3769: l_MODIFIERS_rec.benefit_qty)
3770: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3771: l_MODIFIERS_rec.benefit_uom_code)
3772: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3773: l_MODIFIERS_rec.accrual_conversion_rate)
3774: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,
3775: l_MODIFIERS_rec.proration_type_code)
3776: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.include_on_returns_flag, l_MODIFIERS_rec.include_on_returns_flag),

Line 3774: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,

3770: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3771: l_MODIFIERS_rec.benefit_uom_code)
3772: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3773: l_MODIFIERS_rec.accrual_conversion_rate)
3774: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,
3775: l_MODIFIERS_rec.proration_type_code)
3776: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.include_on_returns_flag, l_MODIFIERS_rec.include_on_returns_flag),
3777: l_MODIFIERS_rec.include_on_returns_flag)
3778:

Line 3776: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.include_on_returns_flag, l_MODIFIERS_rec.include_on_returns_flag),

3772: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3773: l_MODIFIERS_rec.accrual_conversion_rate)
3774: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,
3775: l_MODIFIERS_rec.proration_type_code)
3776: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.include_on_returns_flag, l_MODIFIERS_rec.include_on_returns_flag),
3777: l_MODIFIERS_rec.include_on_returns_flag)
3778:
3779: THEN
3780:

Line 3865: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,

3861: oe_debug_pub.add('BEGIN Get_Values in QPXUMLLB');
3862:
3863: IF p_MODIFIERS_rec.automatic_flag IS NOT NULL AND
3864: p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
3865: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3866: p_old_MODIFIERS_rec.automatic_flag)
3867: THEN
3868: l_MODIFIERS_val_rec.automatic := QP_Id_To_Value.Automatic
3869: ( p_automatic_flag => p_MODIFIERS_rec.automatic_flag

Line 3875: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,

3871: END IF;
3872:
3873: /* IF p_MODIFIERS_rec.base_uom_code IS NOT NULL AND
3874: p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR AND
3875: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3876: p_old_MODIFIERS_rec.base_uom_code)
3877: THEN
3878: l_MODIFIERS_val_rec.base_uom := QP_Id_To_Value.Base_Uom
3879: ( p_base_uom_code => p_MODIFIERS_rec.base_uom_code

Line 3885: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,

3881: END IF;
3882: */
3883: IF p_MODIFIERS_rec.generate_using_formula_id IS NOT NULL AND
3884: p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND
3885: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3886: p_old_MODIFIERS_rec.generate_using_formula_id)
3887: THEN
3888: l_MODIFIERS_val_rec.generate_using_formula := QP_Id_To_Value.Generate_Using_Formula
3889: ( p_generate_using_formula_id => p_MODIFIERS_rec.generate_using_formula_id

Line 3895: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,

3891: END IF;
3892:
3893: IF p_MODIFIERS_rec.inventory_item_id IS NOT NULL AND
3894: p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
3895: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3896: p_old_MODIFIERS_rec.inventory_item_id)
3897: THEN
3898: l_MODIFIERS_val_rec.inventory_item := QP_Id_To_Value.Inventory_Item
3899: ( p_inventory_item_id => p_MODIFIERS_rec.inventory_item_id

Line 3905: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,

3901: END IF;
3902:
3903: IF p_MODIFIERS_rec.list_header_id IS NOT NULL AND
3904: p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
3905: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,
3906: p_old_MODIFIERS_rec.list_header_id)
3907: THEN
3908: l_MODIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header
3909: ( p_list_header_id => p_MODIFIERS_rec.list_header_id

Line 3915: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,

3911: END IF;
3912:
3913: IF p_MODIFIERS_rec.list_line_id IS NOT NULL AND
3914: p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
3915: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3916: p_old_MODIFIERS_rec.list_line_id)
3917: THEN
3918: l_MODIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line
3919: ( p_list_line_id => p_MODIFIERS_rec.list_line_id

Line 3925: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,

3921: END IF;
3922:
3923: IF p_MODIFIERS_rec.list_line_type_code IS NOT NULL AND
3924: p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND
3925: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3926: p_old_MODIFIERS_rec.list_line_type_code)
3927: THEN
3928: l_MODIFIERS_val_rec.list_line_type := QP_Id_To_Value.List_Line_Type
3929: ( p_list_line_type_code => p_MODIFIERS_rec.list_line_type_code

Line 3935: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,

3931: END IF;
3932:
3933: IF p_MODIFIERS_rec.modifier_level_code IS NOT NULL AND
3934: p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND
3935: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3936: p_old_MODIFIERS_rec.modifier_level_code)
3937: THEN
3938: l_MODIFIERS_val_rec.modifier_level := QP_Id_To_Value.Modifier_Level
3939: ( p_modifier_level_code => p_MODIFIERS_rec.modifier_level_code

Line 3945: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,

3941: END IF;
3942:
3943: IF p_MODIFIERS_rec.organization_id IS NOT NULL AND
3944: p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM AND
3945: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3946: p_old_MODIFIERS_rec.organization_id)
3947: THEN
3948: l_MODIFIERS_val_rec.organization := QP_Id_To_Value.Organization
3949: ( p_organization_id => p_MODIFIERS_rec.organization_id

Line 3955: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,

3951: END IF;
3952:
3953: IF p_MODIFIERS_rec.override_flag IS NOT NULL AND
3954: p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR AND
3955: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3956: p_old_MODIFIERS_rec.override_flag)
3957: THEN
3958: l_MODIFIERS_val_rec.override := QP_Id_To_Value.Override
3959: ( p_override_flag => p_MODIFIERS_rec.override_flag

Line 3965: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,

3961: END IF;
3962:
3963: IF p_MODIFIERS_rec.price_break_type_code IS NOT NULL AND
3964: p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND
3965: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3966: p_old_MODIFIERS_rec.price_break_type_code)
3967: THEN
3968: l_MODIFIERS_val_rec.price_break_type := QP_Id_To_Value.Price_Break_Type
3969: ( p_price_break_type_code => p_MODIFIERS_rec.price_break_type_code

Line 3975: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,

3971: END IF;
3972:
3973: IF p_MODIFIERS_rec.price_by_formula_id IS NOT NULL AND
3974: p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND
3975: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3976: p_old_MODIFIERS_rec.price_by_formula_id)
3977: THEN
3978: l_MODIFIERS_val_rec.price_by_formula := QP_Id_To_Value.Price_By_Formula
3979: ( p_price_by_formula_id => p_MODIFIERS_rec.price_by_formula_id

Line 3985: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,

3981: END IF;
3982:
3983: IF p_MODIFIERS_rec.primary_uom_flag IS NOT NULL AND
3984: p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND
3985: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,
3986: p_old_MODIFIERS_rec.primary_uom_flag)
3987: THEN
3988: l_MODIFIERS_val_rec.primary_uom := QP_Id_To_Value.Primary_Uom
3989: ( p_primary_uom_flag => p_MODIFIERS_rec.primary_uom_flag

Line 3995: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,

3991: END IF;
3992:
3993: IF p_MODIFIERS_rec.print_on_invoice_flag IS NOT NULL AND
3994: p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND
3995: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
3996: p_old_MODIFIERS_rec.print_on_invoice_flag)
3997: THEN
3998: l_MODIFIERS_val_rec.print_on_invoice := QP_Id_To_Value.Print_On_Invoice
3999: ( p_print_on_invoice_flag => p_MODIFIERS_rec.print_on_invoice_flag

Line 4005: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,

4001: END IF;
4002:
4003: IF p_MODIFIERS_rec.rebate_trxn_type_code IS NOT NULL AND
4004: p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND
4005: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
4006: p_old_MODIFIERS_rec.rebate_trxn_type_code)
4007: THEN
4008: l_MODIFIERS_val_rec.rebate_transaction_type := QP_Id_To_Value.Rebate_Transaction_Type
4009: ( p_rebate_trxn_type_code => p_MODIFIERS_rec.rebate_trxn_type_code

Line 4015: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,

4011: END IF;
4012:
4013: IF p_MODIFIERS_rec.related_item_id IS NOT NULL AND
4014: p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM AND
4015: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
4016: p_old_MODIFIERS_rec.related_item_id)
4017: THEN
4018: l_MODIFIERS_val_rec.related_item := QP_Id_To_Value.Related_Item
4019: ( p_related_item_id => p_MODIFIERS_rec.related_item_id

Line 4025: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,

4021: END IF;
4022:
4023: IF p_MODIFIERS_rec.relationship_type_id IS NOT NULL AND
4024: p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM AND
4025: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
4026: p_old_MODIFIERS_rec.relationship_type_id)
4027: THEN
4028: l_MODIFIERS_val_rec.relationship_type := QP_Id_To_Value.Relationship_Type
4029: ( p_relationship_type_id => p_MODIFIERS_rec.relationship_type_id

Line 4035: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,

4031: END IF;
4032:
4033: IF p_MODIFIERS_rec.reprice_flag IS NOT NULL AND
4034: p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
4035: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
4036: p_old_MODIFIERS_rec.reprice_flag)
4037: THEN
4038: l_MODIFIERS_val_rec.reprice := QP_Id_To_Value.Reprice
4039: ( p_reprice_flag => p_MODIFIERS_rec.reprice_flag

Line 4045: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,

4041: END IF;
4042:
4043: IF p_MODIFIERS_rec.revision_reason_code IS NOT NULL AND
4044: p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
4045: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
4046: p_old_MODIFIERS_rec.revision_reason_code)
4047: THEN
4048: l_MODIFIERS_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason
4049: ( p_revision_reason_code => p_MODIFIERS_rec.revision_reason_code

Line 4697: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

4693: ((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE) and
4694: (p_old_MODIFIERS_rec.pricing_phase_id <> p_MODIFIERS_rec.pricing_phase_id))
4695: then
4696: qp_delayed_requests_PVT.log_request(
4697: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4698: p_entity_id => p_MODIFIERS_rec.list_header_id,
4699: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4700: p_param4 => l_call_from,
4701: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 4701: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4697: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4698: p_entity_id => p_MODIFIERS_rec.list_header_id,
4699: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4700: p_param4 => l_call_from,
4701: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4702: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4703: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4704: x_return_status => l_return_status);
4705:

Line 4703: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,

4699: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4700: p_param4 => l_call_from,
4701: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4702: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4703: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4704: x_return_status => l_return_status);
4705:
4706: if ((p_MODIFIERS_rec.operation) NOT IN(OE_GLOBALS.G_OPR_CREATE)) then
4707: qp_delayed_requests_PVT.log_request(

Line 4708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

4704: x_return_status => l_return_status);
4705:
4706: if ((p_MODIFIERS_rec.operation) NOT IN(OE_GLOBALS.G_OPR_CREATE)) then
4707: qp_delayed_requests_PVT.log_request(
4708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4709: p_entity_id => p_MODIFIERS_rec.list_header_id,
4710: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4711: p_param4 => l_call_from,
4712: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 4712: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4709: p_entity_id => p_MODIFIERS_rec.list_header_id,
4710: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4711: p_param4 => l_call_from,
4712: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4713: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4714: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4715: x_return_status => l_return_status);
4716: end if;

Line 4714: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,

4710: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4711: p_param4 => l_call_from,
4712: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4713: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4714: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4715: x_return_status => l_return_status);
4716: end if;
4717: end if;
4718:

Line 4728: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

4724: then
4725: Log_Update_Phases_DL(p_MODIFIERS_rec => p_MODIFIERS_rec,
4726: x_return_status => l_return_status);
4727: qp_delayed_requests_PVT.log_request(
4728: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4729: p_entity_id => p_MODIFIERS_rec.list_header_id,
4730: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4731: p_param4 => l_call_from,
4732: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 4732: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4728: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4729: p_entity_id => p_MODIFIERS_rec.list_header_id,
4730: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4731: p_param4 => l_call_from,
4732: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4733: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4734: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4735: x_return_status => l_return_status);
4736: end if;

Line 4734: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,

4730: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4731: p_param4 => l_call_from,
4732: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4733: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4734: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4735: x_return_status => l_return_status);
4736: end if;
4737: if p_MODIFIERS_rec.automatic_flag <> p_old_MODIFIERS_rec.automatic_flag then
4738: select active_flag into l_active_flag from qp_list_headers_b

Line 4751: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

4747: l_count :=0;
4748: end;
4749: if l_count >0 then
4750: qp_delayed_requests_PVT.log_request(
4751: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4752: p_entity_id => p_MODIFIERS_rec.list_header_id,
4753: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4754: p_param2 => p_MODIFIERS_rec.automatic_flag,
4755: p_param3 => l_count,

Line 4757: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4753: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4754: p_param2 => p_MODIFIERS_rec.automatic_flag,
4755: p_param3 => l_count,
4756: p_param4 => l_call_from,
4757: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4758: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4759: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4760: x_return_status => l_return_status);
4761: end if;

Line 4759: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,

4755: p_param3 => l_count,
4756: p_param4 => l_call_from,
4757: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4758: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4759: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4760: x_return_status => l_return_status);
4761: end if;
4762: end if;
4763: end if;

Line 4775: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4771: oe_debug_pub.add('request to update G_UPDATE_MANUAL_MODIFIER_FLAG '||l_parent_line_type, 1);
4772: oe_debug_pub.add('Logging a request to update G_UPDATE_MANUAL_MODIFIER_FLAG ', 1);
4773:
4774: qp_delayed_requests_PVT.log_request(
4775: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4776: p_entity_id => p_MODIFIERS_rec.list_line_id,
4777: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4778: p_param2 => p_MODIFIERS_rec.automatic_flag,
4779: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 4779: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4775: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4776: p_entity_id => p_MODIFIERS_rec.list_line_id,
4777: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4778: p_param2 => p_MODIFIERS_rec.automatic_flag,
4779: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4780: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4781: p_request_type => QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG,
4782: x_return_status => l_return_status);
4783: END IF;

Line 4781: p_request_type => QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG,

4777: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4778: p_param2 => p_MODIFIERS_rec.automatic_flag,
4779: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4780: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4781: p_request_type => QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG,
4782: x_return_status => l_return_status);
4783: END IF;
4784:
4785: EXCEPTION

Line 4820: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

4816: where pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
4817:
4818: if l_manual_modifier_flag is null then
4819: qp_delayed_requests_PVT.log_request(
4820: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4821: p_entity_id => p_MODIFIERS_rec.list_header_id,
4822: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4823: p_param2 => p_MODIFIERS_rec.automatic_flag,
4824: p_param4 => l_call_from,

Line 4825: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4821: p_entity_id => p_MODIFIERS_rec.list_header_id,
4822: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4823: p_param2 => p_MODIFIERS_rec.automatic_flag,
4824: p_param4 => l_call_from,
4825: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4826: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4827: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4828: x_return_status => l_return_status);
4829:

Line 4827: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,

4823: p_param2 => p_MODIFIERS_rec.automatic_flag,
4824: p_param4 => l_call_from,
4825: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4826: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4827: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4828: x_return_status => l_return_status);
4829:
4830: elsif l_manual_modifier_flag = 'A' then
4831: if( p_MODIFIERS_rec.automatic_flag = 'Y') then

Line 4835: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

4831: if( p_MODIFIERS_rec.automatic_flag = 'Y') then
4832: null;
4833: else
4834: qp_delayed_requests_PVT.log_request(
4835: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4836: p_entity_id => p_MODIFIERS_rec.list_header_id,
4837: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4838: p_param2 => p_MODIFIERS_rec.automatic_flag,
4839: p_param4 => l_call_from,

Line 4840: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4836: p_entity_id => p_MODIFIERS_rec.list_header_id,
4837: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4838: p_param2 => p_MODIFIERS_rec.automatic_flag,
4839: p_param4 => l_call_from,
4840: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4841: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4842: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4843: x_return_status => l_return_status);
4844: end if;

Line 4842: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,

4838: p_param2 => p_MODIFIERS_rec.automatic_flag,
4839: p_param4 => l_call_from,
4840: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4841: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4842: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4843: x_return_status => l_return_status);
4844: end if;
4845: elsif l_manual_modifier_flag ='M' then
4846: if (p_MODIFIERS_rec.automatic_flag = 'N') then

Line 4850: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

4846: if (p_MODIFIERS_rec.automatic_flag = 'N') then
4847: null;
4848: else
4849: qp_delayed_requests_PVT.log_request(
4850: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4851: p_entity_id => p_MODIFIERS_rec.list_header_id,
4852: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4853: p_param2 => p_MODIFIERS_rec.automatic_flag,
4854: p_param4 => l_call_from,

Line 4855: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

4851: p_entity_id => p_MODIFIERS_rec.list_header_id,
4852: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4853: p_param2 => p_MODIFIERS_rec.automatic_flag,
4854: p_param4 => l_call_from,
4855: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4856: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4857: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4858: x_return_status => l_return_status);
4859: end if;

Line 4857: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,

4853: p_param2 => p_MODIFIERS_rec.automatic_flag,
4854: p_param4 => l_call_from,
4855: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4856: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4857: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4858: x_return_status => l_return_status);
4859: end if;
4860: else
4861: null;