DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on CSP_PARTS_REQUIREMENT

Line 1302: l_parts_header csp_parts_requirement.Header_rec_type;

1298: l_org_ship_methode org_ship_methodes_tbl_type ;
1299: -- l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
1300: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE;
1301: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
1302: l_parts_header csp_parts_requirement.Header_rec_type;
1303: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1304: l_revision varchar2(3);
1305: l_ship_set varchar2(3);
1306: g_arrival_date DATE;

Line 1303: l_parts_lines csp_parts_requirement.Line_Tbl_type;

1299: -- l_Requirement_Line_Tbl CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
1300: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE;
1301: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
1302: l_parts_header csp_parts_requirement.Header_rec_type;
1303: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1304: l_revision varchar2(3);
1305: l_ship_set varchar2(3);
1306: g_arrival_date DATE;
1307: current_position NUMBER;

Line 2776: l_parts_header csp_parts_requirement.Header_rec_type;

2772: PROCEDURE CANCEL_ORDER(p_order_id IN NUMBER
2773: ,x_return_status OUT NOCOPY VARCHAR2
2774: ,x_msg_data OUT NOCOPY VARCHAR2
2775: ,x_msg_count OUT NOCOPY NUMBER) IS
2776: l_parts_header csp_parts_requirement.Header_rec_type;
2777: l_parts_lines csp_parts_requirement.Line_Tbl_type;
2778: l_api_version NUMBER := 1.0;
2779: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CANCEL_ORDER';
2780: BEGIN

Line 2777: l_parts_lines csp_parts_requirement.Line_Tbl_type;

2773: ,x_return_status OUT NOCOPY VARCHAR2
2774: ,x_msg_data OUT NOCOPY VARCHAR2
2775: ,x_msg_count OUT NOCOPY NUMBER) IS
2776: l_parts_header csp_parts_requirement.Header_rec_type;
2777: l_parts_lines csp_parts_requirement.Line_Tbl_type;
2778: l_api_version NUMBER := 1.0;
2779: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CANCEL_ORDER';
2780: BEGIN
2781: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2829: l_parts_header csp_parts_requirement.Header_rec_type;

2825: and oeh.header_id = oel.header_id
2826: order by oeh.header_id;
2827:
2828: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
2829: l_parts_header csp_parts_requirement.Header_rec_type;
2830: l_parts_lines csp_parts_requirement.Line_Tbl_type;
2831: l_order_header_id NUMBER;
2832: l_order_line_id NUMBER;
2833: l_header_id NUMBER;

Line 2830: l_parts_lines csp_parts_requirement.Line_Tbl_type;

2826: order by oeh.header_id;
2827:
2828: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
2829: l_parts_header csp_parts_requirement.Header_rec_type;
2830: l_parts_lines csp_parts_requirement.Line_Tbl_type;
2831: l_order_header_id NUMBER;
2832: l_order_line_id NUMBER;
2833: l_header_id NUMBER;
2834: rec_count NUMBER := 1;

Line 2933: l_parts_header csp_parts_requirement.Header_rec_type;

2929: AND RESOURCE_TYPE = c_resource_type
2930: AND PRIMARY_FLAG = 'Y';
2931:
2932: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
2933: l_parts_header csp_parts_requirement.Header_rec_type;
2934: l_parts_lines csp_parts_requirement.Line_Tbl_type;
2935: l_requrements_lines CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
2936: l_return_status VARCHAR2(30);
2937: l_msg_count NUMBER;

Line 2934: l_parts_lines csp_parts_requirement.Line_Tbl_type;

2930: AND PRIMARY_FLAG = 'Y';
2931:
2932: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CREATE_ORDERS';
2933: l_parts_header csp_parts_requirement.Header_rec_type;
2934: l_parts_lines csp_parts_requirement.Line_Tbl_type;
2935: l_requrements_lines CSP_Requirement_Lines_PVT.Requirement_Line_Tbl_Type;
2936: l_return_status VARCHAR2(30);
2937: l_msg_count NUMBER;
2938: l_msg_data VARCHAR2(1000);

Line 6758: csp_parts_requirement.get_source_organization(l_unavailable_list(I).item_id, l_unavailable_list(I).organization_id, l_temp_subinv_code, l_replenisment_org_id, l_replenisment_subinventory);

6754: FOR I IN 1..l_unavailable_list.count
6755: LOOP
6756: l_replenisment_org_id := NULL;
6757: l_replenisment_subinventory := NULL;
6758: csp_parts_requirement.get_source_organization(l_unavailable_list(I).item_id, l_unavailable_list(I).organization_id, l_temp_subinv_code, l_replenisment_org_id, l_replenisment_subinventory);
6759: IF l_replenisment_org_id IS NOT NULL THEN
6760: l_available_list.extend;
6761: l_available_list(l_available_list.count).item_id := l_unavailable_list(I).item_id ;
6762: l_available_list(l_available_list.count).source_org := l_replenisment_org_id;