eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_SCH_INT_PVT dependencies on CSP_SUPERSESSIONS_PVT

Line 1592: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

1588: l_temp_reserv_quantity NUMBER;
1589: l_substitute_item NUMBER;
1590: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY';
1591: --- l_cumulative_att NUMBER;
1592: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
1593: l_required_quantity NUMBER;
1594: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
1595: l_append boolean := true;
1596: l_revision_controlled BOOLEAN := false;

Line 1594: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

1590: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY';
1591: --- l_cumulative_att NUMBER;
1592: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
1593: l_required_quantity NUMBER;
1594: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
1595: l_append boolean := true;
1596: l_revision_controlled BOOLEAN := false;
1597: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
1598: l_reservation_id NUMBER;

Line 1599: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

1595: l_append boolean := true;
1596: l_revision_controlled BOOLEAN := false;
1597: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
1598: l_reservation_id NUMBER;
1599: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
1600: BEGIN
1601: savepoint csp_check_local_inv;
1602: x_return_status := FND_API.G_RET_STS_SUCCESS;
1603: x_unavailable_list:= CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE();

Line 1619: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(J).item_id

1615: END IF;
1616: if l_supersede_items.count > 0 THEN
1617: l_supersede_items.DELETE;
1618: END IF;
1619: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(J).item_id
1620: ,p_organization_id => p_resource_org_subinv(I).organization_id
1621: ,x_supersede_items => l_supersede_items);
1622: l_alternate_parts := l_supersede_items;
1623:

Line 3792: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

3788: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE;
3789: l_temp_options CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE ;
3790: l_final_option CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE ;
3791: l_org_ship_methode org_ship_methodes_tbl_type ;
3792: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3793: min_cost NUMBER ;
3794: rec_pointer NUMBER;
3795: l_intransit_time NUMBER;
3796: l_timezone_id NUMBER;

Line 3817: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

3813: l_uom_code varchar2(3);
3814: l_temp_quantity NUMBER;
3815: l_substitute_item NUMBER;
3816: l_alternate_items_list alternate_items_table_type;
3817: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3818: l_final_available_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
3819: l_atp_success BOOLEAN;
3820: check_subinventory BOOLEAN;
3821:

Line 3838: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

3834: min_arrival_date DATE;
3835: l_no_of_days number;--heh
3836: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
3837: l_reservation_id number;
3838: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3839:
3840: l_primary_uom_code varchar2(10);
3841:
3842: BEGIN

Line 3912: csp_supersessions_pvt.check_for_duplicate_parts(p_parts_list,l_temp_org_id,x_return_status,x_msg_data,x_msg_count);

3908: ELSE
3909: l_dest_org_id := l_temp_org_id;
3910: END IF;
3911: IF p_parts_list.count > 1 THEN
3912: csp_supersessions_pvt.check_for_duplicate_parts(p_parts_list,l_temp_org_id,x_return_status,x_msg_data,x_msg_count);
3913: END IF;
3914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3915: RETURN;
3916: END IF;

Line 4001: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(I).item_id

3997: END LOOP;
3998: FOR I IN 1..p_parts_list.count LOOP
3999: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or
4000: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY' THEN
4001: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(I).item_id
4002: ,p_organization_id => l_temp_org_id
4003: ,x_supersede_items => l_supersede_items);
4004: FOR J IN 1..l_supersede_items.count LOOP
4005: l_uom_code := null;

Line 5211: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

5207: ,x_msg_count OUT NOCOPY NUMBER) IS
5208:
5209: l_temp_quantity NUMBER := 0;
5210: l_uom_code varchar2(10);
5211: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
5212: l_substitute_item NUMBER;
5213:
5214: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
5215: SELECT PRIMARY_UOM_CODE

Line 5237: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_rec.item_id

5233:
5234:
5235:
5236: BEGIN
5237: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_rec.item_id
5238: ,p_organization_id => p_org_id
5239: ,x_supersede_items => l_supersede_items);
5240: FOR J IN 1..l_supersede_items.count LOOP
5241: l_uom_code := null;