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.OE_CHARGE_PVT dependencies on OE_ORDER_PUB

Line 238: l_line_rec OE_Order_PUB.Line_Rec_Type;

234: )RETURN VARCHAR2
235: IS
236: l_api_version_number CONSTANT NUMBER := 1.0;
237: l_api_name CONSTANT VARCHAR2(30):= 'Get_Cost_Amount';
238: l_line_rec OE_Order_PUB.Line_Rec_Type;
239: l_cost_amount NUMBER := 0.0;
240: --
241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
242: --

Line 250: l_line_rec := OE_ORDER_PUB.G_LINE;

246: oe_debug_pub.add( 'CHARGES:INSIDE GET COST AMOUNT FOR' || P_COST_TYPE_CODE , 1 ) ;
247: END IF;
248:
249: -- Get the Line record from the Global Record
250: l_line_rec := OE_ORDER_PUB.G_LINE;
251:
252: -- Validate the Line_id.
253:
254: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM

Line 374: l_line_rec OE_Order_PUB.Line_Rec_Type;

370: l_api_name CONSTANT VARCHAR2(30):= 'Get_Cost_Types';
371: l_cost_tbl QP_Attr_Mapping_PUB.t_MultiRecord;
372: l_cost_type_code VARCHAR2(30) := NULL;
373: l_count NUMBER := 0;
374: l_line_rec OE_Order_PUB.Line_Rec_Type;
375: Cursor C_Get_Cost_Types(p_line_id NUMBER) IS
376: SELECT DISTINCT CHARGE_TYPE_CODE
377: FROM OE_PRICE_ADJUSTMENTS_V
378: WHERE LINE_ID = p_line_id

Line 389: l_line_rec := OE_ORDER_PUB.G_LINE;

385: IF l_debug_level > 0 THEN
386: oe_debug_pub.add( 'INSIDE GET COST TYPE' , 1 ) ;
387: END IF;
388: -- Get the Line record from the Global Record
389: l_line_rec := OE_ORDER_PUB.G_LINE;
390:
391: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
392: THEN
393: RETURN l_cost_tbl;

Line 464: l_line_rec OE_Order_PUB.Line_Rec_Type;

460: RETURN VARCHAR2
461: IS
462: l_api_name CONSTANT VARCHAR2(30):= 'Get_Shipped_Status';
463: l_result VARCHAR2(1) := 'N';
464: l_line_rec OE_Order_PUB.Line_Rec_Type;
465: --
466: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
467: --
468: BEGIN

Line 471: l_line_rec := OE_ORDER_PUB.G_LINE;

467: --
468: BEGIN
469:
470: -- Get the Line record from the Global Record
471: l_line_rec := OE_ORDER_PUB.G_LINE;
472:
473: IF l_line_rec.shippable_flag = 'Y'AND
474: l_line_rec.shipped_quantity > 0
475: THEN

Line 496: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type

492: END Get_Shipped_Status;
493:
494: PROCEDURE Check_Duplicate_Line_Charges
495: (
496: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
497: , p_x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
498: , p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
499: )
500:

Line 497: , p_x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

493:
494: PROCEDURE Check_Duplicate_Line_Charges
495: (
496: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
497: , p_x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
498: , p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
499: )
500:
501: IS

Line 498: , p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type

494: PROCEDURE Check_Duplicate_Line_Charges
495: (
496: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
497: , p_x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
498: , p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
499: )
500:
501: IS
502: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type := p_x_line_adj_tbl;

Line 502: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type := p_x_line_adj_tbl;

498: , p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
499: )
500:
501: IS
502: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type := p_x_line_adj_tbl;
503: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type := p_x_line_adj_att_tbl;
504: l_line_index NUMBER := 0;
505: l_charge_index NUMBER := 0;
506: l_tmp_index NUMBER := 0;

Line 503: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type := p_x_line_adj_att_tbl;

499: )
500:
501: IS
502: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type := p_x_line_adj_tbl;
503: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type := p_x_line_adj_att_tbl;
504: l_line_index NUMBER := 0;
505: l_charge_index NUMBER := 0;
506: l_tmp_index NUMBER := 0;
507: l_att_index NUMBER := 0;

Line 665: p_header_rec IN OE_Order_PUB.Header_Rec_Type

661:
662:
663: PROCEDURE Check_Duplicate_Header_Charges
664: (
665: p_header_rec IN OE_Order_PUB.Header_Rec_Type
666: , p_x_Header_adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
667: , p_x_Header_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
668: )
669:

Line 666: , p_x_Header_adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

662:
663: PROCEDURE Check_Duplicate_Header_Charges
664: (
665: p_header_rec IN OE_Order_PUB.Header_Rec_Type
666: , p_x_Header_adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
667: , p_x_Header_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
668: )
669:
670: IS

Line 667: , p_x_Header_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type

663: PROCEDURE Check_Duplicate_Header_Charges
664: (
665: p_header_rec IN OE_Order_PUB.Header_Rec_Type
666: , p_x_Header_adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
667: , p_x_Header_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
668: )
669:
670: IS
671: l_Header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := p_x_Header_adj_tbl;

Line 671: l_Header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := p_x_Header_adj_tbl;

667: , p_x_Header_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
668: )
669:
670: IS
671: l_Header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := p_x_Header_adj_tbl;
672: l_Header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type := p_x_Header_adj_att_tbl;
673: l_Header_id NUMBER := 0;
674: l_charge_index NUMBER := 0;
675: l_tmp_index NUMBER := 0;

Line 672: l_Header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type := p_x_Header_adj_att_tbl;

668: )
669:
670: IS
671: l_Header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := p_x_Header_adj_tbl;
672: l_Header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type := p_x_Header_adj_att_tbl;
673: l_Header_id NUMBER := 0;
674: l_charge_index NUMBER := 0;
675: l_tmp_index NUMBER := 0;
676: l_att_index NUMBER := 0;

Line 785: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;

781: , x_duplicate_flag OUT NOCOPY VARCHAR2
782:
783: )
784: IS
785: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
786: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
787: l_duplicate_flag VARCHAR2(1) := 'N';
788: l_count NUMBER;
789: --

Line 786: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;

782:
783: )
784: IS
785: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
786: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
787: l_duplicate_flag VARCHAR2(1) := 'N';
788: l_count NUMBER;
789: --
790: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 902: l_line_rec OE_Order_PUB.Line_Rec_Type;

898: FUNCTION Get_Line_Weight_Or_Volume
899: ( p_uom_class IN VARCHAR2)
900: RETURN VARCHAR2
901: IS
902: l_line_rec OE_Order_PUB.Line_Rec_Type;
903: l_uom_code VARCHAR2(3);
904: l_uom_rate NUMBER;
905: --
906: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 919: l_line_rec := OE_ORDER_PUB.G_LINE;

915: RETURN NULL;
916: END IF;
917:
918: -- Get the Line record from the Global Record
919: l_line_rec := OE_ORDER_PUB.G_LINE;
920:
921: IF p_uom_class = 'Weight' THEN
922: l_uom_code := FND_PROFILE.VALUE('QP_LINE_WEIGHT_UOM_CODE');
923: ELSE

Line 956: l_line_rec Oe_Order_Pub.Line_Rec_Type;

952: l_list_header_id Number;
953: l_list_header_name Varchar2(250);
954: l_pricing_phase_id Number;
955: l_list_line_id Number;
956: l_line_rec Oe_Order_Pub.Line_Rec_Type;
957: l_freeze_override_flag Varchar2(1);
958: l_cost_type_code Varchar2(30);
959: l_cost_amount Number;
960: l_pricing_contexts_tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1183: OE_Order_Pub.G_Line := l_line_rec;

1179: Return;
1180: End If;
1181:
1182: --testing qp attribute mapping
1183: OE_Order_Pub.G_Line := l_line_rec;
1184:
1185: Begin
1186: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => 'ONT',
1187: p_pricing_type => 'L',

Line 1196: OE_Order_Pub.G_Line := NULL;

1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'QP ATTRIBUTE MAPPING:'||SQLERRM ) ;
1194: END IF;
1195: End;
1196: OE_Order_Pub.G_Line := NULL;
1197:
1198: --Test if attribute mapping sorces required pricing attributes
1199: For i in pricing_attribute_info Loop
1200: l_found:=false;