APPS.CSP_SUPERSESSIONS_PVT dependencies on CSP_SCH_INT_PVT

Line 526: /*CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_org_id

522: END IF;
523: END LOOP;
524: CLOSE get_supply_level_in_SC;
525: IF l_supply_level = l_lower_supply_level THEN
526: /*CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_org_id
527: ,p_subinv_code => l_sec_subinventory
528: ,p_item_id => l_inventory_item_Id
529: ,x_att => l_att
530: ,x_onhand => l_onhand

Line 569: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id

565: x_item_supplied := l_inventory_item_Id;
566: EXIT;
567: END IF;
568: IF l_source_org_id IS NOT NULL THEN
569: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id
570: ,p_revision => null
571: ,p_subinv_code => l_source_sub_inventory
572: ,p_item_id => l_inventory_item_Id
573: ,x_att => l_att

Line 585: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id

581: --dbms_output.put_line(l_source_org_id || ' ' || l_source_sub_inventory || ' ' || l_inventory_item_Id || ' ' || l_att );
582: --END IF;
583: ELSE
584: l_att := 0;
585: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id
586: ,p_revision => null
587: ,p_subinv_code => l_source_sub_inventory
588: ,p_item_id => l_inventory_item_Id
589: ,x_att => l_att

Line 874: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id

870: END LOOP;
871: CLOSE is_item_scrap;
872: IF l_scrap = 'N' THEN
873: IF p_subinv_code is not null then
874: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id
875: ,p_revision => null
876: ,p_subinv_code => p_subinv_code
877: ,p_item_id => l_item_id
878: ,x_att => l_att

Line 889: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id

885: OPEN get_usable_subinventories;
886: LOOP
887: FETCH get_usable_subinventories INTO l_subinv_code;
888: EXIT WHEN get_usable_subinventories % NOTFOUND;
889: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY( p_org_id => l_source_org_id
890: ,p_revision => null
891: ,p_subinv_code => l_subinv_code
892: ,p_item_id => l_item_id
893: ,x_att => l_att

Line 949: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY(p_org_id => l_org_id

945: LOOP
946: FETCH get_defective_sources INTO l_org_id, l_sub_inv_code;
947: EXIT WHEN get_defective_sources % NOTFOUND;
948: l_att := 0;
949: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY(p_org_id => l_org_id
950: ,p_revision => null
951: ,p_subinv_code => l_sub_inv_code
952: ,p_item_id => l_item_id
953: ,x_att => l_att

Line 1413: PROCEDURE check_for_duplicate_parts(l_parts_list IN CSP_SCH_INT_PVT.CSP_PARTS_TBL_TYP1

1409: WHEN OTHERS THEN
1410: x_return_status := FND_API.G_RET_STS_ERROR;
1411: ROLLBACK TO PROCESS_SUPERSESSIONS;
1412: END PROCESS_SUPERSESSIONS;
1413: PROCEDURE check_for_duplicate_parts(l_parts_list IN CSP_SCH_INT_PVT.CSP_PARTS_TBL_TYP1
1414: ,p_org_id IN NUMBER
1415: ,x_return_status OUT NOCOPY varchar2
1416: ,x_message OUT NOCOPY varchar2
1417: ,x_msg_count OUT NOCOPY NUMBER) IS