DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_ORDER_PUB

Line 359: l_line_rec OE_Order_Pub.Line_Rec_Type;

355: )
356: IS
357: l_api_version_number CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30) := 'Get_Tolerance';
359: l_line_rec OE_Order_Pub.Line_Rec_Type;
360: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
361: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
362: l_tbl_index NUMBER;
363: l_line_index NUMBER;

Line 360: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

356: IS
357: l_api_version_number CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30) := 'Get_Tolerance';
359: l_line_rec OE_Order_Pub.Line_Rec_Type;
360: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
361: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
362: l_tbl_index NUMBER;
363: l_line_index NUMBER;
364: l_cal_tolerance_tbl Cal_Tolerance_Tbl_Type;

Line 361: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;

357: l_api_version_number CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30) := 'Get_Tolerance';
359: l_line_rec OE_Order_Pub.Line_Rec_Type;
360: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
361: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
362: l_tbl_index NUMBER;
363: l_line_index NUMBER;
364: l_cal_tolerance_tbl Cal_Tolerance_Tbl_Type;
365: l_model_kit_line VARCHAR2(1) := FND_API.G_FALSE;

Line 377: -- l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;

373: l_msg_data VARCHAR2(2000);
374: l_ship_tolerance NUMBER := 0;
375: l_x_return_status VARCHAR2(1);
376: l_top_model_line_id NUMBER;
377: -- l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
378: l_ratio_status VARCHAR2(1);
379: l_planned_quantity_passed VARCHAR2(1) := FND_API.G_FALSE;
380: l_top_model_index NUMBER := 0;
381:

Line 1090: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1086: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1087: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1088: )
1089: IS
1090: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1091: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1092: l_index Number;
1093: l_firm_flag Varchar2(1) := Null;
1094: l_ato_line_id Number;

Line 1091: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

1087: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1088: )
1089: IS
1090: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1091: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1092: l_index Number;
1093: l_firm_flag Varchar2(1) := Null;
1094: l_ato_line_id Number;
1095: l_top_model_line_id Number;