DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_ORDER_PUB

Line 353: l_line_rec OE_Order_Pub.Line_Rec_Type;

349: )
350: IS
351: l_api_version_number CONSTANT NUMBER := 1.0;
352: l_api_name CONSTANT VARCHAR2(30) := 'Get_Tolerance';
353: l_line_rec OE_Order_Pub.Line_Rec_Type;
354: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
355: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
356: l_tbl_index NUMBER;
357: l_line_index NUMBER;

Line 354: l_line_tbl OE_Order_Pub.Line_Tbl_Type;

350: IS
351: l_api_version_number CONSTANT NUMBER := 1.0;
352: l_api_name CONSTANT VARCHAR2(30) := 'Get_Tolerance';
353: l_line_rec OE_Order_Pub.Line_Rec_Type;
354: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
355: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
356: l_tbl_index NUMBER;
357: l_line_index NUMBER;
358: l_cal_tolerance_tbl Cal_Tolerance_Tbl_Type;

Line 355: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;

351: l_api_version_number CONSTANT NUMBER := 1.0;
352: l_api_name CONSTANT VARCHAR2(30) := 'Get_Tolerance';
353: l_line_rec OE_Order_Pub.Line_Rec_Type;
354: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
355: l_temp_line_tbl OE_Order_Pub.Line_Tbl_Type;
356: l_tbl_index NUMBER;
357: l_line_index NUMBER;
358: l_cal_tolerance_tbl Cal_Tolerance_Tbl_Type;
359: l_model_kit_line VARCHAR2(1) := FND_API.G_FALSE;

Line 371: -- l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;

367: l_msg_data VARCHAR2(2000);
368: l_ship_tolerance NUMBER := 0;
369: l_x_return_status VARCHAR2(1);
370: l_top_model_line_id NUMBER;
371: -- l_x_line_tbl OE_Order_Pub.Line_Tbl_Type;
372: l_ratio_status VARCHAR2(1);
373: l_planned_quantity_passed VARCHAR2(1) := FND_API.G_FALSE;
374: l_top_model_index NUMBER := 0;
375:

Line 1067: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1063: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1064: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1065: )
1066: IS
1067: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1068: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1069: l_index Number;
1070: l_firm_flag Varchar2(1) := Null;
1071: l_ato_line_id Number;

Line 1068: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

1064: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1065: )
1066: IS
1067: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1068: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1069: l_index Number;
1070: l_firm_flag Varchar2(1) := Null;
1071: l_ato_line_id Number;
1072: l_top_model_line_id Number;