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_PLL_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_Price_List_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: -- Load out record

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: -- Load out record
24:

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

28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_ACCUMULATE;
36: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LAST_UPDATE_LOGIN;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;
180: END IF;

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

178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_LINE;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_HEADER;
186: END IF;

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

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_LIST_HEADER;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_PHASE;
192: END IF;

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

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_PHASE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,p_old_PRICING_ATTR_rec.pricing_attribute)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
198: END IF;

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

196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
204: END IF;

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

203: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
204: END IF;
205:
206: /*
207: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,p_old_PRICING_ATTR_rec.pricing_attribute_id)
208: THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
211: END IF;

Line 214: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.from_rltd_modifier_id,p_old_PRICING_ATTR_rec.from_rltd_modifier_id)

210: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE;
211: END IF;
212: */
213:
214: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.from_rltd_modifier_id,p_old_PRICING_ATTR_rec.from_rltd_modifier_id)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_FROM_RLTD_MODIFIER;
218: END IF;

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

216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_FROM_RLTD_MODIFIER;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,p_old_PRICING_ATTR_rec.pricing_attr_value_from)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTR_VALUE_FROM;
224: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_REQUEST;
278: END IF;
279:
280: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code, p_old_PRICING_ATTR_rec.comparison_operator_code)
281: THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;
284: END IF;

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

282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_COMPARISON_OPERATOR_CODE;
284: END IF;
285:
286: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype, p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
287: THEN
288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
290: END IF;

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

288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRICING_ATTRIBUTE_DATATYPE;
290: END IF;
291:
292: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype, p_old_PRICING_ATTR_rec.product_attribute_datatype)
293: THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_pll_pricing_attr_UTIL.G_PRODUCT_ATTRIBUTE_DATATYPE;
296: END IF;

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

465: x_PRICING_ATTR_rec.list_header_id := l_list_header_id;
466:
467: END IF;
468:
469: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)
470: THEN
471: NULL;
472: END IF;
473:

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

470: THEN
471: NULL;
472: END IF;
473:
474: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,p_old_PRICING_ATTR_rec.attribute1)
475: THEN
476: NULL;
477: END IF;
478:

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

475: THEN
476: NULL;
477: END IF;
478:
479: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,p_old_PRICING_ATTR_rec.attribute10)
480: THEN
481: NULL;
482: END IF;
483:

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

480: THEN
481: NULL;
482: END IF;
483:
484: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,p_old_PRICING_ATTR_rec.attribute11)
485: THEN
486: NULL;
487: END IF;
488:

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

485: THEN
486: NULL;
487: END IF;
488:
489: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,p_old_PRICING_ATTR_rec.attribute12)
490: THEN
491: NULL;
492: END IF;
493:

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

490: THEN
491: NULL;
492: END IF;
493:
494: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,p_old_PRICING_ATTR_rec.attribute13)
495: THEN
496: NULL;
497: END IF;
498:

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

495: THEN
496: NULL;
497: END IF;
498:
499: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,p_old_PRICING_ATTR_rec.attribute14)
500: THEN
501: NULL;
502: END IF;
503:

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

500: THEN
501: NULL;
502: END IF;
503:
504: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,p_old_PRICING_ATTR_rec.attribute15)
505: THEN
506: NULL;
507: END IF;
508:

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

505: THEN
506: NULL;
507: END IF;
508:
509: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,p_old_PRICING_ATTR_rec.attribute2)
510: THEN
511: NULL;
512: END IF;
513:

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

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

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

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

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

520: THEN
521: NULL;
522: END IF;
523:
524: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,p_old_PRICING_ATTR_rec.attribute5)
525: THEN
526: NULL;
527: END IF;
528:

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

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

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

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

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

535: THEN
536: NULL;
537: END IF;
538:
539: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,p_old_PRICING_ATTR_rec.attribute8)
540: THEN
541: NULL;
542: END IF;
543:

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

540: THEN
541: NULL;
542: END IF;
543:
544: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,p_old_PRICING_ATTR_rec.attribute9)
545: THEN
546: NULL;
547: END IF;
548:

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

545: THEN
546: NULL;
547: END IF;
548:
549: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,p_old_PRICING_ATTR_rec.attribute_grouping_no)
550: THEN
551: NULL;
552: END IF;
553:

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

550: THEN
551: NULL;
552: END IF;
553:
554: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,p_old_PRICING_ATTR_rec.context)
555: THEN
556: NULL;
557: END IF;
558:

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

555: THEN
556: NULL;
557: END IF;
558:
559: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,p_old_PRICING_ATTR_rec.created_by)
560: THEN
561: NULL;
562: END IF;
563:

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

560: THEN
561: NULL;
562: END IF;
563:
564: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.creation_date,p_old_PRICING_ATTR_rec.creation_date)
565: THEN
566: NULL;
567: END IF;
568:

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

565: THEN
566: NULL;
567: END IF;
568:
569: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,p_old_PRICING_ATTR_rec.excluder_flag)
570: THEN
571: NULL;
572: END IF;
573:

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

570: THEN
571: NULL;
572: END IF;
573:
574: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,p_old_PRICING_ATTR_rec.last_updated_by)
575: THEN
576: NULL;
577: END IF;
578:

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

575: THEN
576: NULL;
577: END IF;
578:
579: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_date,p_old_PRICING_ATTR_rec.last_update_date)
580: THEN
581: NULL;
582: END IF;
583:

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

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

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

585: THEN
586: NULL;
587: END IF;
588:
589: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
590: THEN
591: qp_delayed_requests_PVT.log_request(
592: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
593: p_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 592: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,

588:
589: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
590: THEN
591: qp_delayed_requests_PVT.log_request(
592: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
593: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
594: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
595: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
596: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 594: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,

590: THEN
591: qp_delayed_requests_PVT.log_request(
592: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
593: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
594: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
595: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
596: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
597: x_return_status => l_return_status);
598: END IF;

Line 596: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

592: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
593: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
594: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
595: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
596: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
597: x_return_status => l_return_status);
598: END IF;
599:
600: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)

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

596: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
597: x_return_status => l_return_status);
598: END IF;
599:
600: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,p_old_PRICING_ATTR_rec.list_header_id)
601: THEN
602: NULL;
603: END IF;
604:

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

601: THEN
602: NULL;
603: END IF;
604:
605: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,p_old_PRICING_ATTR_rec.pricing_phase_id)
606: THEN
607: NULL;
608: END IF;
609:

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

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

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

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

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

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

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

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

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

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

Line 635: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.from_rltd_modifier_id,p_old_PRICING_ATTR_rec.from_rltd_modifier_id)

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

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

636: THEN
637: NULL;
638: END IF;
639:
640: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,p_old_PRICING_ATTR_rec.product_attribute)
641: THEN
642: NULL;
643: END IF;
644:

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

641: THEN
642: NULL;
643: END IF;
644:
645: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)
646: THEN
647: NULL;
648: END IF;
649:

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

646: THEN
647: NULL;
648: END IF;
649:
650: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,p_old_PRICING_ATTR_rec.product_attr_value)
651: THEN
652: NULL;
653: END IF;
654:

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

652: NULL;
653: END IF;
654:
655: G_PRODUCT_UOM_CODE := p_old_PRICING_ATTR_rec.product_uom_code; --Bug#2853373
656: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,p_old_PRICING_ATTR_rec.product_uom_code)
657: THEN
658: oe_debug_pub.add('New UOM : '||p_PRICING_ATTR_rec.product_uom_code);
659: oe_debug_pub.add('Old UOM : '||p_old_PRICING_ATTR_rec.product_uom_code);
660: G_PRODUCT_UOM_CODE := p_PRICING_ATTR_rec.product_uom_code;

Line 662: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

658: oe_debug_pub.add('New UOM : '||p_PRICING_ATTR_rec.product_uom_code);
659: oe_debug_pub.add('Old UOM : '||p_old_PRICING_ATTR_rec.product_uom_code);
660: G_PRODUCT_UOM_CODE := p_PRICING_ATTR_rec.product_uom_code;
661: -- added for bug 2912834
662: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
663: THEN
664: UPDATE qp_pricing_attributes
665: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
666: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;

Line 687: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

683: --pattern
684: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
685: IF(p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
686: qp_delayed_requests_pvt.log_request(
687: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
688: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
689: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
690: p_request_unique_key2 => 'UD',
691: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 691: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

687: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
688: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
689: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
690: p_request_unique_key2 => 'UD',
691: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
692: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
693: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
694: x_return_status => l_return_status);
695: END IF;

Line 693: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

689: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
690: p_request_unique_key2 => 'UD',
691: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
692: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
693: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
694: x_return_status => l_return_status);
695: END IF;
696: END IF;
697: --pattern

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

697: --pattern
698:
699: END IF;
700:
701: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,p_old_PRICING_ATTR_rec.program_application_id)
702: THEN
703: NULL;
704: END IF;
705:

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

702: THEN
703: NULL;
704: END IF;
705:
706: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,p_old_PRICING_ATTR_rec.program_id)
707: THEN
708: NULL;
709: END IF;
710:

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

707: THEN
708: NULL;
709: END IF;
710:
711: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_update_date,p_old_PRICING_ATTR_rec.program_update_date)
712: THEN
713: NULL;
714: END IF;
715:

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

712: THEN
713: NULL;
714: END IF;
715:
716: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,p_old_PRICING_ATTR_rec.request_id)
717: THEN
718: NULL;
719: END IF;
720:

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

717: THEN
718: NULL;
719: END IF;
720:
721: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code, p_old_PRICING_ATTR_rec.comparison_operator_code)
722: THEN
723: NULL;
724: END IF;
725:

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

722: THEN
723: NULL;
724: END IF;
725:
726: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype, p_old_PRICING_ATTR_rec.pricing_attribute_datatype)
727: THEN
728: NULL;
729: END IF;
730:

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

727: THEN
728: NULL;
729: END IF;
730:
731: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype, p_old_PRICING_ATTR_rec.product_attribute_datatype)
732: THEN
733: NULL;
734: END IF;
735:

Line 1455: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1451: END IF;
1452: END IF;
1453:
1454: qp_delayed_requests_PVT.log_request(
1455: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1456: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1457: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
1458: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1459: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

Line 1457: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

1453:
1454: qp_delayed_requests_PVT.log_request(
1455: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1456: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1457: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
1458: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1459: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1460: x_return_status => l_return_status);
1461:

Line 1459: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,

1455: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1456: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1457: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
1458: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1459: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1460: x_return_status => l_return_status);
1461:
1462: EXCEPTION
1463:

Line 1813: IF QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,

1809: FOR UPDATE NOWAIT;
1810:
1811: -- Row locked. Compare IN attributes to DB attributes.
1812:
1813: IF QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
1814: l_PRICING_ATTR_rec.accumulate_flag)
1815: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
1816: l_PRICING_ATTR_rec.attribute1)
1817: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,

Line 1815: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,

1811: -- Row locked. Compare IN attributes to DB attributes.
1812:
1813: IF QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
1814: l_PRICING_ATTR_rec.accumulate_flag)
1815: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
1816: l_PRICING_ATTR_rec.attribute1)
1817: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
1818: l_PRICING_ATTR_rec.attribute10)
1819: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,

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

1813: IF QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
1814: l_PRICING_ATTR_rec.accumulate_flag)
1815: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
1816: l_PRICING_ATTR_rec.attribute1)
1817: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
1818: l_PRICING_ATTR_rec.attribute10)
1819: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
1820: l_PRICING_ATTR_rec.attribute11)
1821: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,

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

1815: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute1,
1816: l_PRICING_ATTR_rec.attribute1)
1817: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
1818: l_PRICING_ATTR_rec.attribute10)
1819: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
1820: l_PRICING_ATTR_rec.attribute11)
1821: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
1822: l_PRICING_ATTR_rec.attribute12)
1823: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,

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

1817: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute10,
1818: l_PRICING_ATTR_rec.attribute10)
1819: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
1820: l_PRICING_ATTR_rec.attribute11)
1821: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
1822: l_PRICING_ATTR_rec.attribute12)
1823: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
1824: l_PRICING_ATTR_rec.attribute13)
1825: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,

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

1819: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute11,
1820: l_PRICING_ATTR_rec.attribute11)
1821: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
1822: l_PRICING_ATTR_rec.attribute12)
1823: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
1824: l_PRICING_ATTR_rec.attribute13)
1825: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
1826: l_PRICING_ATTR_rec.attribute14)
1827: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,

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

1821: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute12,
1822: l_PRICING_ATTR_rec.attribute12)
1823: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
1824: l_PRICING_ATTR_rec.attribute13)
1825: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
1826: l_PRICING_ATTR_rec.attribute14)
1827: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
1828: l_PRICING_ATTR_rec.attribute15)
1829: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,

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

1823: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute13,
1824: l_PRICING_ATTR_rec.attribute13)
1825: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
1826: l_PRICING_ATTR_rec.attribute14)
1827: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
1828: l_PRICING_ATTR_rec.attribute15)
1829: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
1830: l_PRICING_ATTR_rec.attribute2)
1831: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,

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

1825: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute14,
1826: l_PRICING_ATTR_rec.attribute14)
1827: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
1828: l_PRICING_ATTR_rec.attribute15)
1829: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
1830: l_PRICING_ATTR_rec.attribute2)
1831: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
1832: l_PRICING_ATTR_rec.attribute3)
1833: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,

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

1827: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute15,
1828: l_PRICING_ATTR_rec.attribute15)
1829: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
1830: l_PRICING_ATTR_rec.attribute2)
1831: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
1832: l_PRICING_ATTR_rec.attribute3)
1833: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
1834: l_PRICING_ATTR_rec.attribute4)
1835: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,

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

1829: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute2,
1830: l_PRICING_ATTR_rec.attribute2)
1831: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
1832: l_PRICING_ATTR_rec.attribute3)
1833: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
1834: l_PRICING_ATTR_rec.attribute4)
1835: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
1836: l_PRICING_ATTR_rec.attribute5)
1837: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,

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

1831: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute3,
1832: l_PRICING_ATTR_rec.attribute3)
1833: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
1834: l_PRICING_ATTR_rec.attribute4)
1835: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
1836: l_PRICING_ATTR_rec.attribute5)
1837: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
1838: l_PRICING_ATTR_rec.attribute6)
1839: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,

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

1833: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute4,
1834: l_PRICING_ATTR_rec.attribute4)
1835: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
1836: l_PRICING_ATTR_rec.attribute5)
1837: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
1838: l_PRICING_ATTR_rec.attribute6)
1839: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
1840: l_PRICING_ATTR_rec.attribute7)
1841: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,

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

1835: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute5,
1836: l_PRICING_ATTR_rec.attribute5)
1837: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
1838: l_PRICING_ATTR_rec.attribute6)
1839: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
1840: l_PRICING_ATTR_rec.attribute7)
1841: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
1842: l_PRICING_ATTR_rec.attribute8)
1843: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,

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

1837: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute6,
1838: l_PRICING_ATTR_rec.attribute6)
1839: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
1840: l_PRICING_ATTR_rec.attribute7)
1841: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
1842: l_PRICING_ATTR_rec.attribute8)
1843: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
1844: l_PRICING_ATTR_rec.attribute9)
1845: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,

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

1839: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute7,
1840: l_PRICING_ATTR_rec.attribute7)
1841: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
1842: l_PRICING_ATTR_rec.attribute8)
1843: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
1844: l_PRICING_ATTR_rec.attribute9)
1845: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
1846: l_PRICING_ATTR_rec.attribute_grouping_no)
1847: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,

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

1841: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute8,
1842: l_PRICING_ATTR_rec.attribute8)
1843: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
1844: l_PRICING_ATTR_rec.attribute9)
1845: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
1846: l_PRICING_ATTR_rec.attribute_grouping_no)
1847: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
1848: l_PRICING_ATTR_rec.context)
1849: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,

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

1843: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute9,
1844: l_PRICING_ATTR_rec.attribute9)
1845: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
1846: l_PRICING_ATTR_rec.attribute_grouping_no)
1847: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
1848: l_PRICING_ATTR_rec.context)
1849: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
1850: -- l_PRICING_ATTR_rec.created_by)
1851: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.creation_date),

Line 1849: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,

1845: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.attribute_grouping_no,
1846: l_PRICING_ATTR_rec.attribute_grouping_no)
1847: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
1848: l_PRICING_ATTR_rec.context)
1849: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
1850: -- l_PRICING_ATTR_rec.created_by)
1851: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.creation_date),
1852: -- trunc(l_PRICING_ATTR_rec.creation_date))
1853: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,

Line 1851: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.creation_date),

1847: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.context,
1848: l_PRICING_ATTR_rec.context)
1849: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
1850: -- l_PRICING_ATTR_rec.created_by)
1851: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.creation_date),
1852: -- trunc(l_PRICING_ATTR_rec.creation_date))
1853: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
1854: l_PRICING_ATTR_rec.excluder_flag)
1855: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,

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

1849: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.created_by,
1850: -- l_PRICING_ATTR_rec.created_by)
1851: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.creation_date),
1852: -- trunc(l_PRICING_ATTR_rec.creation_date))
1853: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
1854: l_PRICING_ATTR_rec.excluder_flag)
1855: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
1856: -- l_PRICING_ATTR_rec.last_updated_by)
1857: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.last_update_date),

Line 1855: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,

1851: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.creation_date),
1852: -- trunc(l_PRICING_ATTR_rec.creation_date))
1853: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
1854: l_PRICING_ATTR_rec.excluder_flag)
1855: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
1856: -- l_PRICING_ATTR_rec.last_updated_by)
1857: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.last_update_date),
1858: -- trunc(l_PRICING_ATTR_rec.last_update_date))
1859: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,

Line 1857: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.last_update_date),

1853: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
1854: l_PRICING_ATTR_rec.excluder_flag)
1855: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
1856: -- l_PRICING_ATTR_rec.last_updated_by)
1857: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.last_update_date),
1858: -- trunc(l_PRICING_ATTR_rec.last_update_date))
1859: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
1860: -- l_PRICING_ATTR_rec.last_update_login)
1861: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,

Line 1859: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,

1855: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_updated_by,
1856: -- l_PRICING_ATTR_rec.last_updated_by)
1857: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.last_update_date),
1858: -- trunc(l_PRICING_ATTR_rec.last_update_date))
1859: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
1860: -- l_PRICING_ATTR_rec.last_update_login)
1861: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
1862: l_PRICING_ATTR_rec.list_line_id)
1863: /* AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,

Line 1861: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,

1857: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.last_update_date),
1858: -- trunc(l_PRICING_ATTR_rec.last_update_date))
1859: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
1860: -- l_PRICING_ATTR_rec.last_update_login)
1861: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
1862: l_PRICING_ATTR_rec.list_line_id)
1863: /* AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
1864: l_PRICING_ATTR_rec.list_header_id)
1865: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,

Line 1863: /* AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,

1859: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.last_update_login,
1860: -- l_PRICING_ATTR_rec.last_update_login)
1861: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
1862: l_PRICING_ATTR_rec.list_line_id)
1863: /* AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
1864: l_PRICING_ATTR_rec.list_header_id)
1865: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
1866: l_PRICING_ATTR_rec.pricing_phase_id)*/
1867: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,

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

1861: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
1862: l_PRICING_ATTR_rec.list_line_id)
1863: /* AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
1864: l_PRICING_ATTR_rec.list_header_id)
1865: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
1866: l_PRICING_ATTR_rec.pricing_phase_id)*/
1867: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
1868: l_PRICING_ATTR_rec.pricing_attribute)
1869: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,

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

1863: /* AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_header_id,
1864: l_PRICING_ATTR_rec.list_header_id)
1865: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
1866: l_PRICING_ATTR_rec.pricing_phase_id)*/
1867: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
1868: l_PRICING_ATTR_rec.pricing_attribute)
1869: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
1870: l_PRICING_ATTR_rec.pricing_attribute_context)
1871: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,

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

1865: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_phase_id,
1866: l_PRICING_ATTR_rec.pricing_phase_id)*/
1867: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
1868: l_PRICING_ATTR_rec.pricing_attribute)
1869: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
1870: l_PRICING_ATTR_rec.pricing_attribute_context)
1871: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
1872: l_PRICING_ATTR_rec.pricing_attribute_id)
1873: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,

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

1867: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute,
1868: l_PRICING_ATTR_rec.pricing_attribute)
1869: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
1870: l_PRICING_ATTR_rec.pricing_attribute_context)
1871: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
1872: l_PRICING_ATTR_rec.pricing_attribute_id)
1873: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
1874: l_PRICING_ATTR_rec.pricing_attr_value_from)
1875: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,

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

1869: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,
1870: l_PRICING_ATTR_rec.pricing_attribute_context)
1871: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
1872: l_PRICING_ATTR_rec.pricing_attribute_id)
1873: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
1874: l_PRICING_ATTR_rec.pricing_attr_value_from)
1875: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
1876: l_PRICING_ATTR_rec.pricing_attr_value_to)
1877: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,

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

1871: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
1872: l_PRICING_ATTR_rec.pricing_attribute_id)
1873: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
1874: l_PRICING_ATTR_rec.pricing_attr_value_from)
1875: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
1876: l_PRICING_ATTR_rec.pricing_attr_value_to)
1877: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
1878: l_PRICING_ATTR_rec.product_attribute)
1879: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,

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

1873: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_from,
1874: l_PRICING_ATTR_rec.pricing_attr_value_from)
1875: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
1876: l_PRICING_ATTR_rec.pricing_attr_value_to)
1877: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
1878: l_PRICING_ATTR_rec.product_attribute)
1879: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
1880: l_PRICING_ATTR_rec.product_attribute_context)
1881: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,

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

1875: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attr_value_to,
1876: l_PRICING_ATTR_rec.pricing_attr_value_to)
1877: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
1878: l_PRICING_ATTR_rec.product_attribute)
1879: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
1880: l_PRICING_ATTR_rec.product_attribute_context)
1881: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
1882: l_PRICING_ATTR_rec.product_attr_value)
1883: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,

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

1877: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute,
1878: l_PRICING_ATTR_rec.product_attribute)
1879: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
1880: l_PRICING_ATTR_rec.product_attribute_context)
1881: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
1882: l_PRICING_ATTR_rec.product_attr_value)
1883: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
1884: l_PRICING_ATTR_rec.product_uom_code)
1885: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,

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

1879: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,
1880: l_PRICING_ATTR_rec.product_attribute_context)
1881: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
1882: l_PRICING_ATTR_rec.product_attr_value)
1883: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
1884: l_PRICING_ATTR_rec.product_uom_code)
1885: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
1886: -- l_PRICING_ATTR_rec.program_application_id)
1887: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,

Line 1885: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,

1881: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attr_value,
1882: l_PRICING_ATTR_rec.product_attr_value)
1883: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
1884: l_PRICING_ATTR_rec.product_uom_code)
1885: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
1886: -- l_PRICING_ATTR_rec.program_application_id)
1887: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
1888: -- l_PRICING_ATTR_rec.program_id)
1889: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.program_update_date),

Line 1887: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,

1883: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
1884: l_PRICING_ATTR_rec.product_uom_code)
1885: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
1886: -- l_PRICING_ATTR_rec.program_application_id)
1887: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
1888: -- l_PRICING_ATTR_rec.program_id)
1889: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.program_update_date),
1890: -- trunc(l_PRICING_ATTR_rec.program_update_date))
1891: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,

Line 1889: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.program_update_date),

1885: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_application_id,
1886: -- l_PRICING_ATTR_rec.program_application_id)
1887: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
1888: -- l_PRICING_ATTR_rec.program_id)
1889: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.program_update_date),
1890: -- trunc(l_PRICING_ATTR_rec.program_update_date))
1891: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
1892: l_PRICING_ATTR_rec.request_id)
1893: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,

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

1887: -- AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.program_id,
1888: -- l_PRICING_ATTR_rec.program_id)
1889: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.program_update_date),
1890: -- trunc(l_PRICING_ATTR_rec.program_update_date))
1891: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
1892: l_PRICING_ATTR_rec.request_id)
1893: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
1894: l_PRICING_ATTR_rec.comparison_operator_code)
1895: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,

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

1889: -- AND QP_GLOBALS.Equal(trunc(p_PRICING_ATTR_rec.program_update_date),
1890: -- trunc(l_PRICING_ATTR_rec.program_update_date))
1891: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
1892: l_PRICING_ATTR_rec.request_id)
1893: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
1894: l_PRICING_ATTR_rec.comparison_operator_code)
1895: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
1896: l_PRICING_ATTR_rec.pricing_attribute_datatype)
1897: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,

Line 1895: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,

1891: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.request_id,
1892: l_PRICING_ATTR_rec.request_id)
1893: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
1894: l_PRICING_ATTR_rec.comparison_operator_code)
1895: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
1896: l_PRICING_ATTR_rec.pricing_attribute_datatype)
1897: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
1898: l_PRICING_ATTR_rec.product_attribute_datatype)
1899: THEN

Line 1897: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,

1893: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.comparison_operator_code,
1894: l_PRICING_ATTR_rec.comparison_operator_code)
1895: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_datatype,
1896: l_PRICING_ATTR_rec.pricing_attribute_datatype)
1897: AND QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_datatype,
1898: l_PRICING_ATTR_rec.product_attribute_datatype)
1899: THEN
1900:
1901: -- Row has not changed. Set out parameter.

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

1977: BEGIN
1978:
1979: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
1980: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
1981: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
1982: p_old_PRICING_ATTR_rec.accumulate_flag)
1983: THEN
1984: l_PRICING_ATTR_val_rec.accumulate := QP_Id_To_Value.Accumulate
1985: ( p_accumulate_flag => p_PRICING_ATTR_rec.accumulate_flag

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

1987: END IF;
1988:
1989: IF p_PRICING_ATTR_rec.excluder_flag IS NOT NULL AND
1990: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
1991: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
1992: p_old_PRICING_ATTR_rec.excluder_flag)
1993: THEN
1994: l_PRICING_ATTR_val_rec.excluder := QP_Id_To_Value.Excluder
1995: ( p_excluder_flag => p_PRICING_ATTR_rec.excluder_flag

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

1997: END IF;
1998:
1999: IF p_PRICING_ATTR_rec.list_line_id IS NOT NULL AND
2000: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND
2001: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2002: p_old_PRICING_ATTR_rec.list_line_id)
2003: THEN
2004: l_PRICING_ATTR_val_rec.list_line := QP_Id_To_Value.List_Line
2005: ( p_list_line_id => p_PRICING_ATTR_rec.list_line_id

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

2007: END IF;
2008:
2009: /* IF p_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL AND
2010: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND
2011: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2012: p_old_PRICING_ATTR_rec.pricing_attribute_id)
2013: THEN
2014: l_PRICING_ATTR_val_rec.pricing_attribute := QP_Id_To_Value.Pricing_Attribute
2015: ( p_pricing_attribute_id => p_PRICING_ATTR_rec.pricing_attribute_id

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

2017: END IF;
2018: */
2019: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
2020: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND
2021: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2022: p_old_PRICING_ATTR_rec.product_uom_code)
2023: THEN
2024: l_PRICING_ATTR_val_rec.product_uom := QP_Id_To_Value.Product_Uom
2025: ( p_product_uom_code => p_PRICING_ATTR_rec.product_uom_code

Line 2288: IF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE)

2284:
2285: oe_debug_pub.Add('Entering QP_pll_PRICING_ATTR_Util.pre_write_process', 1);
2286:
2287: --Bug 2807015. Added following code to update pricing attributes when the PA is changed in PLL.
2288: IF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE)
2289: THEN
2290: IF ((p_old_PRICING_ATTR_rec.product_attribute <> p_PRICING_ATTR_rec.product_attribute) OR
2291: (p_old_PRICING_ATTR_rec.product_attr_value <> p_PRICING_ATTR_rec.product_attr_value))
2292: THEN

Line 2304: ELSIF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE ) THEN

2300: null;
2301: end;
2302: END IF;
2303:
2304: ELSIF ( p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE ) THEN
2305: begin
2306: update qp_pricing_attributes
2307: set product_attribute = p_PRICING_ATTR_rec.product_attribute
2308: , product_attr_value = p_PRICING_ATTR_rec.product_attr_value

Line 2321: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,

2317: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2318:
2319: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);
2320: qp_delayed_requests_PVT.log_request(
2321: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
2322: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2323: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
2324: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2325: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 2323: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,

2319: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);
2320: qp_delayed_requests_PVT.log_request(
2321: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
2322: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2323: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
2324: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2325: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2326: x_return_status => l_return_status);
2327: END IF;

Line 2325: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

2321: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
2322: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2323: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
2324: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
2325: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2326: x_return_status => l_return_status);
2327: END IF;
2328: -- pattern
2329: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN

Line 2332: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2328: -- pattern
2329: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2330: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2331: qp_delayed_requests_pvt.log_request(
2332: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2333: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2334: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2335: p_request_unique_key2 => 'I',
2336: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2336: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2332: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2333: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2334: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2335: p_request_unique_key2 => 'I',
2336: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2337: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2338: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2339: x_return_status => l_return_status);
2340:

Line 2338: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2334: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2335: p_request_unique_key2 => 'I',
2336: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2337: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2338: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2339: x_return_status => l_return_status);
2340:
2341: END IF;
2342: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

Line 2344: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2340:
2341: END IF;
2342: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2343: qp_delayed_requests_pvt.log_request(
2344: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2345: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2346: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2347: p_request_unique_key2 => 'U',
2348: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2348: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2344: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2345: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2346: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2347: p_request_unique_key2 => 'U',
2348: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2349: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2350: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2351: x_return_status => l_return_status);
2352: END IF;

Line 2350: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2346: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2347: p_request_unique_key2 => 'U',
2348: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2349: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2350: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2351: x_return_status => l_return_status);
2352: END IF;
2353: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2354: qp_delayed_requests_pvt.log_request(

Line 2355: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2351: x_return_status => l_return_status);
2352: END IF;
2353: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2354: qp_delayed_requests_pvt.log_request(
2355: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2356: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2357: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2358: p_request_unique_key2 => 'D',
2359: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 2359: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2355: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2356: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2357: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2358: p_request_unique_key2 => 'D',
2359: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2360: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2361: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2362: x_return_status => l_return_status);
2363: END IF;

Line 2361: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,

2357: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2358: p_request_unique_key2 => 'D',
2359: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2360: p_requesting_entity_id => p_PRICING_ATTR_rec.list_header_id,
2361: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2362: x_return_status => l_return_status);
2363: END IF;
2364: END IF; --Java Engine Installed
2365: -- pattern