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

822: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
823: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' THEN
824: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
825: qp_delayed_requests_pvt.log_request(
826: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
827: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
828: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
829: p_request_unique_key2 => 'UD',
830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

826: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
827: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
828: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
829: p_request_unique_key2 => 'UD',
830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
832: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
833: x_return_status => l_return_status);
834: END IF;

Line 832: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

828: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
829: p_request_unique_key2 => 'UD',
830: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
832: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
833: x_return_status => l_return_status);
834: END IF;
835: END IF;
836: END IF;

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

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

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

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

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

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

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

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

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

855: THEN
856: NULL;
857: END IF;
858:
859: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,p_old_PRICING_ATTR_rec.product_attribute_datatype)
860: THEN
861: NULL;
862: END IF;
863:

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

860: THEN
861: NULL;
862: END IF;
863:
864: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
865: THEN
866: NULL;
867: END IF;
868:

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

865: THEN
866: NULL;
867: END IF;
868:
869: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,p_old_PRICING_ATTR_rec.comparison_operator_code)
870: THEN
871: NULL;
872: END IF;
873:

Line 1580: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1576: --Log delayed request to maintain denormalized pricing attrs columns only
1577: --for formula factor attrs
1578: IF l_list_line_type_code = 'PMR' THEN
1579: qp_delayed_requests_PVT.log_request(
1580: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1581: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1582: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1583: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1584: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

Line 1582: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1578: IF l_list_line_type_code = 'PMR' THEN
1579: qp_delayed_requests_PVT.log_request(
1580: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1581: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1582: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1583: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1584: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1585: x_return_status => l_return_status);
1586: END IF;

Line 1584: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

1580: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1581: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1582: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1583: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1584: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1585: x_return_status => l_return_status);
1586: END IF;
1587:
1588: oe_debug_pub.add('END Update_Row in QPXUPRAB');

Line 1828: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1824:
1825: END IF;
1826: END IF;
1827: qp_delayed_requests_PVT.log_request(
1828: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1829: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1830: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1832: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

Line 1830: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1826: END IF;
1827: qp_delayed_requests_PVT.log_request(
1828: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1829: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1830: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1832: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1833: x_return_status => l_return_status);
1834:

Line 1832: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

1828: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1829: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1830: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1832: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1833: x_return_status => l_return_status);
1834:
1835: --Fetch list line type code (Bug 4706180)
1836: BEGIN

Line 1851: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1847: --Log delayed request to maintain denormalized pricing attrs columns
1848: --only for formula factor attrs
1849: IF l_list_line_type_code = 'PMR' THEN
1850: qp_delayed_requests_PVT.log_request(
1851: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1852: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1853: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1854: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1855: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

Line 1853: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1849: IF l_list_line_type_code = 'PMR' THEN
1850: qp_delayed_requests_PVT.log_request(
1851: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1852: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1853: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1854: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1855: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1856: x_return_status => l_return_status);
1857: END IF;

Line 1855: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

1851: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1852: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1853: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1854: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1855: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1856: x_return_status => l_return_status);
1857: END IF;
1858:
1859: oe_debug_pub.add('END Insert_Row in QPXUPRAB');

Line 1895: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1891: RETURNING LIST_LINE_ID INTO l_list_line_id
1892: ;
1893:
1894: qp_delayed_requests_PVT.log_request(
1895: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1896: p_entity_id => l_list_line_id,
1897: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1898: p_requesting_entity_id => l_list_line_id,
1899: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

Line 1897: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,

1893:
1894: qp_delayed_requests_PVT.log_request(
1895: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1896: p_entity_id => l_list_line_id,
1897: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1898: p_requesting_entity_id => l_list_line_id,
1899: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1900: x_return_status => l_return_status);
1901:

Line 1899: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,

1895: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1896: p_entity_id => l_list_line_id,
1897: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1898: p_requesting_entity_id => l_list_line_id,
1899: p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS,
1900: x_return_status => l_return_status);
1901:
1902: oe_debug_pub.add('END Delete_Row in QPXUPRAB');
1903: EXCEPTION

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

2230:
2231: -- Row locked. Compare IN attributes to DB attributes.
2232:
2233: IF
2234: --QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2235: -- l_PRICING_ATTR_rec.accumulate_flag)
2236: --AND
2237: /*
2238: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,

Line 2238: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,

2234: --QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2235: -- l_PRICING_ATTR_rec.accumulate_flag)
2236: --AND
2237: /*
2238: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
2239: l_PRICING_ATTR_rec.attribute1)
2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2241: l_PRICING_ATTR_rec.attribute10)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,

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

2236: --AND
2237: /*
2238: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
2239: l_PRICING_ATTR_rec.attribute1)
2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2241: l_PRICING_ATTR_rec.attribute10)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2243: l_PRICING_ATTR_rec.attribute11)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,

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

2238: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
2239: l_PRICING_ATTR_rec.attribute1)
2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2241: l_PRICING_ATTR_rec.attribute10)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2243: l_PRICING_ATTR_rec.attribute11)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2245: l_PRICING_ATTR_rec.attribute12)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,

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

2240: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
2241: l_PRICING_ATTR_rec.attribute10)
2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2243: l_PRICING_ATTR_rec.attribute11)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2245: l_PRICING_ATTR_rec.attribute12)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2247: l_PRICING_ATTR_rec.attribute13)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,

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

2242: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
2243: l_PRICING_ATTR_rec.attribute11)
2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2245: l_PRICING_ATTR_rec.attribute12)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2247: l_PRICING_ATTR_rec.attribute13)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2249: l_PRICING_ATTR_rec.attribute14)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,

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

2244: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
2245: l_PRICING_ATTR_rec.attribute12)
2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2247: l_PRICING_ATTR_rec.attribute13)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2249: l_PRICING_ATTR_rec.attribute14)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2251: l_PRICING_ATTR_rec.attribute15)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,

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

2246: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
2247: l_PRICING_ATTR_rec.attribute13)
2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2249: l_PRICING_ATTR_rec.attribute14)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2251: l_PRICING_ATTR_rec.attribute15)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2253: l_PRICING_ATTR_rec.attribute2)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,

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

2248: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
2249: l_PRICING_ATTR_rec.attribute14)
2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2251: l_PRICING_ATTR_rec.attribute15)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2253: l_PRICING_ATTR_rec.attribute2)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2255: l_PRICING_ATTR_rec.attribute3)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,

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

2250: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
2251: l_PRICING_ATTR_rec.attribute15)
2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2253: l_PRICING_ATTR_rec.attribute2)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2255: l_PRICING_ATTR_rec.attribute3)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2257: l_PRICING_ATTR_rec.attribute4)
2258: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,

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

2252: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
2253: l_PRICING_ATTR_rec.attribute2)
2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2255: l_PRICING_ATTR_rec.attribute3)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2257: l_PRICING_ATTR_rec.attribute4)
2258: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2259: l_PRICING_ATTR_rec.attribute5)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,

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

2254: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
2255: l_PRICING_ATTR_rec.attribute3)
2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2257: l_PRICING_ATTR_rec.attribute4)
2258: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2259: l_PRICING_ATTR_rec.attribute5)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2261: l_PRICING_ATTR_rec.attribute6)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,

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

2256: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
2257: l_PRICING_ATTR_rec.attribute4)
2258: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2259: l_PRICING_ATTR_rec.attribute5)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2261: l_PRICING_ATTR_rec.attribute6)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2263: l_PRICING_ATTR_rec.attribute7)
2264: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,

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

2258: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
2259: l_PRICING_ATTR_rec.attribute5)
2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2261: l_PRICING_ATTR_rec.attribute6)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2263: l_PRICING_ATTR_rec.attribute7)
2264: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2265: l_PRICING_ATTR_rec.attribute8)
2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,

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

2260: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
2261: l_PRICING_ATTR_rec.attribute6)
2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2263: l_PRICING_ATTR_rec.attribute7)
2264: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2265: l_PRICING_ATTR_rec.attribute8)
2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2267: l_PRICING_ATTR_rec.attribute9)
2268: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,

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

2262: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
2263: l_PRICING_ATTR_rec.attribute7)
2264: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2265: l_PRICING_ATTR_rec.attribute8)
2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2267: l_PRICING_ATTR_rec.attribute9)
2268: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2269: l_PRICING_ATTR_rec.attribute_grouping_no)
2270: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,

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

2264: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
2265: l_PRICING_ATTR_rec.attribute8)
2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2267: l_PRICING_ATTR_rec.attribute9)
2268: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2269: l_PRICING_ATTR_rec.attribute_grouping_no)
2270: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2271: l_PRICING_ATTR_rec.context)
2272: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,

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

2266: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
2267: l_PRICING_ATTR_rec.attribute9)
2268: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2269: l_PRICING_ATTR_rec.attribute_grouping_no)
2270: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2271: l_PRICING_ATTR_rec.context)
2272: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2273: l_PRICING_ATTR_rec.created_by)
2274: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,

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

2268: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
2269: l_PRICING_ATTR_rec.attribute_grouping_no)
2270: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2271: l_PRICING_ATTR_rec.context)
2272: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2273: l_PRICING_ATTR_rec.created_by)
2274: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2275: -- l_PRICING_ATTR_rec.creation_date)
2276: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,

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

2270: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
2271: l_PRICING_ATTR_rec.context)
2272: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2273: l_PRICING_ATTR_rec.created_by)
2274: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2275: -- l_PRICING_ATTR_rec.creation_date)
2276: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2277: l_PRICING_ATTR_rec.excluder_flag)
2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,

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

2272: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
2273: l_PRICING_ATTR_rec.created_by)
2274: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2275: -- l_PRICING_ATTR_rec.creation_date)
2276: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2277: l_PRICING_ATTR_rec.excluder_flag)
2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2279: l_PRICING_ATTR_rec.last_updated_by)
2280: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,

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

2274: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,
2275: -- l_PRICING_ATTR_rec.creation_date)
2276: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2277: l_PRICING_ATTR_rec.excluder_flag)
2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2279: l_PRICING_ATTR_rec.last_updated_by)
2280: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,
2281: -- l_PRICING_ATTR_rec.last_update_date)
2282: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,

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

2276: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2277: l_PRICING_ATTR_rec.excluder_flag)
2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2279: l_PRICING_ATTR_rec.last_updated_by)
2280: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,
2281: -- l_PRICING_ATTR_rec.last_update_date)
2282: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
2283: l_PRICING_ATTR_rec.last_update_login)
2284: */

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

2278: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
2279: l_PRICING_ATTR_rec.last_updated_by)
2280: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,
2281: -- l_PRICING_ATTR_rec.last_update_date)
2282: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
2283: l_PRICING_ATTR_rec.last_update_login)
2284: */
2285: --AND
2286: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,

Line 2286: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,

2282: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
2283: l_PRICING_ATTR_rec.last_update_login)
2284: */
2285: --AND
2286: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2287: l_PRICING_ATTR_rec.list_line_id)
2288: /*
2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
2290: l_PRICING_ATTR_rec.pricing_attribute)

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

2285: --AND
2286: QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2287: l_PRICING_ATTR_rec.list_line_id)
2288: /*
2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
2290: l_PRICING_ATTR_rec.pricing_attribute)
2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
2292: l_PRICING_ATTR_rec.pricing_attribute_context)
2293: */

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

2287: l_PRICING_ATTR_rec.list_line_id)
2288: /*
2289: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
2290: l_PRICING_ATTR_rec.pricing_attribute)
2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
2292: l_PRICING_ATTR_rec.pricing_attribute_context)
2293: */
2294: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2295: l_PRICING_ATTR_rec.pricing_attribute_id)

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

2290: l_PRICING_ATTR_rec.pricing_attribute)
2291: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
2292: l_PRICING_ATTR_rec.pricing_attribute_context)
2293: */
2294: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2295: l_PRICING_ATTR_rec.pricing_attribute_id)
2296: /*
2297: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2298: l_PRICING_ATTR_rec.pricing_attr_value_from)

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

2293: */
2294: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2295: l_PRICING_ATTR_rec.pricing_attribute_id)
2296: /*
2297: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2298: l_PRICING_ATTR_rec.pricing_attr_value_from)
2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2300: l_PRICING_ATTR_rec.pricing_attr_value_to)
2301: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,

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

2295: l_PRICING_ATTR_rec.pricing_attribute_id)
2296: /*
2297: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2298: l_PRICING_ATTR_rec.pricing_attr_value_from)
2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2300: l_PRICING_ATTR_rec.pricing_attr_value_to)
2301: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2302: l_PRICING_ATTR_rec.product_attribute)
2303: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,

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

2297: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
2298: l_PRICING_ATTR_rec.pricing_attr_value_from)
2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2300: l_PRICING_ATTR_rec.pricing_attr_value_to)
2301: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2302: l_PRICING_ATTR_rec.product_attribute)
2303: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2304: l_PRICING_ATTR_rec.product_attribute_context)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,

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

2299: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
2300: l_PRICING_ATTR_rec.pricing_attr_value_to)
2301: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2302: l_PRICING_ATTR_rec.product_attribute)
2303: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2304: l_PRICING_ATTR_rec.product_attribute_context)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2306: l_PRICING_ATTR_rec.product_attr_value)
2307: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,

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

2301: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
2302: l_PRICING_ATTR_rec.product_attribute)
2303: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2304: l_PRICING_ATTR_rec.product_attribute_context)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2306: l_PRICING_ATTR_rec.product_attr_value)
2307: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2308: l_PRICING_ATTR_rec.product_uom_code)
2309: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,

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

2303: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
2304: l_PRICING_ATTR_rec.product_attribute_context)
2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2306: l_PRICING_ATTR_rec.product_attr_value)
2307: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2308: l_PRICING_ATTR_rec.product_uom_code)
2309: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2310: l_PRICING_ATTR_rec.program_application_id)
2311: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,

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

2305: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
2306: l_PRICING_ATTR_rec.product_attr_value)
2307: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2308: l_PRICING_ATTR_rec.product_uom_code)
2309: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2310: l_PRICING_ATTR_rec.program_application_id)
2311: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2312: l_PRICING_ATTR_rec.program_id)
2313: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,

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

2307: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2308: l_PRICING_ATTR_rec.product_uom_code)
2309: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2310: l_PRICING_ATTR_rec.program_application_id)
2311: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2312: l_PRICING_ATTR_rec.program_id)
2313: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2314: -- l_PRICING_ATTR_rec.program_update_date)
2315: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,

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

2309: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
2310: l_PRICING_ATTR_rec.program_application_id)
2311: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2312: l_PRICING_ATTR_rec.program_id)
2313: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2314: -- l_PRICING_ATTR_rec.program_update_date)
2315: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2316: l_PRICING_ATTR_rec.request_id)
2317: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,

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

2311: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
2312: l_PRICING_ATTR_rec.program_id)
2313: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2314: -- l_PRICING_ATTR_rec.program_update_date)
2315: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2316: l_PRICING_ATTR_rec.request_id)
2317: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2318: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2319: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,

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

2313: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,
2314: -- l_PRICING_ATTR_rec.program_update_date)
2315: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2316: l_PRICING_ATTR_rec.request_id)
2317: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2318: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2319: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
2320: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2321: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,

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

2315: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
2316: l_PRICING_ATTR_rec.request_id)
2317: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2318: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2319: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
2320: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2321: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
2322: l_PRICING_ATTR_rec.comparison_operator_code)
2323: */

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

2317: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
2318: -- l_PRICING_ATTR_rec.product_attribute_datatype)
2319: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
2320: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2321: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
2322: l_PRICING_ATTR_rec.comparison_operator_code)
2323: */
2324: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2325: l_PRICING_ATTR_rec.list_header_id)

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

2320: -- l_PRICING_ATTR_rec.pricing_attribute_datatype)
2321: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
2322: l_PRICING_ATTR_rec.comparison_operator_code)
2323: */
2324: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2325: l_PRICING_ATTR_rec.list_header_id)
2326: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2327: l_PRICING_ATTR_rec.pricing_phase_id)
2328: THEN

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

2322: l_PRICING_ATTR_rec.comparison_operator_code)
2323: */
2324: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2325: l_PRICING_ATTR_rec.list_header_id)
2326: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2327: l_PRICING_ATTR_rec.pricing_phase_id)
2328: THEN
2329:
2330: -- Row has not changed. Set out parameter.

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

2453: oe_debug_pub.add('BEGIN Get_Values in QPXUPRAB');
2454:
2455: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
2456: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
2457: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2458: p_old_PRICING_ATTR_rec.accumulate_flag)
2459: THEN
2460: l_PRICING_ATTR_val_rec.accumulate := QP_Id_To_Value.Accumulate
2461: ( p_accumulate_flag => p_PRICING_ATTR_rec.accumulate_flag

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

2463: END IF;
2464:
2465: IF p_PRICING_ATTR_rec.excluder_flag IS NOT NULL AND
2466: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2467: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2468: p_old_PRICING_ATTR_rec.excluder_flag)
2469: THEN
2470: l_PRICING_ATTR_val_rec.excluder := QP_Id_To_Value.Excluder
2471: ( p_excluder_flag => p_PRICING_ATTR_rec.excluder_flag

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

2474:
2475: /*changes made by spgopal to include list_header_id and pricing_phase_id in pricing attr for performance problem*/
2476: IF p_PRICING_ATTR_rec.list_header_id IS NOT NULL AND
2477: p_PRICING_ATTR_rec.list_header_id <> FND_API.G_MISS_NUM AND
2478: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
2479: p_old_PRICING_ATTR_rec.list_header_id)
2480: THEN
2481: -- l_PRICING_ATTR_val_rec.list_Header := QP_Id_To_Value.List_Header( p_list_header_id => p_PRICING_ATTR_rec.list_header_id);
2482: null;

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

2483: END IF;
2484:
2485: IF p_PRICING_ATTR_rec.pricing_phase_id IS NOT NULL AND
2486: p_PRICING_ATTR_rec.pricing_phase_id <> FND_API.G_MISS_NUM AND
2487: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
2488: p_old_PRICING_ATTR_rec.pricing_phase_id)
2489: THEN
2490: -- l_PRICING_ATTR_val_rec.pricing_phase := QP_Id_To_Value.pricing_phase( p_pricing_phase_id => p_PRICING_ATTR_rec.pricing_phase_id);
2491: null;

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

2492: END IF;
2493:
2494: IF p_PRICING_ATTR_rec.list_line_id IS NOT NULL AND
2495: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND
2496: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2497: p_old_PRICING_ATTR_rec.list_line_id)
2498: THEN
2499: l_PRICING_ATTR_val_rec.list_line := QP_Id_To_Value.List_Line
2500: ( p_list_line_id => p_PRICING_ATTR_rec.list_line_id

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

2502: END IF;
2503:
2504: /* IF p_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL AND
2505: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND
2506: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2507: p_old_PRICING_ATTR_rec.pricing_attribute_id)
2508: THEN
2509: l_PRICING_ATTR_val_rec.pricing_attribute := QP_Id_To_Value.Pricing_Attribute
2510: ( p_pricing_attribute_id => p_PRICING_ATTR_rec.pricing_attribute_id

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

2512: END IF;
2513: */
2514: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
2515: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND
2516: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2517: p_old_PRICING_ATTR_rec.product_uom_code)
2518: THEN
2519: l_PRICING_ATTR_val_rec.product_uom := QP_Id_To_Value.Product_Uom
2520: ( p_product_uom_code => p_PRICING_ATTR_rec.product_uom_code

Line 2851: IF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND p_PRICING_ATTR_rec.excluder_flag = 'N') --14603635

2847:
2848: oe_debug_pub.Add('Entering QP_PRICING_ATTR_Util.pre_write_process', 1);
2849: --Bug 10421292 . Added following code to update pricing attributes when the Product attribute is changed in Modifier form.
2850: --Similar issue addressed for Price list in bug 2807015
2851: IF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND p_PRICING_ATTR_rec.excluder_flag = 'N') --14603635
2852: THEN
2853: IF ((p_old_PRICING_ATTR_rec.product_attribute <> p_PRICING_ATTR_rec.product_attribute) OR
2854: (p_old_PRICING_ATTR_rec.product_attr_value <> p_PRICING_ATTR_rec.product_attr_value))
2855: THEN

Line 2867: ELSIF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE AND p_PRICING_ATTR_rec.excluder_flag = 'N') THEN --14603635

2863: null;
2864: end;
2865: END IF;
2866:
2867: ELSIF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE AND p_PRICING_ATTR_rec.excluder_flag = 'N') THEN --14603635
2868: begin
2869: update qp_pricing_attributes
2870: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2871: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value

Line 2918: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

2914: end;
2915:
2916: if l_changed_lines = 'Y' then
2917: qp_delayed_requests_pvt.log_request(
2918: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2919: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2920: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2921: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2922: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,

Line 2920: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

2916: if l_changed_lines = 'Y' then
2917: qp_delayed_requests_pvt.log_request(
2918: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2919: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2920: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2921: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2922: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,
2923: p_param1 => p_PRICING_ATTR_rec.pricing_phase_id,
2924: p_param2 => p_PRICING_ATTR_rec.list_header_id,

Line 2922: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,

2918: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2919: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2920: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2921: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2922: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL,
2923: p_param1 => p_PRICING_ATTR_rec.pricing_phase_id,
2924: p_param2 => p_PRICING_ATTR_rec.list_header_id,
2925: p_param3 => p_PRICING_ATTR_rec.product_attribute,
2926: p_param4 => p_PRICING_ATTR_rec.product_attr_value,

Line 2933: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,

2929: end if;
2930:
2931:
2932: qp_delayed_requests_PVT.log_request(
2933: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2934: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2935: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
2936: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2937: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 2935: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,

2931:
2932: qp_delayed_requests_PVT.log_request(
2933: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2934: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2935: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
2936: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2937: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2938: x_return_status => l_return_status);
2939: END IF;

Line 2937: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

2933: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2934: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2935: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
2936: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2937: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2938: x_return_status => l_return_status);
2939: END IF;
2940: -- pattern
2941: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN

Line 2944: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2940: -- pattern
2941: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2942: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2943: qp_delayed_requests_pvt.log_request(
2944: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2945: p_entity_id => l_list_header_id,
2946: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2947: p_request_unique_key2 => 'I',
2948: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2948: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2944: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2945: p_entity_id => l_list_header_id,
2946: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2947: p_request_unique_key2 => 'I',
2948: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2949: p_requesting_entity_id => l_list_header_id,
2950: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2951: x_return_status => l_return_status);
2952:

Line 2950: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2946: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2947: p_request_unique_key2 => 'I',
2948: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2949: p_requesting_entity_id => l_list_header_id,
2950: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2951: x_return_status => l_return_status);
2952:
2953: END IF;
2954: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 2956: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2952:
2953: END IF;
2954: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2955: qp_delayed_requests_pvt.log_request(
2956: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2957: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2958: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2959: p_request_unique_key2 => 'U',
2960: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2960: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2956: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2957: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2958: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2959: p_request_unique_key2 => 'U',
2960: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2961: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2962: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2963: x_return_status => l_return_status);
2964: END IF;

Line 2962: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2958: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2959: p_request_unique_key2 => 'U',
2960: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2961: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2962: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2963: x_return_status => l_return_status);
2964: END IF;
2965: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2966: qp_delayed_requests_pvt.log_request(

Line 2967: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2963: x_return_status => l_return_status);
2964: END IF;
2965: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2966: qp_delayed_requests_pvt.log_request(
2967: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2968: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2969: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2970: p_request_unique_key2 => 'D',
2971: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2971: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2967: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2968: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2969: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2970: p_request_unique_key2 => 'D',
2971: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2972: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2973: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2974: x_return_status => l_return_status);
2975: END IF;

Line 2973: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2969: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2970: p_request_unique_key2 => 'D',
2971: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2972: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2973: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2974: x_return_status => l_return_status);
2975: END IF;
2976: END IF; --Java Engine Installed
2977: -- pattern

Line 2983: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2979: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
2980: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' THEN
2981: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2982: qp_delayed_requests_pvt.log_request(
2983: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2984: p_entity_id => l_list_header_id,
2985: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2986: p_request_unique_key2 => 'I',
2987: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2987: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2983: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2984: p_entity_id => l_list_header_id,
2985: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2986: p_request_unique_key2 => 'I',
2987: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2988: p_requesting_entity_id => l_list_header_id,
2989: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2990: x_return_status => l_return_status);
2991:

Line 2989: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2985: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2986: p_request_unique_key2 => 'I',
2987: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2988: p_requesting_entity_id => l_list_header_id,
2989: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2990: x_return_status => l_return_status);
2991:
2992: END IF;
2993: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 2995: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2991:
2992: END IF;
2993: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2994: qp_delayed_requests_pvt.log_request(
2995: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2996: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2997: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2998: p_request_unique_key2 => 'U',
2999: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2999: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2995: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2996: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2997: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2998: p_request_unique_key2 => 'U',
2999: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3000: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
3001: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
3002: x_return_status => l_return_status);
3003: END IF;

Line 3001: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2997: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2998: p_request_unique_key2 => 'U',
2999: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3000: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
3001: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
3002: x_return_status => l_return_status);
3003: END IF;
3004: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
3005: qp_delayed_requests_pvt.log_request(

Line 3006: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

3002: x_return_status => l_return_status);
3003: END IF;
3004: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
3005: qp_delayed_requests_pvt.log_request(
3006: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3007: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
3008: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
3009: p_request_unique_key2 => 'D',
3010: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 3010: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

3006: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3007: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
3008: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
3009: p_request_unique_key2 => 'D',
3010: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3011: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
3012: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
3013: x_return_status => l_return_status);
3014: END IF;

Line 3012: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

3008: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
3009: p_request_unique_key2 => 'D',
3010: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3011: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
3012: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
3013: x_return_status => l_return_status);
3014: END IF;
3015: END IF; --PL/SQL pattern search
3016: END IF; -- Java Engine Installed