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_DENORMALIZED_PRICING_ATTRS dependencies on QP_DENORMALIZED_PRICING_ATTRS

Line 1: PACKAGE BODY QP_Denormalized_Pricing_Attrs AS

1: PACKAGE BODY QP_Denormalized_Pricing_Attrs AS
2: /* $Header: QPXDNPAB.pls 120.2.12020000.2 2012/12/13 06:51:39 kdurgasi ship $ */
3:
4: --Procedure to update the distinct row-count of pricing attributes per
5: --list_header_id

Line 22: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :PREPARE_INPUT_DATA');

18: l_list_header_id_tbl num_type;
19: l_list_header_id_low NUMBER;
20: l_list_header_id_high NUMBER;
21: BEGIN
22: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :PREPARE_INPUT_DATA');
23: --Order the parameters and get correct values if null
24: IF p_list_header_id_low IS NULL AND p_list_header_id_high IS NULL THEN
25: BEGIN
26: SELECT min(list_header_id), max(list_header_id)

Line 86: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :UPDATE_SEARCH_IND');

82: l_list_header_id_tbl := p_list_header_id_tbl;
83: l_list_header_id_low := p_list_header_id_low;
84: l_list_header_id_high := p_list_header_id_high;
85:
86: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :UPDATE_SEARCH_IND');
87: --Update Distinct_Row_Count for factor pricing attributes
88: QP_Denormalized_Pricing_Attrs.Update_Row_Count(l_list_header_id_low, l_list_header_id_high);
89:
90: --Set the format mask for the canonical form of numbers

Line 88: QP_Denormalized_Pricing_Attrs.Update_Row_Count(l_list_header_id_low, l_list_header_id_high);

84: l_list_header_id_high := p_list_header_id_high;
85:
86: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :UPDATE_SEARCH_IND');
87: --Update Distinct_Row_Count for factor pricing attributes
88: QP_Denormalized_Pricing_Attrs.Update_Row_Count(l_list_header_id_low, l_list_header_id_high);
89:
90: --Set the format mask for the canonical form of numbers
91: --fnd_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';
92:

Line 176: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :UPDATE_SEARCH_IND -called from Concurrent Program');

172: l_list_header_id_high NUMBER;
173: BEGIN
174: l_list_header_id_low := p_list_header_id_low;
175: l_list_header_id_high := p_list_header_id_high;
176: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :UPDATE_SEARCH_IND -called from Concurrent Program');
177: QP_Denormalized_Pricing_Attrs.PREPARE_INPUT_DATA(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
178:
179: QP_Denormalized_Pricing_Attrs.UPDATE_SEARCH_IND(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
180:

Line 177: QP_Denormalized_Pricing_Attrs.PREPARE_INPUT_DATA(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);

173: BEGIN
174: l_list_header_id_low := p_list_header_id_low;
175: l_list_header_id_high := p_list_header_id_high;
176: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :UPDATE_SEARCH_IND -called from Concurrent Program');
177: QP_Denormalized_Pricing_Attrs.PREPARE_INPUT_DATA(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
178:
179: QP_Denormalized_Pricing_Attrs.UPDATE_SEARCH_IND(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
180:
181: END UPDATE_SEARCH_IND;

Line 179: QP_Denormalized_Pricing_Attrs.UPDATE_SEARCH_IND(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);

175: l_list_header_id_high := p_list_header_id_high;
176: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :UPDATE_SEARCH_IND -called from Concurrent Program');
177: QP_Denormalized_Pricing_Attrs.PREPARE_INPUT_DATA(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
178:
179: QP_Denormalized_Pricing_Attrs.UPDATE_SEARCH_IND(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
180:
181: END UPDATE_SEARCH_IND;
182: /* End Bug -7309559 */
183:

Line 188: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Update_Row_Count');

184: PROCEDURE Update_Row_Count(p_list_header_id_low IN NUMBER,
185: p_list_header_id_high IN NUMBER)
186: IS
187: BEGIN
188: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Update_Row_Count');
189: --Do this only for factor list attributes
190: -- Added the hint inside the subquery for bug#3993301
191: UPDATE qp_pricing_attributes a
192: SET a.distinct_row_count =

Line 222: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Populate_Factor_List_Attrs');

218: l_perf varchar2(30);
219: BEGIN
220: l_perf := nvl(FND_PROFILE.VALUE(g_perf), g_off);
221: if (l_perf = g_off) then
222: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Populate_Factor_List_Attrs');
223: --Order the parameters and get correct values if null
224: IF p_list_header_id_low IS NULL AND p_list_header_id_high IS NULL THEN
225: BEGIN
226: SELECT min(list_header_id), max(list_header_id)

Line 290: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Update_Pricing_Attributes');

286:
287: l_list_header_id_low := p_list_header_id_low;
288: l_list_header_id_high := p_list_header_id_high;
289:
290: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Update_Pricing_Attributes');
291:
292: /*Added for bug# 7143714 for performance contrrol*/
293: QP_Denormalized_Pricing_Attrs.PREPARE_INPUT_DATA(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
294:

Line 293: QP_Denormalized_Pricing_Attrs.PREPARE_INPUT_DATA(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);

289:
290: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Update_Pricing_Attributes');
291:
292: /*Added for bug# 7143714 for performance contrrol*/
293: QP_Denormalized_Pricing_Attrs.PREPARE_INPUT_DATA(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
294:
295: l_perf := nvl(FND_PROFILE.VALUE(g_perf), g_off);
296:
297: OE_DEBUG_PUB.ADD('PErformance Control Profile is '||l_perf);

Line 300: QP_Denormalized_Pricing_Attrs.UPDATE_SEARCH_IND(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);

296:
297: OE_DEBUG_PUB.ADD('PErformance Control Profile is '||l_perf);
298:
299: if (l_perf = g_off) then
300: QP_Denormalized_Pricing_Attrs.UPDATE_SEARCH_IND(err_buff,retcode,l_list_header_id_low,l_list_header_id_high,l_list_header_id_tbl,p_update_type);
301: --end if;
302: /*End Bug 7309559*/
303:
304: --Update the pattern_value_from and pattern_value_to columns with canonical

Line 459: END QP_Denormalized_Pricing_Attrs;

455: RAISE;
456:
457: END Update_Pricing_Attributes;
458:
459: END QP_Denormalized_Pricing_Attrs;