DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on CSP_PARTS_REQUIREMENT

Line 384: l_parts_header csp_parts_requirement.Header_rec_type;

380: l_org_ship_methode org_ship_methodes_tbl_type ;
381: -- l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
382: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE;
383: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
384: l_parts_header csp_parts_requirement.Header_rec_type;
385: l_parts_lines csp_parts_requirement.Line_Tbl_type;
386: l_revision varchar2(3);
387: l_ship_set varchar2(3);
388: g_arrival_date DATE;

Line 385: l_parts_lines csp_parts_requirement.Line_Tbl_type;

381: -- l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
382: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE;
383: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
384: l_parts_header csp_parts_requirement.Header_rec_type;
385: l_parts_lines csp_parts_requirement.Line_Tbl_type;
386: l_revision varchar2(3);
387: l_ship_set varchar2(3);
388: g_arrival_date DATE;
389: current_position NUMBER;

Line 1091: l_parts_header csp_parts_requirement.Header_rec_type;

1087: PROCEDURE CANCEL_ORDER(p_order_id IN NUMBER
1088: ,x_return_status OUT NOCOPY VARCHAR2
1089: ,x_msg_data OUT NOCOPY VARCHAR2
1090: ,x_msg_count OUT NOCOPY NUMBER) IS
1091: l_parts_header csp_parts_requirement.Header_rec_type;
1092: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1093: l_api_version NUMBER := 1.0;
1094: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CANCEL_ORDER';
1095: BEGIN

Line 1092: l_parts_lines csp_parts_requirement.Line_Tbl_type;

1088: ,x_return_status OUT NOCOPY VARCHAR2
1089: ,x_msg_data OUT NOCOPY VARCHAR2
1090: ,x_msg_count OUT NOCOPY NUMBER) IS
1091: l_parts_header csp_parts_requirement.Header_rec_type;
1092: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1093: l_api_version NUMBER := 1.0;
1094: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CANCEL_ORDER';
1095: BEGIN
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1142: l_parts_header csp_parts_requirement.Header_rec_type;

1138: and oeh.header_id = oel.header_id
1139: order by oeh.header_id;
1140:
1141: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
1142: l_parts_header csp_parts_requirement.Header_rec_type;
1143: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1144: l_order_header_id NUMBER;
1145: l_order_line_id NUMBER;
1146: l_header_id NUMBER;

Line 1143: l_parts_lines csp_parts_requirement.Line_Tbl_type;

1139: order by oeh.header_id;
1140:
1141: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
1142: l_parts_header csp_parts_requirement.Header_rec_type;
1143: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1144: l_order_header_id NUMBER;
1145: l_order_line_id NUMBER;
1146: l_header_id NUMBER;
1147: rec_count NUMBER := 1;

Line 1246: l_parts_header csp_parts_requirement.Header_rec_type;

1242: AND RESOURCE_TYPE = c_resource_type
1243: AND PRIMARY_FLAG = 'Y';
1244:
1245: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
1246: l_parts_header csp_parts_requirement.Header_rec_type;
1247: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1248: l_requrements_lines CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
1249: l_return_status VARCHAR2(30);
1250: l_msg_count NUMBER;

Line 1247: l_parts_lines csp_parts_requirement.Line_Tbl_type;

1243: AND PRIMARY_FLAG = 'Y';
1244:
1245: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
1246: l_parts_header csp_parts_requirement.Header_rec_type;
1247: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1248: l_requrements_lines CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
1249: l_return_status VARCHAR2(30);
1250: l_msg_count NUMBER;
1251: l_msg_data VARCHAR2(1000);