APPS.CSP_SCH_INT_PVT dependencies on CSP_REQUIRED_PARTS_TEMP

Line 3749: delete from csp_required_parts_temp;

3745: x_final_unavailable_list(x_final_unavailable_list.count).item_type := p_unavailable_list(i).item_type;
3746: x_final_unavailable_list(x_final_unavailable_list.count).line_id := p_unavailable_list(i).line_id;
3747: end if;
3748: delete from csp_available_parts_temp;
3749: delete from csp_required_parts_temp;
3750: end loop;
3751: end;
3752:
3753: PROCEDURE SPARES_CHECK2(

Line 3790: from csp_required_parts_temp

3786:
3787: cursor c_parts is
3788: select inventory_item_id,
3789: quantity
3790: from csp_required_parts_temp
3791: where item_type = 'BASE';
3792:
3793: cursor c_available(p_inventory_item_id number) is
3794: select distinct supplied_quantity,

Line 3884: delete from csp_required_parts_temp;

3880: l_alternates := FALSE;
3881: end if;
3882: if l_ship_to_location_id is not null and p_warehouse then
3883: delete from csp_available_parts_temp;
3884: delete from csp_required_parts_temp;
3885: if p_warehouse then
3886: p_search_params.search_method := l_search_method;
3887: p_search_params.my_inventory := false;
3888: p_search_params.unmanned_warehouses := false;

Line 3947: delete from csp_required_parts_temp;

3943: exit;
3944: end if;
3945: end loop;
3946: delete from csp_available_parts_temp;
3947: delete from csp_required_parts_temp;
3948: p_search_params.search_method := l_search_method;
3949: p_search_params.my_inventory := false;
3950: p_search_params.unmanned_warehouses := false;
3951: p_search_params.resource_type := p_resources(i).resource_type;

Line 3995: delete from csp_required_parts_temp;

3991: p_search_params.include_closed := true;
3992: p_search_params.include_alternates := l_alternates;
3993: p_search_params.called_from := 'SCHEDULER';
3994: if not p_warehouse then
3995: delete from csp_required_parts_temp;
3996: p_search_params.requirement_header_id := l_requirement_header_id;
3997: end if;
3998: csp_part_search_pvt.search(
3999: p_required_parts => p_required_parts,