APPS.CSP_PART_SEARCH_PVT dependencies on CSP_SCH_INT_PVT

Line 958: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;

954: csp_requirement_headers crh
955: where crh.requirement_header_id = p_search_params.requirement_header_id
956: and crl.requirement_header_id = crh.requirement_header_id;
957:
958: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;
959: l_destination_organization_id number;
960: l_timezone_id number;
961: l_ship_to_location_id number;
962: l_destination_subinventory varchar2(10);

Line 964: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;

960: l_timezone_id number;
961: l_ship_to_location_id number;
962: l_destination_subinventory varchar2(10);
963: l_need_by_date date;
964: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
965: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
966: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
967: i number := 0;
968: begin

Line 965: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;

961: l_ship_to_location_id number;
962: l_destination_subinventory varchar2(10);
963: l_need_by_date date;
964: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
965: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
966: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
967: i number := 0;
968: begin
969: log('atp','Begin');

Line 966: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;

962: l_destination_subinventory varchar2(10);
963: l_need_by_date date;
964: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
965: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
966: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
967: i number := 0;
968: begin
969: log('atp','Begin');
970: for cr in c_required_parts loop

Line 999: log('atp','calling csp_sch_int_pvt.check_parts_availability');

995: log('atp','l_ship_to_location_id:'||l_ship_to_location_id);
996: end loop;
997: l_resource_rec.resource_id := p_search_params.resource_id;
998: l_resource_rec.resource_type := p_search_params.resource_type;
999: log('atp','calling csp_sch_int_pvt.check_parts_availability');
1000: csp_sch_int_pvt.check_parts_availability(
1001: p_resource => l_resource_rec,
1002: p_organization_id => l_destination_organization_id,
1003: p_subinv_code => l_destination_subinventory,

Line 1000: csp_sch_int_pvt.check_parts_availability(

996: end loop;
997: l_resource_rec.resource_id := p_search_params.resource_id;
998: l_resource_rec.resource_type := p_search_params.resource_type;
999: log('atp','calling csp_sch_int_pvt.check_parts_availability');
1000: csp_sch_int_pvt.check_parts_availability(
1001: p_resource => l_resource_rec,
1002: p_organization_id => l_destination_organization_id,
1003: p_subinv_code => l_destination_subinventory,
1004: p_need_by_date => l_need_by_date,

Line 1014: log('atp','after csp_sch_int_pvt.check_parts_availability');

1010: x_msg_count => l_msg_count,
1011: p_location_id => l_ship_to_location_id,
1012: p_include_alternates => p_search_params.include_alternates
1013: );
1014: log('atp','after csp_sch_int_pvt.check_parts_availability');
1015: log('atp','x_return_status:'||x_return_status);
1016: for i in 1..l_avail_list_tbl.count loop
1017: log('atp','insert into CAPT');
1018: insert into csp_available_parts_temp(