APPS.CSP_SCH_INT_PVT dependencies on CSP_REQUIREMENT_HEADERS_PVT

Line 1301: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;

1297: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
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);

Line 1463: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;

1459:
1460: if l_shpd_lines > 0 then
1461: for cr in c_parts_req(p_task_id, r_asgn.task_assignment_id)
1462: loop
1463: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;
1464: l_requirement_header.requirement_header_id := cr.requirement_header_id;
1465: l_requirement_header.need_by_date := p_options.start_time;
1466: l_requirement_header.task_assignment_id := p_task_assignment_id ;
1467: l_requirement_header.last_update_date := sysdate;

Line 1481: CSP_Requirement_Headers_PVT.Update_requirement_headers(

1477: log('choose_option','resource_id:'||l_requirement_header.resource_id);
1478: log('choose_option','start_time:'||to_char(l_requirement_header.need_by_date,'dd-mon-yyyy hh24:mi:ss'));
1479:
1480: log('choose_option', 'before calling Update_requirement_headers...');
1481: CSP_Requirement_Headers_PVT.Update_requirement_headers(
1482: P_Api_Version_Number => 1.0,
1483: P_Init_Msg_List => FND_API.G_FALSE,
1484: P_Commit => FND_API.G_FALSE,
1485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1524: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;

1520: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1521: if x_return_status = 'C' then
1522: for cr in c_parts_req(p_task_id, r_asgn.task_assignment_id)
1523: loop
1524: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;
1525: l_requirement_header.requirement_header_id := cr.requirement_header_id;
1526: l_requirement_header.need_by_date := p_options.start_time;
1527: l_requirement_header.task_assignment_id := p_task_assignment_id ;
1528: l_requirement_header.last_update_date := sysdate;

Line 1542: CSP_Requirement_Headers_PVT.Update_requirement_headers(

1538: log('choose_option','resource_id:'||l_requirement_header.resource_id);
1539: log('choose_option','start_time:'||to_char(l_requirement_header.need_by_date,'dd-mon-yyyy hh24:mi:ss'));
1540:
1541: log('choose_option', 'before calling Update_requirement_headers...');
1542: CSP_Requirement_Headers_PVT.Update_requirement_headers(
1543: P_Api_Version_Number => 1.0,
1544: P_Init_Msg_List => FND_API.G_FALSE,
1545: P_Commit => FND_API.G_FALSE,
1546: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1841: CSP_Requirement_Headers_PVT.Update_requirement_headers(

1837: l_requirement_header.ship_to_location_id := l_ship_to_location_id;
1838: l_requirement_header.SHIP_TO_CONTACT_ID := null;
1839: end if;
1840: end if;
1841: CSP_Requirement_Headers_PVT.Update_requirement_headers(
1842: P_Api_Version_Number => 1.0,
1843: P_Init_Msg_List => FND_API.G_FALSE,
1844: P_Commit => FND_API.G_FALSE,
1845: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2192: CSP_Requirement_Headers_PVT.Update_requirement_headers(

2188: l_requirement_header.address_type := 'R';
2189: l_requirement_header.ship_to_location_id := l_ship_to_location_id;
2190: END IF;
2191: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
2192: CSP_Requirement_Headers_PVT.Update_requirement_headers(
2193: P_Api_Version_Number => 1.0,
2194: P_Init_Msg_List => FND_API.G_FALSE,
2195: P_Commit => FND_API.G_FALSE,
2196: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2476: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;

2472: select requirement_header_id,address_type
2473: from csp_requirement_headers
2474: where task_assignment_id = p_task_assignment_id;
2475:
2476: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
2477: l_requirement_header_id NUMBER;
2478: l_address_type varchar2(3);
2479: l_line_to_cancel number;
2480: l_fl_rcvd_lines number;

Line 2710: CSP_Requirement_Headers_PVT.Update_requirement_headers(

2706: fnd_log.string(fnd_log.level_statement, l_module_name,
2707: 'before updating req header... ');
2708: end if;
2709:
2710: CSP_Requirement_Headers_PVT.Update_requirement_headers(
2711: P_Api_Version_Number => 1.0,
2712: P_Init_Msg_List => FND_API.G_FALSE,
2713: P_Commit => FND_API.G_FALSE,
2714: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 8389: l_requirement_header csp_requirement_headers_pvt.requirement_header_rec_type;

8385:
8386: l_trans_record csp_transactions_pub.trans_items_rec_type;
8387: l_trans_tbl csp_transactions_pub.trans_items_tbl_type;
8388: l_reservation_rec csp_sch_int_pvt.reservation_rec_typ;
8389: l_requirement_header csp_requirement_headers_pvt.requirement_header_rec_type;
8390: l_new_reservation_id number;
8391: l_req_line_detail_id number;
8392: l_new_dest_org number := -999;
8393: l_new_dest_subinv varchar2(30) := null;

Line 8586: CSP_Requirement_Headers_PVT.Update_requirement_headers(

8582: log('move_parts_on_reassign','resource_id:'||l_requirement_header.resource_id);
8583: log('move_parts_on_reassign','start_time:'||to_char(l_requirement_header.need_by_date,'dd-mon-yyyy hh24:mi:ss'));
8584:
8585: log('move_parts_on_reassign', 'before calling Update_requirement_headers...');
8586: CSP_Requirement_Headers_PVT.Update_requirement_headers(
8587: P_Api_Version_Number => 1.0,
8588: P_Init_Msg_List => FND_API.G_FALSE,
8589: P_Commit => FND_API.G_FALSE,
8590: p_validation_level => FND_API.G_VALID_LEVEL_FULL,