DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on QP_UTIL_PUB

Line 5680: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

5676:
5677: QP_ATTR_MAPPING_ERROR Exception;
5678: l_completely_frozen BOOLEAN := TRUE;
5679:
5680: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
5681: l_pass_all_lines VARCHAR2(30);
5682: l_exists_phase VARCHAR2(1) := 'N';
5683: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
5684: j PLS_INTEGER :=1;

Line 5742: -- QP_UTIL_PUB.Get_Order_Lines_Status

5738:
5739: -- bug 9728497 start
5740: -- modified below for p_x_new_line_rec.header_id and p_x_new_line_rec.line_id
5741: -- being passed on to call the overloaded function.
5742: -- QP_UTIL_PUB.Get_Order_Lines_Status
5743: -- (p_control_rec.pricing_event,l_order_status_rec);
5744: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => p_control_rec.pricing_event,
5745: p_header_id => p_header_id,
5746: p_line_id => p_Line_id,

Line 5744: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => p_control_rec.pricing_event,

5740: -- modified below for p_x_new_line_rec.header_id and p_x_new_line_rec.line_id
5741: -- being passed on to call the overloaded function.
5742: -- QP_UTIL_PUB.Get_Order_Lines_Status
5743: -- (p_control_rec.pricing_event,l_order_status_rec);
5744: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => p_control_rec.pricing_event,
5745: p_header_id => p_header_id,
5746: p_line_id => p_Line_id,
5747: x_order_status_rec =>l_order_status_rec);
5748: -- bug 9728497 end

Line 8598: QP_UTIL_PUB.round_price

8594: oe_debug_pub.add('xFinal Range break adj amt:'||p_line_adj_tbl(j).adjusted_amount_per_pqty);
8595: End If;
8596:
8597: If p_Line_Adj_Tbl(j).operand is not null Then
8598: QP_UTIL_PUB.round_price
8599: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount_per_pqty,
8600: p_rounding_factor => NULL,
8601: p_use_multi_currency => 'Y',
8602: p_price_list_id => p_line_tbl(i).price_list_id,

Line 8680: /* QP_UTIL_PUB.round_price

8676: adj_debug('+Adjusted_Amount '||p_Line_Adj_Tbl(j).Adjusted_Amount,2);
8677:
8678: If p_Line_Adj_Tbl(j).operand is not null Then
8679: --commenting call to round price to fix bug 3043251
8680: /* QP_UTIL_PUB.round_price
8681: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount_per_pqty,
8682: p_rounding_factor => NULL,
8683: p_use_multi_currency => 'Y',
8684: p_price_list_id => p_line_tbl(i).price_list_id,

Line 8807: QP_UTIL_PUB.round_price

8803:
8804: END IF;
8805: -- uom end
8806: IF nvl(p_line_adj_tbl(j).adjusted_amount_per_pqty,0) <> 0 Then
8807: QP_UTIL_PUB.round_price
8808: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount_per_pqty,
8809: p_rounding_factor => NULL,
8810: p_use_multi_currency => 'Y',
8811: p_price_list_id => p_line_tbl(i).price_list_id,

Line 8822: QP_UTIL_PUB.round_price

8818:
8819: END If;
8820:
8821: IF nvl(p_line_adj_tbl(j).adjusted_amount,0) <> 0 Then
8822: QP_UTIL_PUB.round_price
8823: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount,
8824: p_rounding_factor => NULL,
8825: p_use_multi_currency => 'Y',
8826: p_price_list_id => p_line_tbl(i).price_list_id,

Line 10276: adj_debug(' Values passed into QP_UTIL_PUB.round_price api:');

10272:
10273: -- uom end
10274:
10275:
10276: adj_debug(' Values passed into QP_UTIL_PUB.round_price api:');
10277: adj_debug(' p_operand:'||l_line_tbl(i).unit_selling_price);
10278: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
10279: adj_debug(' currency_code:'||g_order_currency);
10280: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);

Line 10282: QP_UTIL_PUB.round_price(p_operand => l_line_tbl(i).unit_selling_price,

10278: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
10279: adj_debug(' currency_code:'||g_order_currency);
10280: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);
10281: If l_line_tbl(i).unit_selling_price is not null Then
10282: QP_UTIL_PUB.round_price(p_operand => l_line_tbl(i).unit_selling_price,
10283: p_rounding_factor => NULL,
10284: p_use_multi_currency => 'Y',
10285: p_price_list_id => l_line_tbl(i).price_list_id,
10286: p_currency_code => g_order_currency,

Line 11126: IF (G_11IG_PERFORMANCE = 'Y' AND QP_UTIL_PUB.Basic_Pricing_Setup = 'Y'

11122: close unfrozen_lines;
11123: END IF;
11124: -- End 2378843
11125:
11126: IF (G_11IG_PERFORMANCE = 'Y' AND QP_UTIL_PUB.Basic_Pricing_Setup = 'Y'
11127: AND Not Bypass_Performance_Path( p_header_id => p_header_id
11128: , p_line_id => p_line_id
11129: , px_line_Tbl => x_line_tbl))
11130: OR OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

Line 11292: QP_UTIL_PUB.Basic_Pricing_Setup = 'Y' AND

11288:
11289: IF (OE_GLOBALS.G_ASO_INSTALLED = 'N' AND
11290: OE_GLOBALS.G_GMI_INSTALLED = 'N' AND -- OPM 2547940
11291: G_11IG_PERFORMANCE = 'Y' AND
11292: QP_UTIL_PUB.Basic_Pricing_Setup = 'Y' AND
11293: nvl(p_request_rec.param1,'XX') <> 'UI') OR
11294: OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
11295: THEN
11296: l_price_control_rec.p_request_type_code:=p_request_type_code;

Line 11511: adj_debug(' Values passed into QP_UTIL_PUB.round_price api:');

11507: -- commented the assigment below and included above to fix bug 2595626
11508: -- g_order_currency := l_header_rec.transactional_curr_code;
11509:
11510:
11511: adj_debug(' Values passed into QP_UTIL_PUB.round_price api:');
11512: adj_debug(' p_operand:'||l_line_tbl(i).unit_selling_price);
11513: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
11514: adj_debug(' currency_code:'||l_header_rec.transactional_curr_code);
11515: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);

Line 11516: QP_UTIL_PUB.round_price(p_operand => l_line_tbl(i).unit_selling_price,

11512: adj_debug(' p_operand:'||l_line_tbl(i).unit_selling_price);
11513: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
11514: adj_debug(' currency_code:'||l_header_rec.transactional_curr_code);
11515: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);
11516: QP_UTIL_PUB.round_price(p_operand => l_line_tbl(i).unit_selling_price,
11517: p_rounding_factor => NULL,
11518: p_use_multi_currency => 'Y',
11519: p_price_list_id => l_line_tbl(i).price_list_id,
11520: p_currency_code => l_header_rec.transactional_curr_code,

Line 11632: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

11628: l_delimiter2 number;
11629: l_delimiter number;
11630: l_booked_flag varchar2(1);
11631: l_multiple_events Varchar2(1);
11632: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
11633: l_prev_line_hdr_id Number;
11634: l_locked_header_rec OE_ORDER_PUB.Header_Rec_Type; --13727700
11635:
11636: cursor has_prg_lines(p_line_id IN NUMBER) is

Line 12032: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

12028: l_delimiter2 number;
12029: l_delimiter number;
12030: l_booked_flag varchar2(1);
12031: l_multiple_events Varchar2(1);
12032: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
12033:
12034: cursor has_prg_lines(p_line_id IN NUMBER) is
12035: Select 'Y'
12036: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b

Line 12717: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

12713: l_check_line_flag varchar2(1); --5598523
12714: l_line_index NUMBER := 0;
12715: l_line_attr_index number:=0;
12716: --bug 3531938
12717: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
12718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12719:
12720: l_manual_all_lines_status Varchar2(1); --bug 7600510
12721:

Line 12767: -- QP_UTIL_PUB.Get_Order_Lines_Status('BATCH',l_order_status_rec);

12763: --bug 3531938 calling qp api to determine whether to pass all lines
12764: -- bug 9728497 start
12765: -- modified below for p_x_new_line_rec.header_id and p_x_new_line_rec.line_id
12766: -- being passed on to call the overloaded function.
12767: -- QP_UTIL_PUB.Get_Order_Lines_Status('BATCH',l_order_status_rec);
12768: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => 'BATCH',
12769: p_header_id => p_header_id,
12770: p_line_id => p_Line_id,
12771: x_order_status_rec =>l_order_status_rec);

Line 12768: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => 'BATCH',

12764: -- bug 9728497 start
12765: -- modified below for p_x_new_line_rec.header_id and p_x_new_line_rec.line_id
12766: -- being passed on to call the overloaded function.
12767: -- QP_UTIL_PUB.Get_Order_Lines_Status('BATCH',l_order_status_rec);
12768: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => 'BATCH',
12769: p_header_id => p_header_id,
12770: p_line_id => p_Line_id,
12771: x_order_status_rec =>l_order_status_rec);
12772: -- bug 9728497 end

Line 12785: QP_UTIL_PUB.Get_Manual_All_Lines_Status ('BATCH', l_manual_all_lines_status ) ;

12781: oe_debug_pub.add(' p_level '||p_level);
12782: oe_debug_pub.add(' Check for Manual Advanced modifiers ',3);
12783: --- bug# 7600510 Start
12784: -- GET_MANUAL_ADV_STATUS('BATCH');
12785: QP_UTIL_PUB.Get_Manual_All_Lines_Status ('BATCH', l_manual_all_lines_status ) ;
12786: OE_GLOBALS.G_MANUAL_ADV_MODIFIER := l_manual_all_lines_status;
12787: --- bug# 7600510 End
12788: oe_debug_pub.add(' manual_adv_modifier 2 '||OE_GLOBALS.G_MANUAL_ADV_MODIFIER);
12789: END IF;