DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on QP_UTIL_PUB

Line 5597: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

5593:
5594: QP_ATTR_MAPPING_ERROR Exception;
5595: l_completely_frozen BOOLEAN := TRUE;
5596:
5597: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
5598: l_pass_all_lines VARCHAR2(30);
5599: l_exists_phase VARCHAR2(1) := 'N';
5600: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
5601: j PLS_INTEGER :=1;

Line 5656: QP_UTIL_PUB.Get_Order_Lines_Status

5652: G_STMT_NO := 'calculate_adjustments#40';
5653:
5654: oe_debug_pub.add('Passed in event code:'||p_control_rec.pricing_event);
5655:
5656: QP_UTIL_PUB.Get_Order_Lines_Status
5657: (p_control_rec.pricing_event,l_order_status_rec);
5658:
5659: oe_debug_pub.add('Pricing Engine return pass all_lines value:'||l_order_status_rec.ALL_LINES_FLAG);
5660: oe_debug_pub.add('Pricing Engine return pass changed line value:'||l_order_status_rec.Changed_Lines_Flag);

Line 8506: QP_UTIL_PUB.round_price

8502: oe_debug_pub.add('xFinal Range break adj amt:'||p_line_adj_tbl(j).adjusted_amount_per_pqty);
8503: End If;
8504:
8505: If p_Line_Adj_Tbl(j).operand is not null Then
8506: QP_UTIL_PUB.round_price
8507: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount_per_pqty,
8508: p_rounding_factor => NULL,
8509: p_use_multi_currency => 'Y',
8510: p_price_list_id => p_line_tbl(i).price_list_id,

Line 8588: /* QP_UTIL_PUB.round_price

8584: adj_debug('+Adjusted_Amount '||p_Line_Adj_Tbl(j).Adjusted_Amount,2);
8585:
8586: If p_Line_Adj_Tbl(j).operand is not null Then
8587: --commenting call to round price to fix bug 3043251
8588: /* QP_UTIL_PUB.round_price
8589: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount_per_pqty,
8590: p_rounding_factor => NULL,
8591: p_use_multi_currency => 'Y',
8592: p_price_list_id => p_line_tbl(i).price_list_id,

Line 8715: QP_UTIL_PUB.round_price

8711:
8712: END IF;
8713: -- uom end
8714: IF nvl(p_line_adj_tbl(j).adjusted_amount_per_pqty,0) <> 0 Then
8715: QP_UTIL_PUB.round_price
8716: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount_per_pqty,
8717: p_rounding_factor => NULL,
8718: p_use_multi_currency => 'Y',
8719: p_price_list_id => p_line_tbl(i).price_list_id,

Line 8730: QP_UTIL_PUB.round_price

8726:
8727: END If;
8728:
8729: IF nvl(p_line_adj_tbl(j).adjusted_amount,0) <> 0 Then
8730: QP_UTIL_PUB.round_price
8731: (p_operand => p_Line_Adj_Tbl(j).adjusted_amount,
8732: p_rounding_factor => NULL,
8733: p_use_multi_currency => 'Y',
8734: p_price_list_id => p_line_tbl(i).price_list_id,

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

10181:
10182: -- uom end
10183:
10184:
10185: adj_debug(' Values passed into QP_UTIL_PUB.round_price api:');
10186: adj_debug(' p_operand:'||l_line_tbl(i).unit_selling_price);
10187: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
10188: adj_debug(' currency_code:'||g_order_currency);
10189: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);

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

10187: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
10188: adj_debug(' currency_code:'||g_order_currency);
10189: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);
10190: If l_line_tbl(i).unit_selling_price is not null Then
10191: QP_UTIL_PUB.round_price(p_operand => l_line_tbl(i).unit_selling_price,
10192: p_rounding_factor => NULL,
10193: p_use_multi_currency => 'Y',
10194: p_price_list_id => l_line_tbl(i).price_list_id,
10195: p_currency_code => g_order_currency,

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

11014: close unfrozen_lines;
11015: END IF;
11016: -- End 2378843
11017:
11018: IF (G_11IG_PERFORMANCE = 'Y' AND QP_UTIL_PUB.Basic_Pricing_Setup = 'Y'
11019: AND Not Bypass_Performance_Path( p_header_id => p_header_id
11020: , p_line_id => p_line_id
11021: , px_line_Tbl => x_line_tbl))
11022: OR OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

Line 11184: QP_UTIL_PUB.Basic_Pricing_Setup = 'Y' AND

11180:
11181: IF (OE_GLOBALS.G_ASO_INSTALLED = 'N' AND
11182: OE_GLOBALS.G_GMI_INSTALLED = 'N' AND -- OPM 2547940
11183: G_11IG_PERFORMANCE = 'Y' AND
11184: QP_UTIL_PUB.Basic_Pricing_Setup = 'Y' AND
11185: nvl(p_request_rec.param1,'XX') <> 'UI') OR
11186: OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
11187: THEN
11188: l_price_control_rec.p_request_type_code:=p_request_type_code;

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

11399: -- commented the assigment below and included above to fix bug 2595626
11400: -- g_order_currency := l_header_rec.transactional_curr_code;
11401:
11402:
11403: adj_debug(' Values passed into QP_UTIL_PUB.round_price api:');
11404: adj_debug(' p_operand:'||l_line_tbl(i).unit_selling_price);
11405: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
11406: adj_debug(' currency_code:'||l_header_rec.transactional_curr_code);
11407: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);

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

11404: adj_debug(' p_operand:'||l_line_tbl(i).unit_selling_price);
11405: adj_debug(' price_list_id:'||l_line_tbl(i).price_list_id);
11406: adj_debug(' currency_code:'||l_header_rec.transactional_curr_code);
11407: adj_debug(' pricing_effective_date:'||l_line_tbl(i).pricing_date);
11408: QP_UTIL_PUB.round_price(p_operand => l_line_tbl(i).unit_selling_price,
11409: p_rounding_factor => NULL,
11410: p_use_multi_currency => 'Y',
11411: p_price_list_id => l_line_tbl(i).price_list_id,
11412: p_currency_code => l_header_rec.transactional_curr_code,

Line 11524: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

11520: l_delimiter2 number;
11521: l_delimiter number;
11522: l_booked_flag varchar2(1);
11523: l_multiple_events Varchar2(1);
11524: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
11525: l_prev_line_hdr_id Number;
11526:
11527: cursor has_prg_lines(p_line_id IN NUMBER) is
11528: Select 'Y'

Line 11892: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

11888: l_delimiter2 number;
11889: l_delimiter number;
11890: l_booked_flag varchar2(1);
11891: l_multiple_events Varchar2(1);
11892: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
11893:
11894: cursor has_prg_lines(p_line_id IN NUMBER) is
11895: Select 'Y'
11896: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b

Line 12562: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

12558: l_check_line_flag varchar2(1); --5598523
12559: l_line_index NUMBER := 0;
12560: l_line_attr_index number:=0;
12561: --bug 3531938
12562: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
12563: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12564:
12565: l_manual_all_lines_status Varchar2(1); --bug 7600510
12566:

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

12605: --to pricing engine
12606: --In the case of order level manual adjustments we will always pass in
12607: --all the lines regardless of profile_value
12608: --bug 3531938 calling qp api to determine whether to pass all lines
12609: QP_UTIL_PUB.Get_Order_Lines_Status('BATCH',l_order_status_rec);
12610:
12611: oe_debug_pub.add(' All_lines_flag returned from pricing:'||l_order_status_rec.all_lines_flag);
12612: -- bug 6817566
12613: oe_debug_pub.add(' manual_adv_modifier '||OE_GLOBALS.G_MANUAL_ADV_MODIFIER);

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

12617: oe_debug_pub.add(' p_level '||p_level);
12618: oe_debug_pub.add(' Check for Manual Advanced modifiers ',3);
12619: --- bug# 7600510 Start
12620: -- GET_MANUAL_ADV_STATUS('BATCH');
12621: QP_UTIL_PUB.Get_Manual_All_Lines_Status ('BATCH', l_manual_all_lines_status ) ;
12622: OE_GLOBALS.G_MANUAL_ADV_MODIFIER := l_manual_all_lines_status;
12623: --- bug# 7600510 End
12624: oe_debug_pub.add(' manual_adv_modifier 2 '||OE_GLOBALS.G_MANUAL_ADV_MODIFIER);
12625: END IF;