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 3282: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

3278: l_temp_reserv_quantity NUMBER;
3279: l_substitute_item NUMBER;
3280: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY';
3281: --- l_cumulative_att NUMBER;
3282: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3283: l_required_quantity NUMBER;
3284: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3285: l_append boolean := true;
3286: l_revision_controlled BOOLEAN := false;

Line 3284: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

3280: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY';
3281: --- l_cumulative_att NUMBER;
3282: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3283: l_required_quantity NUMBER;
3284: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3285: l_append boolean := true;
3286: l_revision_controlled BOOLEAN := false;
3287: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
3288: l_reservation_id NUMBER;

Line 3289: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

3285: l_append boolean := true;
3286: l_revision_controlled BOOLEAN := false;
3287: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
3288: l_reservation_id NUMBER;
3289: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
3290: BEGIN
3291: savepoint csp_check_local_inv;
3292: x_return_status := FND_API.G_RET_STS_SUCCESS;
3293: x_unavailable_list:= CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE();

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

3305: END IF;
3306: if l_supersede_items.count > 0 THEN
3307: l_supersede_items.DELETE;
3308: END IF;
3309: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(J).item_id
3310: ,p_organization_id => p_resource_org_subinv(I).organization_id
3311: ,x_supersede_items => l_supersede_items);
3312: l_alternate_parts := l_supersede_items;
3313:

Line 6231: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

6227: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE;
6228: l_temp_options CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE ;
6229: l_final_option CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE ;
6230: l_org_ship_methode org_ship_methodes_tbl_type ;
6231: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
6232: min_cost NUMBER ;
6233: rec_pointer NUMBER;
6234: l_intransit_time NUMBER;
6235: l_timezone_id NUMBER;

Line 6256: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

6252: l_uom_code VARCHAR2(3);
6253: l_temp_quantity NUMBER;
6254: l_substitute_item NUMBER;
6255: l_alternate_items_list alternate_items_table_type;
6256: l_alternate_parts CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
6257: l_final_available_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
6258: l_atp_success BOOLEAN;
6259: check_subinventory BOOLEAN;
6260: l_att NUMBER;

Line 6276: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

6272: min_arrival_date DATE;
6273: l_no_of_days NUMBER;--heh
6274: l_reservation_parts CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
6275: l_reservation_id NUMBER;
6276: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
6277: l_primary_uom_code VARCHAR2(10);
6278: l_replenisment_org_id NUMBER;
6279: l_replenisment_subinventory VARCHAR2(100);
6280: l_check_alternates BOOLEAN := FALSE;

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

6359: END IF;
6360: log('check_parts_availability', 'p_parts_list.count: '||p_parts_list.count);
6361: IF p_parts_list.count > 1 THEN
6362: log('check_parts_availability', 'l_temp_org_id: '||l_temp_org_id);
6363: csp_supersessions_pvt.check_for_duplicate_parts(p_parts_list,l_temp_org_id,x_return_status,x_msg_data,x_msg_count);
6364: END IF;
6365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6366: RETURN;
6367: END IF;

Line 6474: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(I).item_id ,p_organization_id => l_temp_org_id ,x_supersede_items => l_supersede_items);

6470: else
6471: l_check_alternates := fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' OR fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY';
6472: end if;
6473: IF l_check_alternates THEN
6474: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(I).item_id ,p_organization_id => l_temp_org_id ,x_supersede_items => l_supersede_items);
6475: log('check_parts_availability', 'begin l_supersede_items loop. l_supersede_items count: '||l_supersede_items.count);
6476: FOR J IN 1..l_supersede_items.count
6477: loop
6478: log('check_parts_availability', 'supersede items loop begin: '||J);

Line 7753: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;

7749: ,x_msg_count OUT NOCOPY NUMBER) IS
7750:
7751: l_temp_quantity NUMBER := 0;
7752: l_uom_code varchar2(10);
7753: l_supersede_items CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
7754: l_substitute_item NUMBER;
7755:
7756: CURSOR primary_uom_code(item_id NUMBER,org_id NUMBER) IS
7757: SELECT PRIMARY_UOM_CODE

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

7775:
7776:
7777:
7778: BEGIN
7779: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_rec.item_id
7780: ,p_organization_id => p_org_id
7781: ,x_supersede_items => l_supersede_items);
7782: FOR J IN 1..l_supersede_items.count LOOP
7783: l_uom_code := null;