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

APPS.QP_PRICING_ATTR_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_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 QPXUPRAB');

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 QPXUPRAB');
24:

Line 34: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)

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_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)
35: THEN
36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ACCUMULATE;
38: END IF;

Line 40: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,p_old_PRICING_ATTR_rec.attribute1)

36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ACCUMULATE;
38: END IF;
39:
40: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,p_old_PRICING_ATTR_rec.attribute1)
41: THEN
42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE1;
44: END IF;

Line 46: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,p_old_PRICING_ATTR_rec.attribute10)

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

Line 52: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,p_old_PRICING_ATTR_rec.attribute11)

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

Line 58: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,p_old_PRICING_ATTR_rec.attribute12)

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

Line 64: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,p_old_PRICING_ATTR_rec.attribute13)

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

Line 70: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,p_old_PRICING_ATTR_rec.attribute14)

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

Line 76: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,p_old_PRICING_ATTR_rec.attribute15)

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

Line 82: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,p_old_PRICING_ATTR_rec.attribute2)

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

Line 88: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,p_old_PRICING_ATTR_rec.attribute3)

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

Line 94: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,p_old_PRICING_ATTR_rec.attribute4)

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

Line 100: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,p_old_PRICING_ATTR_rec.attribute5)

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

Line 106: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,p_old_PRICING_ATTR_rec.attribute6)

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

Line 112: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,p_old_PRICING_ATTR_rec.attribute7)

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

Line 118: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,p_old_PRICING_ATTR_rec.attribute8)

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

Line 124: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,p_old_PRICING_ATTR_rec.attribute9)

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

Line 130: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,p_old_PRICING_ATTR_rec.attribute_grouping_no)

126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE9;
128: END IF;
129:
130: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,p_old_PRICING_ATTR_rec.attribute_grouping_no)
131: THEN
132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE_GROUPING_NO;
134: END IF;

Line 136: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)

132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_ATTRIBUTE_GROUPING_NO;
134: END IF;
135:
136: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)
137: THEN
138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CONTEXT;
140: END IF;

Line 142: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,p_old_PRICING_ATTR_rec.created_by)

138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CONTEXT;
140: END IF;
141:
142: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,p_old_PRICING_ATTR_rec.created_by)
143: THEN
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATED_BY;
146: END IF;

Line 148: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,p_old_PRICING_ATTR_rec.creation_date)

144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATED_BY;
146: END IF;
147:
148: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,p_old_PRICING_ATTR_rec.creation_date)
149: THEN
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATION_DATE;
152: END IF;

Line 154: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,p_old_PRICING_ATTR_rec.excluder_flag)

150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_CREATION_DATE;
152: END IF;
153:
154: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,p_old_PRICING_ATTR_rec.excluder_flag)
155: THEN
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_EXCLUDER;
158: END IF;

Line 160: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)

156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_EXCLUDER;
158: END IF;
159:
160: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)
161: THEN
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATED_BY;
164: END IF;

Line 166: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)

162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATED_BY;
164: END IF;
165:
166: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)
167: THEN
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_DATE;
170: END IF;

Line 172: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)

168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_DATE;
170: END IF;
171:
172: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_LOGIN;
176: END IF;

Line 179: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)

175: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LAST_UPDATE_LOGIN;
176: END IF;
177:
178: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
179: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
180: THEN
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_HEADER;
183: END IF;

Line 186: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)

182: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_HEADER;
183: END IF;
184:
185: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
186: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
187: THEN
188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_PHASE;
190: END IF;

Line 192: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)

188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_PHASE;
190: END IF;
191:
192: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
193: THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_LINE;
196: END IF;

Line 198: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)

194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_LIST_LINE;
196: END IF;
197:
198: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)
199: THEN
200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
202: END IF;

Line 204: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)

200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
202: END IF;
203:
204: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
205: THEN
206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
208: END IF;

Line 211: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)

207: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
208: END IF;
209:
210: /*
211: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)
212: THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
215: END IF;

Line 218: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)

214: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE;
215: END IF;
216: */
217:
218: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_FROM;
222: END IF;

Line 224: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,p_old_PRICING_ATTR_rec.pricing_attr_value_to)

220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_FROM;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,p_old_PRICING_ATTR_rec.pricing_attr_value_to)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_TO;
228: END IF;

Line 230: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,p_old_PRICING_ATTR_rec.product_attribute)

226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTR_VALUE_TO;
228: END IF;
229:
230: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,p_old_PRICING_ATTR_rec.product_attribute)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE;
234: END IF;

Line 236: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)

232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE;
234: END IF;
235:
236: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)
237: THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
240: END IF;

Line 242: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,p_old_PRICING_ATTR_rec.product_attr_value)

238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_CONTEXT;
240: END IF;
241:
242: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,p_old_PRICING_ATTR_rec.product_attr_value)
243: THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTR_VALUE;
246: END IF;

Line 248: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)

244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTR_VALUE;
246: END IF;
247:
248: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)
249: THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_UOM;
252: END IF;

Line 254: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,p_old_PRICING_ATTR_rec.program_application_id)

250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_UOM;
252: END IF;
253:
254: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,p_old_PRICING_ATTR_rec.program_application_id)
255: THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_APPLICATION;
258: END IF;

Line 260: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,p_old_PRICING_ATTR_rec.program_id)

256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_APPLICATION;
258: END IF;
259:
260: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,p_old_PRICING_ATTR_rec.program_id)
261: THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM;
264: END IF;

Line 266: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)

262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM;
264: END IF;
265:
266: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)
267: THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_UPDATE_DATE;
270: END IF;

Line 272: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)

268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PROGRAM_UPDATE_DATE;
270: END IF;
271:
272: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)
273: THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;
276: END IF;

Line 278: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,p_old_PRICING_ATTR_rec.product_attribute_datatype)

274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_REQUEST;
276: END IF;
277:
278: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,p_old_PRICING_ATTR_rec.product_attribute_datatype)
279: THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
282: END IF;

Line 284: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,p_old_PRICING_ATTR_rec.pricing_attribute_datatype)

280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
282: END IF;
283:
284: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
285: THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
288: END IF;

Line 290: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,p_old_PRICING_ATTR_rec.comparison_operator_code)

286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
288: END IF;
289:
290: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,p_old_PRICING_ATTR_rec.comparison_operator_code)
291: THEN
292: l_index := l_index + 1;
293: l_src_attr_tbl(l_index) := QP_PRICING_ATTR_UTIL.G_COMPARISON_OPERATOR;
294: END IF;

Line 454: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,

450: x_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
451:
452: -- Get Product Attribute Datatype
453:
454: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
455: p_old_PRICING_ATTR_rec.product_attribute_context)
456: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
457: p_old_PRICING_ATTR_rec.product_attribute)
458: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,

Line 456: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,

452: -- Get Product Attribute Datatype
453:
454: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
455: p_old_PRICING_ATTR_rec.product_attribute_context)
456: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
457: p_old_PRICING_ATTR_rec.product_attribute)
458: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
459: p_old_PRICING_ATTR_rec.product_attr_value)
460: THEN

Line 458: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,

454: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
455: p_old_PRICING_ATTR_rec.product_attribute_context)
456: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
457: p_old_PRICING_ATTR_rec.product_attribute)
458: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
459: p_old_PRICING_ATTR_rec.product_attr_value)
460: THEN
461:
462: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_PRICING'

Line 481: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,

477: END IF;
478:
479: -- Get Pricing Attribute Datatype
480:
481: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
482: p_old_PRICING_ATTR_rec.pricing_attribute_context)
483: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
484: p_old_PRICING_ATTR_rec.pricing_attribute)
485: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,

Line 483: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,

479: -- Get Pricing Attribute Datatype
480:
481: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
482: p_old_PRICING_ATTR_rec.pricing_attribute_context)
483: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
484: p_old_PRICING_ATTR_rec.pricing_attribute)
485: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
486: p_old_PRICING_ATTR_rec.pricing_attr_value_from)
487: THEN

Line 485: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,

481: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
482: p_old_PRICING_ATTR_rec.pricing_attribute_context)
483: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
484: p_old_PRICING_ATTR_rec.pricing_attribute)
485: OR NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
486: p_old_PRICING_ATTR_rec.pricing_attr_value_from)
487: THEN
488:
489: IF p_PRICING_ATTR_rec.pricing_attribute_context = 'VOLUME'

Line 514: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)

510:
511: END IF;
512: END IF;
513:
514: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)
515: THEN
516: NULL;
517: END IF;
518:

Line 519: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,p_old_PRICING_ATTR_rec.attribute1)

515: THEN
516: NULL;
517: END IF;
518:
519: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,p_old_PRICING_ATTR_rec.attribute1)
520: THEN
521: NULL;
522: END IF;
523:

Line 525: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,p_old_PRICING_ATTR_rec.attribute10)

521: NULL;
522: END IF;
523:
524: oe_debug_pub.add('11');
525: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,p_old_PRICING_ATTR_rec.attribute10)
526: THEN
527: NULL;
528: END IF;
529:

Line 530: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,p_old_PRICING_ATTR_rec.attribute11)

526: THEN
527: NULL;
528: END IF;
529:
530: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,p_old_PRICING_ATTR_rec.attribute11)
531: THEN
532: NULL;
533: END IF;
534:

Line 535: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,p_old_PRICING_ATTR_rec.attribute12)

531: THEN
532: NULL;
533: END IF;
534:
535: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,p_old_PRICING_ATTR_rec.attribute12)
536: THEN
537: NULL;
538: END IF;
539:

Line 541: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,p_old_PRICING_ATTR_rec.attribute13)

537: NULL;
538: END IF;
539:
540: oe_debug_pub.add('22');
541: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,p_old_PRICING_ATTR_rec.attribute13)
542: THEN
543: NULL;
544: END IF;
545:

Line 546: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,p_old_PRICING_ATTR_rec.attribute14)

542: THEN
543: NULL;
544: END IF;
545:
546: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,p_old_PRICING_ATTR_rec.attribute14)
547: THEN
548: NULL;
549: END IF;
550:

Line 551: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,p_old_PRICING_ATTR_rec.attribute15)

547: THEN
548: NULL;
549: END IF;
550:
551: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,p_old_PRICING_ATTR_rec.attribute15)
552: THEN
553: NULL;
554: END IF;
555:

Line 557: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,p_old_PRICING_ATTR_rec.attribute2)

553: NULL;
554: END IF;
555:
556: oe_debug_pub.add('33');
557: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,p_old_PRICING_ATTR_rec.attribute2)
558: THEN
559: NULL;
560: END IF;
561:

Line 562: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,p_old_PRICING_ATTR_rec.attribute3)

558: THEN
559: NULL;
560: END IF;
561:
562: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,p_old_PRICING_ATTR_rec.attribute3)
563: THEN
564: NULL;
565: END IF;
566:

Line 567: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,p_old_PRICING_ATTR_rec.attribute4)

563: THEN
564: NULL;
565: END IF;
566:
567: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,p_old_PRICING_ATTR_rec.attribute4)
568: THEN
569: NULL;
570: END IF;
571:

Line 572: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,p_old_PRICING_ATTR_rec.attribute5)

568: THEN
569: NULL;
570: END IF;
571:
572: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,p_old_PRICING_ATTR_rec.attribute5)
573: THEN
574: NULL;
575: END IF;
576:

Line 578: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,p_old_PRICING_ATTR_rec.attribute6)

574: NULL;
575: END IF;
576:
577: oe_debug_pub.add('44');
578: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,p_old_PRICING_ATTR_rec.attribute6)
579: THEN
580: NULL;
581: END IF;
582:

Line 583: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,p_old_PRICING_ATTR_rec.attribute7)

579: THEN
580: NULL;
581: END IF;
582:
583: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,p_old_PRICING_ATTR_rec.attribute7)
584: THEN
585: NULL;
586: END IF;
587:

Line 588: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,p_old_PRICING_ATTR_rec.attribute8)

584: THEN
585: NULL;
586: END IF;
587:
588: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,p_old_PRICING_ATTR_rec.attribute8)
589: THEN
590: NULL;
591: END IF;
592:

Line 593: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,p_old_PRICING_ATTR_rec.attribute9)

589: THEN
590: NULL;
591: END IF;
592:
593: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,p_old_PRICING_ATTR_rec.attribute9)
594: THEN
595: NULL;
596: END IF;
597:

Line 598: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,p_old_PRICING_ATTR_rec.attribute_grouping_no)

594: THEN
595: NULL;
596: END IF;
597:
598: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,p_old_PRICING_ATTR_rec.attribute_grouping_no)
599: THEN
600: NULL;
601: END IF;
602:

Line 604: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)

600: NULL;
601: END IF;
602:
603: oe_debug_pub.add('55');
604: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)
605: THEN
606: NULL;
607: END IF;
608:

Line 609: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,p_old_PRICING_ATTR_rec.created_by)

605: THEN
606: NULL;
607: END IF;
608:
609: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,p_old_PRICING_ATTR_rec.created_by)
610: THEN
611: NULL;
612: END IF;
613:

Line 614: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,p_old_PRICING_ATTR_rec.creation_date)

610: THEN
611: NULL;
612: END IF;
613:
614: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,p_old_PRICING_ATTR_rec.creation_date)
615: THEN
616: NULL;
617: END IF;
618:

Line 619: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,p_old_PRICING_ATTR_rec.excluder_flag)

615: THEN
616: NULL;
617: END IF;
618:
619: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,p_old_PRICING_ATTR_rec.excluder_flag)
620: THEN
621: NULL;
622: END IF;
623:

Line 624: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)

620: THEN
621: NULL;
622: END IF;
623:
624: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)
625: THEN
626: NULL;
627: END IF;
628:

Line 629: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)

625: THEN
626: NULL;
627: END IF;
628:
629: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)
630: THEN
631: NULL;
632: END IF;
633:

Line 634: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)

630: THEN
631: NULL;
632: END IF;
633:
634: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,p_old_PRICING_ATTR_rec.last_update_login)
635: THEN
636: NULL;
637: END IF;
638:

Line 640: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)

636: NULL;
637: END IF;
638:
639: /*included by spgopal to include list_header_id in pricing attr for performance problems*/
640: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
641: THEN
642: /* commented this part as it is not reqd- spgopal
643: IF p_PRICING_ATTR_rec.list_header_id IS NULL OR
644: p_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 665: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)

661: NULL;
662: END IF;
663:
664: /*included by spgopal to include pricing_phase_id in pricing attr for performance problems*/
665: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
666: THEN
667: /* commented this part as it is not reqd - spgopal
668: IF p_PRICING_ATTR_rec.pricing_phase_id IS NULL OR
669: p_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

Line 688: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)

684:
685: NULL;
686: END IF;
687:
688: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
689: THEN
690: qp_delayed_requests_PVT.log_request(
691: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
692: p_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 691: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

687:
688: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
689: THEN
690: qp_delayed_requests_PVT.log_request(
691: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
692: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
693: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
694: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
695: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 693: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

689: THEN
690: qp_delayed_requests_PVT.log_request(
691: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
692: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
693: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
694: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
695: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
696: x_return_status => l_return_status);
697: END IF;

Line 695: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

691: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
692: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
693: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
694: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
695: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
696: x_return_status => l_return_status);
697: END IF;
698:
699: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)

Line 699: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)

695: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
696: x_return_status => l_return_status);
697: END IF;
698:
699: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)
700: THEN
701: NULL;
702: END IF;
703:

Line 704: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)

700: THEN
701: NULL;
702: END IF;
703:
704: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
705: THEN
706: -- mkarya for bug 1789276, log the request for a change in pricing_attribute_context
707: qp_delayed_requests_PVT.log_request(
708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

704: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
705: THEN
706: -- mkarya for bug 1789276, log the request for a change in pricing_attribute_context
707: qp_delayed_requests_PVT.log_request(
708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
709: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
712: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

706: -- mkarya for bug 1789276, log the request for a change in pricing_attribute_context
707: qp_delayed_requests_PVT.log_request(
708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
709: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
712: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
713: x_return_status => l_return_status);
714: NULL;

Line 712: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
709: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
712: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
713: x_return_status => l_return_status);
714: NULL;
715: END IF;
716:

Line 717: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)

713: x_return_status => l_return_status);
714: NULL;
715: END IF;
716:
717: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)
718: THEN
719: NULL;
720: END IF;
721:

Line 722: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)

718: THEN
719: NULL;
720: END IF;
721:
722: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)
723: THEN
724:
725: --Fetch modfier group type (Bug 4706180) Start
726: BEGIN

Line 751: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,p_old_PRICING_ATTR_rec.pricing_attr_value_to)

747: END IF;
748: NULL;
749: END IF;
750:
751: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,p_old_PRICING_ATTR_rec.pricing_attr_value_to)
752: THEN
753: NULL;
754: END IF;
755:

Line 756: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,p_old_PRICING_ATTR_rec.product_attribute)

752: THEN
753: NULL;
754: END IF;
755:
756: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,p_old_PRICING_ATTR_rec.product_attribute)
757: THEN
758: NULL;
759: END IF;
760:

Line 761: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)

757: THEN
758: NULL;
759: END IF;
760:
761: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)
762: THEN
763: -- mkarya for bug 1789276, log the request for a change in product_attribute_context
764: qp_delayed_requests_PVT.log_request(
765: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

Line 765: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

761: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)
762: THEN
763: -- mkarya for bug 1789276, log the request for a change in product_attribute_context
764: qp_delayed_requests_PVT.log_request(
765: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
766: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
767: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
768: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
769: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 767: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

763: -- mkarya for bug 1789276, log the request for a change in product_attribute_context
764: qp_delayed_requests_PVT.log_request(
765: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
766: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
767: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
768: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
769: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
770: x_return_status => l_return_status);
771: NULL;

Line 769: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

765: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
766: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
767: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
768: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
769: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
770: x_return_status => l_return_status);
771: NULL;
772: END IF;
773:

Line 774: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,p_old_PRICING_ATTR_rec.product_attr_value)

770: x_return_status => l_return_status);
771: NULL;
772: END IF;
773:
774: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,p_old_PRICING_ATTR_rec.product_attr_value)
775: THEN
776: NULL;
777: END IF;
778:

Line 779: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)

775: THEN
776: NULL;
777: END IF;
778:
779: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)
780: THEN
781:
782: -- for updating price breaks rassharm bug no 7315129
783: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

Line 783: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

779: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)
780: THEN
781:
782: -- for updating price breaks rassharm bug no 7315129
783: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
784: THEN
785: UPDATE qp_pricing_attributes
786: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
787: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;

Line 810: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

806: --pattern
807: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
808: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
809: qp_delayed_requests_pvt.log_request(
810: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
811: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
812: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
813: p_request_unique_key2 => 'UD',
814: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 814: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

810: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
811: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
812: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
813: p_request_unique_key2 => 'UD',
814: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
815: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
816: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
817: x_return_status => l_return_status);
818: END IF;

Line 816: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

812: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
813: p_request_unique_key2 => 'UD',
814: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
815: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
816: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
817: x_return_status => l_return_status);
818: END IF;
819: END IF; --Java Engine Installed
820: --pattern

Line 823: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,p_old_PRICING_ATTR_rec.program_application_id)

819: END IF; --Java Engine Installed
820: --pattern
821: END IF;
822:
823: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,p_old_PRICING_ATTR_rec.program_application_id)
824: THEN
825: NULL;
826: END IF;
827:

Line 828: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,p_old_PRICING_ATTR_rec.program_id)

824: THEN
825: NULL;
826: END IF;
827:
828: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,p_old_PRICING_ATTR_rec.program_id)
829: THEN
830: NULL;
831: END IF;
832:

Line 833: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)

829: THEN
830: NULL;
831: END IF;
832:
833: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)
834: THEN
835: NULL;
836: END IF;
837:

Line 838: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)

834: THEN
835: NULL;
836: END IF;
837:
838: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)
839: THEN
840: NULL;
841: END IF;
842:

Line 843: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,p_old_PRICING_ATTR_rec.product_attribute_datatype)

839: THEN
840: NULL;
841: END IF;
842:
843: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,p_old_PRICING_ATTR_rec.product_attribute_datatype)
844: THEN
845: NULL;
846: END IF;
847:

Line 848: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,p_old_PRICING_ATTR_rec.pricing_attribute_datatype)

844: THEN
845: NULL;
846: END IF;
847:
848: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
849: THEN
850: NULL;
851: END IF;
852:

Line 853: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,p_old_PRICING_ATTR_rec.comparison_operator_code)

849: THEN
850: NULL;
851: END IF;
852:
853: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,p_old_PRICING_ATTR_rec.comparison_operator_code)
854: THEN
855: NULL;
856: END IF;
857:

Line 1564: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1560: --Log delayed request to maintain denormalized pricing attrs columns only
1561: --for formula factor attrs
1562: IF l_list_line_type_code = 'PMR' THEN
1563: qp_delayed_requests_PVT.log_request(
1564: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1565: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1566: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1567: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1568: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

Line 1566: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1562: IF l_list_line_type_code = 'PMR' THEN
1563: qp_delayed_requests_PVT.log_request(
1564: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1565: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1566: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1567: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1568: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1569: x_return_status => l_return_status);
1570: END IF;

Line 1568: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

1564: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1565: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1566: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1567: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1568: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1569: x_return_status => l_return_status);
1570: END IF;
1571:
1572: oe_debug_pub.add('END Update_Row in QPXUPRAB');

Line 1812: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1808:
1809: END IF;
1810: END IF;
1811: qp_delayed_requests_PVT.log_request(
1812: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1813: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1814: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1815: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1816: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

Line 1814: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1810: END IF;
1811: qp_delayed_requests_PVT.log_request(
1812: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1813: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1814: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1815: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1816: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1817: x_return_status => l_return_status);
1818:

Line 1816: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

1812: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1813: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1814: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1815: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1816: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1817: x_return_status => l_return_status);
1818:
1819: --Fetch list line type code (Bug 4706180)
1820: BEGIN

Line 1835: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1831: --Log delayed request to maintain denormalized pricing attrs columns
1832: --only for formula factor attrs
1833: IF l_list_line_type_code = 'PMR' THEN
1834: qp_delayed_requests_PVT.log_request(
1835: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1836: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1837: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1838: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1839: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

Line 1837: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1833: IF l_list_line_type_code = 'PMR' THEN
1834: qp_delayed_requests_PVT.log_request(
1835: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1836: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1837: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1838: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1839: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1840: x_return_status => l_return_status);
1841: END IF;

Line 1839: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

1835: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1836: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1837: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1838: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1839: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1840: x_return_status => l_return_status);
1841: END IF;
1842:
1843: oe_debug_pub.add('END Insert_Row in QPXUPRAB');

Line 1879: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1875: RETURNING LIST_LINE_ID INTO l_list_line_id
1876: ;
1877:
1878: qp_delayed_requests_PVT.log_request(
1879: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1880: p_entity_id => l_list_line_id,
1881: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1882: p_requesting_entity_id => l_list_line_id,
1883: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

Line 1881: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1877:
1878: qp_delayed_requests_PVT.log_request(
1879: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1880: p_entity_id => l_list_line_id,
1881: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1882: p_requesting_entity_id => l_list_line_id,
1883: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1884: x_return_status => l_return_status);
1885:

Line 1883: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

1879: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1880: p_entity_id => l_list_line_id,
1881: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1882: p_requesting_entity_id => l_list_line_id,
1883: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1884: x_return_status => l_return_status);
1885:
1886: oe_debug_pub.add('END Delete_Row in QPXUPRAB');
1887: EXCEPTION

Line 2218: --QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,

2214:
2215: -- Row locked. Compare IN attributes to DB attributes.
2216:
2217: IF
2218: --QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2219: -- l_PRICING_ATTR_rec.accumulate_flag)
2220: --AND
2221: /*
2222: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,

Line 2222: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,

2218: --QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2219: -- l_PRICING_ATTR_rec.accumulate_flag)
2220: --AND
2221: /*
2222: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
2223: l_PRICING_ATTR_rec.attribute1)
2224: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2225: l_PRICING_ATTR_rec.attribute10)
2226: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,

Line 2224: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,

2220: --AND
2221: /*
2222: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
2223: l_PRICING_ATTR_rec.attribute1)
2224: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2225: l_PRICING_ATTR_rec.attribute10)
2226: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2227: l_PRICING_ATTR_rec.attribute11)
2228: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,

Line 2226: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,

2222: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
2223: l_PRICING_ATTR_rec.attribute1)
2224: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2225: l_PRICING_ATTR_rec.attribute10)
2226: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2227: l_PRICING_ATTR_rec.attribute11)
2228: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2229: l_PRICING_ATTR_rec.attribute12)
2230: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,

Line 2228: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,

2224: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2225: l_PRICING_ATTR_rec.attribute10)
2226: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2227: l_PRICING_ATTR_rec.attribute11)
2228: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2229: l_PRICING_ATTR_rec.attribute12)
2230: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2231: l_PRICING_ATTR_rec.attribute13)
2232: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,

Line 2230: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,

2226: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2227: l_PRICING_ATTR_rec.attribute11)
2228: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2229: l_PRICING_ATTR_rec.attribute12)
2230: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2231: l_PRICING_ATTR_rec.attribute13)
2232: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2233: l_PRICING_ATTR_rec.attribute14)
2234: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,

Line 2232: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,

2228: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2229: l_PRICING_ATTR_rec.attribute12)
2230: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2231: l_PRICING_ATTR_rec.attribute13)
2232: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2233: l_PRICING_ATTR_rec.attribute14)
2234: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2235: l_PRICING_ATTR_rec.attribute15)
2236: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,

Line 2234: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,

2230: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2231: l_PRICING_ATTR_rec.attribute13)
2232: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2233: l_PRICING_ATTR_rec.attribute14)
2234: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2235: l_PRICING_ATTR_rec.attribute15)
2236: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2237: l_PRICING_ATTR_rec.attribute2)
2238: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,

Line 2236: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,

2232: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2233: l_PRICING_ATTR_rec.attribute14)
2234: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2235: l_PRICING_ATTR_rec.attribute15)
2236: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2237: l_PRICING_ATTR_rec.attribute2)
2238: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2239: l_PRICING_ATTR_rec.attribute3)
2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,

Line 2238: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,

2234: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2235: l_PRICING_ATTR_rec.attribute15)
2236: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2237: l_PRICING_ATTR_rec.attribute2)
2238: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2239: l_PRICING_ATTR_rec.attribute3)
2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2241: l_PRICING_ATTR_rec.attribute4)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,

Line 2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,

2236: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2237: l_PRICING_ATTR_rec.attribute2)
2238: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2239: l_PRICING_ATTR_rec.attribute3)
2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2241: l_PRICING_ATTR_rec.attribute4)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2243: l_PRICING_ATTR_rec.attribute5)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,

Line 2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,

2238: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2239: l_PRICING_ATTR_rec.attribute3)
2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2241: l_PRICING_ATTR_rec.attribute4)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2243: l_PRICING_ATTR_rec.attribute5)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2245: l_PRICING_ATTR_rec.attribute6)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,

Line 2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,

2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2241: l_PRICING_ATTR_rec.attribute4)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2243: l_PRICING_ATTR_rec.attribute5)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2245: l_PRICING_ATTR_rec.attribute6)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2247: l_PRICING_ATTR_rec.attribute7)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,

Line 2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,

2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2243: l_PRICING_ATTR_rec.attribute5)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2245: l_PRICING_ATTR_rec.attribute6)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2247: l_PRICING_ATTR_rec.attribute7)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2249: l_PRICING_ATTR_rec.attribute8)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,

Line 2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,

2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2245: l_PRICING_ATTR_rec.attribute6)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2247: l_PRICING_ATTR_rec.attribute7)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2249: l_PRICING_ATTR_rec.attribute8)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2251: l_PRICING_ATTR_rec.attribute9)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,

Line 2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,

2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2247: l_PRICING_ATTR_rec.attribute7)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2249: l_PRICING_ATTR_rec.attribute8)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2251: l_PRICING_ATTR_rec.attribute9)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2253: l_PRICING_ATTR_rec.attribute_grouping_no)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,

Line 2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,

2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2249: l_PRICING_ATTR_rec.attribute8)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2251: l_PRICING_ATTR_rec.attribute9)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2253: l_PRICING_ATTR_rec.attribute_grouping_no)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2255: l_PRICING_ATTR_rec.context)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,

Line 2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,

2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2251: l_PRICING_ATTR_rec.attribute9)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2253: l_PRICING_ATTR_rec.attribute_grouping_no)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2255: l_PRICING_ATTR_rec.context)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2257: l_PRICING_ATTR_rec.created_by)
2258: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,

Line 2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,

2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2253: l_PRICING_ATTR_rec.attribute_grouping_no)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2255: l_PRICING_ATTR_rec.context)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2257: l_PRICING_ATTR_rec.created_by)
2258: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2259: -- l_PRICING_ATTR_rec.creation_date)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,

Line 2258: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,

2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2255: l_PRICING_ATTR_rec.context)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2257: l_PRICING_ATTR_rec.created_by)
2258: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2259: -- l_PRICING_ATTR_rec.creation_date)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2261: l_PRICING_ATTR_rec.excluder_flag)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,

Line 2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,

2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2257: l_PRICING_ATTR_rec.created_by)
2258: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2259: -- l_PRICING_ATTR_rec.creation_date)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2261: l_PRICING_ATTR_rec.excluder_flag)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2263: l_PRICING_ATTR_rec.last_updated_by)
2264: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,

Line 2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,

2258: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2259: -- l_PRICING_ATTR_rec.creation_date)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2261: l_PRICING_ATTR_rec.excluder_flag)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2263: l_PRICING_ATTR_rec.last_updated_by)
2264: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,
2265: -- l_PRICING_ATTR_rec.last_update_date)
2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,

Line 2264: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,

2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2261: l_PRICING_ATTR_rec.excluder_flag)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2263: l_PRICING_ATTR_rec.last_updated_by)
2264: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,
2265: -- l_PRICING_ATTR_rec.last_update_date)
2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
2267: l_PRICING_ATTR_rec.last_update_login)
2268: */

Line 2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,

2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2263: l_PRICING_ATTR_rec.last_updated_by)
2264: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,
2265: -- l_PRICING_ATTR_rec.last_update_date)
2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
2267: l_PRICING_ATTR_rec.last_update_login)
2268: */
2269: --AND
2270: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,

Line 2270: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,

2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
2267: l_PRICING_ATTR_rec.last_update_login)
2268: */
2269: --AND
2270: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2271: l_PRICING_ATTR_rec.list_line_id)
2272: /*
2273: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
2274: l_PRICING_ATTR_rec.pricing_attribute)

Line 2273: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,

2269: --AND
2270: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2271: l_PRICING_ATTR_rec.list_line_id)
2272: /*
2273: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
2274: l_PRICING_ATTR_rec.pricing_attribute)
2275: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
2276: l_PRICING_ATTR_rec.pricing_attribute_context)
2277: */

Line 2275: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,

2271: l_PRICING_ATTR_rec.list_line_id)
2272: /*
2273: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
2274: l_PRICING_ATTR_rec.pricing_attribute)
2275: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
2276: l_PRICING_ATTR_rec.pricing_attribute_context)
2277: */
2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2279: l_PRICING_ATTR_rec.pricing_attribute_id)

Line 2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,

2274: l_PRICING_ATTR_rec.pricing_attribute)
2275: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
2276: l_PRICING_ATTR_rec.pricing_attribute_context)
2277: */
2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2279: l_PRICING_ATTR_rec.pricing_attribute_id)
2280: /*
2281: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2282: l_PRICING_ATTR_rec.pricing_attr_value_from)

Line 2281: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,

2277: */
2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2279: l_PRICING_ATTR_rec.pricing_attribute_id)
2280: /*
2281: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2282: l_PRICING_ATTR_rec.pricing_attr_value_from)
2283: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2284: l_PRICING_ATTR_rec.pricing_attr_value_to)
2285: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,

Line 2283: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,

2279: l_PRICING_ATTR_rec.pricing_attribute_id)
2280: /*
2281: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2282: l_PRICING_ATTR_rec.pricing_attr_value_from)
2283: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2284: l_PRICING_ATTR_rec.pricing_attr_value_to)
2285: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2286: l_PRICING_ATTR_rec.product_attribute)
2287: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,

Line 2285: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,

2281: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2282: l_PRICING_ATTR_rec.pricing_attr_value_from)
2283: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2284: l_PRICING_ATTR_rec.pricing_attr_value_to)
2285: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2286: l_PRICING_ATTR_rec.product_attribute)
2287: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2288: l_PRICING_ATTR_rec.product_attribute_context)
2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,

Line 2287: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,

2283: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2284: l_PRICING_ATTR_rec.pricing_attr_value_to)
2285: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2286: l_PRICING_ATTR_rec.product_attribute)
2287: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2288: l_PRICING_ATTR_rec.product_attribute_context)
2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2290: l_PRICING_ATTR_rec.product_attr_value)
2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,

Line 2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,

2285: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2286: l_PRICING_ATTR_rec.product_attribute)
2287: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2288: l_PRICING_ATTR_rec.product_attribute_context)
2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2290: l_PRICING_ATTR_rec.product_attr_value)
2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2292: l_PRICING_ATTR_rec.product_uom_code)
2293: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,

Line 2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,

2287: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2288: l_PRICING_ATTR_rec.product_attribute_context)
2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2290: l_PRICING_ATTR_rec.product_attr_value)
2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2292: l_PRICING_ATTR_rec.product_uom_code)
2293: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2294: l_PRICING_ATTR_rec.program_application_id)
2295: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,

Line 2293: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,

2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2290: l_PRICING_ATTR_rec.product_attr_value)
2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2292: l_PRICING_ATTR_rec.product_uom_code)
2293: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2294: l_PRICING_ATTR_rec.program_application_id)
2295: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2296: l_PRICING_ATTR_rec.program_id)
2297: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,

Line 2295: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,

2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2292: l_PRICING_ATTR_rec.product_uom_code)
2293: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2294: l_PRICING_ATTR_rec.program_application_id)
2295: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2296: l_PRICING_ATTR_rec.program_id)
2297: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2298: -- l_PRICING_ATTR_rec.program_update_date)
2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,

Line 2297: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,

2293: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2294: l_PRICING_ATTR_rec.program_application_id)
2295: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2296: l_PRICING_ATTR_rec.program_id)
2297: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2298: -- l_PRICING_ATTR_rec.program_update_date)
2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2300: l_PRICING_ATTR_rec.request_id)
2301: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,

Line 2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,

2295: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2296: l_PRICING_ATTR_rec.program_id)
2297: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2298: -- l_PRICING_ATTR_rec.program_update_date)
2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2300: l_PRICING_ATTR_rec.request_id)
2301: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2302: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2303: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,

Line 2301: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,

2297: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2298: -- l_PRICING_ATTR_rec.program_update_date)
2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2300: l_PRICING_ATTR_rec.request_id)
2301: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2302: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2303: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
2304: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,

Line 2303: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,

2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2300: l_PRICING_ATTR_rec.request_id)
2301: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2302: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2303: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
2304: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
2306: l_PRICING_ATTR_rec.comparison_operator_code)
2307: */

Line 2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,

2301: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2302: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2303: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
2304: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
2306: l_PRICING_ATTR_rec.comparison_operator_code)
2307: */
2308: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2309: l_PRICING_ATTR_rec.list_header_id)

Line 2308: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,

2304: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
2306: l_PRICING_ATTR_rec.comparison_operator_code)
2307: */
2308: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2309: l_PRICING_ATTR_rec.list_header_id)
2310: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2311: l_PRICING_ATTR_rec.pricing_phase_id)
2312: THEN

Line 2310: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,

2306: l_PRICING_ATTR_rec.comparison_operator_code)
2307: */
2308: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2309: l_PRICING_ATTR_rec.list_header_id)
2310: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2311: l_PRICING_ATTR_rec.pricing_phase_id)
2312: THEN
2313:
2314: -- Row has not changed. Set out parameter.

Line 2398: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,

2394: oe_debug_pub.add('BEGIN Get_Values in QPXUPRAB');
2395:
2396: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
2397: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
2398: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2399: p_old_PRICING_ATTR_rec.accumulate_flag)
2400: THEN
2401: l_PRICING_ATTR_val_rec.accumulate := QP_Id_To_Value.Accumulate
2402: ( p_accumulate_flag => p_PRICING_ATTR_rec.accumulate_flag

Line 2408: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,

2404: END IF;
2405:
2406: IF p_PRICING_ATTR_rec.excluder_flag IS NOT NULL AND
2407: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2408: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2409: p_old_PRICING_ATTR_rec.excluder_flag)
2410: THEN
2411: l_PRICING_ATTR_val_rec.excluder := QP_Id_To_Value.Excluder
2412: ( p_excluder_flag => p_PRICING_ATTR_rec.excluder_flag

Line 2419: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,

2415:
2416: /*changes made by spgopal to include list_header_id and pricing_phase_id in pricing attr for performance problem*/
2417: IF p_PRICING_ATTR_rec.list_header_id IS NOT NULL AND
2418: p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM AND
2419: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2420: p_old_PRICING_ATTR_rec.list_header_id)
2421: THEN
2422: -- l_PRICING_ATTR_val_rec.list_Header := QP_Id_To_Value.List_Header( p_list_header_id => p_PRICING_ATTR_rec.list_header_id);
2423: null;

Line 2428: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,

2424: END IF;
2425:
2426: IF p_PRICING_ATTR_rec.pricing_phase_id IS NOT NULL AND
2427: p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM AND
2428: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2429: p_old_PRICING_ATTR_rec.pricing_phase_id)
2430: THEN
2431: -- l_PRICING_ATTR_val_rec.pricing_phase := QP_Id_To_Value.pricing_phase( p_pricing_phase_id => p_PRICING_ATTR_rec.pricing_phase_id);
2432: null;

Line 2437: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,

2433: END IF;
2434:
2435: IF p_PRICING_ATTR_rec.list_line_id IS NOT NULL AND
2436: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND
2437: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2438: p_old_PRICING_ATTR_rec.list_line_id)
2439: THEN
2440: l_PRICING_ATTR_val_rec.list_line := QP_Id_To_Value.List_Line
2441: ( p_list_line_id => p_PRICING_ATTR_rec.list_line_id

Line 2447: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,

2443: END IF;
2444:
2445: /* IF p_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL AND
2446: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND
2447: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2448: p_old_PRICING_ATTR_rec.pricing_attribute_id)
2449: THEN
2450: l_PRICING_ATTR_val_rec.pricing_attribute := QP_Id_To_Value.Pricing_Attribute
2451: ( p_pricing_attribute_id => p_PRICING_ATTR_rec.pricing_attribute_id

Line 2457: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,

2453: END IF;
2454: */
2455: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
2456: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND
2457: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2458: p_old_PRICING_ATTR_rec.product_uom_code)
2459: THEN
2460: l_PRICING_ATTR_val_rec.product_uom := QP_Id_To_Value.Product_Uom
2461: ( p_product_uom_code => p_PRICING_ATTR_rec.product_uom_code

Line 2828: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

2824: end;
2825:
2826: if l_changed_lines = 'Y' then
2827: qp_delayed_requests_pvt.log_request(
2828: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2829: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2832: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,

Line 2830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

2826: if l_changed_lines = 'Y' then
2827: qp_delayed_requests_pvt.log_request(
2828: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2829: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2832: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,
2833: p_param1 => p_PRICING_ATTR_rec.pricing_phase_id,
2834: p_param2 => p_PRICING_ATTR_rec.list_header_id,

Line 2832: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,

2828: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2829: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2832: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,
2833: p_param1 => p_PRICING_ATTR_rec.pricing_phase_id,
2834: p_param2 => p_PRICING_ATTR_rec.list_header_id,
2835: p_param3 => p_PRICING_ATTR_rec.product_attribute,
2836: p_param4 => p_PRICING_ATTR_rec.product_attr_value,

Line 2843: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

2839: end if;
2840:
2841:
2842: qp_delayed_requests_PVT.log_request(
2843: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2844: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2845: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
2846: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2847: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 2845: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

2841:
2842: qp_delayed_requests_PVT.log_request(
2843: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2844: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2845: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
2846: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2847: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2848: x_return_status => l_return_status);
2849: END IF;

Line 2847: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

2843: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2844: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2845: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
2846: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2847: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2848: x_return_status => l_return_status);
2849: END IF;
2850: -- pattern
2851: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN

Line 2854: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2850: -- pattern
2851: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2852: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2853: qp_delayed_requests_pvt.log_request(
2854: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2855: p_entity_id => l_list_header_id,
2856: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2857: p_request_unique_key2 => 'I',
2858: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2858: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2854: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2855: p_entity_id => l_list_header_id,
2856: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2857: p_request_unique_key2 => 'I',
2858: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2859: p_requesting_entity_id => l_list_header_id,
2860: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2861: x_return_status => l_return_status);
2862:

Line 2860: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2856: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2857: p_request_unique_key2 => 'I',
2858: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2859: p_requesting_entity_id => l_list_header_id,
2860: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2861: x_return_status => l_return_status);
2862:
2863: END IF;
2864: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 2866: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2862:
2863: END IF;
2864: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2865: qp_delayed_requests_pvt.log_request(
2866: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2867: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2868: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2869: p_request_unique_key2 => 'U',
2870: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2870: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2866: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2867: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2868: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2869: p_request_unique_key2 => 'U',
2870: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2871: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2872: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2873: x_return_status => l_return_status);
2874: END IF;

Line 2872: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2868: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2869: p_request_unique_key2 => 'U',
2870: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2871: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2872: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2873: x_return_status => l_return_status);
2874: END IF;
2875: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2876: qp_delayed_requests_pvt.log_request(

Line 2877: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2873: x_return_status => l_return_status);
2874: END IF;
2875: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2876: qp_delayed_requests_pvt.log_request(
2877: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2878: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2879: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2880: p_request_unique_key2 => 'D',
2881: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2881: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2877: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2878: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2879: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2880: p_request_unique_key2 => 'D',
2881: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2882: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2883: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2884: x_return_status => l_return_status);
2885: END IF;

Line 2883: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2879: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2880: p_request_unique_key2 => 'D',
2881: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2882: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2883: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2884: x_return_status => l_return_status);
2885: END IF;
2886: END IF; --Java Engine Installed
2887: -- pattern