APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on MTL_SYSTEM_ITEMS

Line 468: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child(

464: FETCH c_ii INTO r_ii;
465: IF c_ii%FOUND THEN
466: -- l_org_id := NVL( r_ii.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
467: l_org_id := r_ii.INV_MASTER_ORGANIZATION_ID;
468: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child(
469: p_inventory_item_id => r_ii.INVENTORY_ITEM_ID
470: , p_organization_id => l_org_id
471: , p_resource_id => p_resource_id );
472:

Line 607: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child

603: FETCH c_ii INTO r_ii;
604: IF c_ii%FOUND THEN
605: -- l_org_id := NVL( r_ii.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
606: l_org_id := r_ii.INV_MASTER_ORGANIZATION_ID;
607: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child
608: ( p_inventory_item_id => r_ii.INVENTORY_ITEM_ID
609: , p_organization_id => l_org_id
610: , p_resource_id => p_resource_id
611: );

Line 847: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS si

843: b_party_site_id NUMBER,
844: b_location_id NUMBER,
845: b_party_id NUMBER ) IS
846: SELECT cii.instance_id
847: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS si
848: WHERE si.organization_id = NVL( cii.inv_organization_id,
849: cii.inv_master_organization_id )
850: AND si.inventory_item_id = cii.inventory_item_id
851: AND cii.instance_id NOT IN

Line 1201: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child( p_inventory_item_id => r_item_instance.INVENTORY_ITEM_ID

1197:
1198: -- Add SYSTEM ITEMs
1199: --l_org_id := NVL( r_item_instance.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
1200: l_org_id := r_item_instance.INV_MASTER_ORGANIZATION_ID;
1201: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child( p_inventory_item_id => r_item_instance.INVENTORY_ITEM_ID
1202: , p_organization_id => l_org_id
1203: , p_resource_id => p_resource_id
1204: );
1205:

Line 1272: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child( p_inventory_item_id => r_item_instance.INVENTORY_ITEM_ID

1268:
1269: -- Delete SYSTEM ITEMs
1270: --l_org_id := NVL( r_item_instance.INV_ORGANIZATION_ID, TO_NUMBER(FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')));
1271: l_org_id := r_item_instance.INV_MASTER_ORGANIZATION_ID;
1272: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child( p_inventory_item_id => r_item_instance.INVENTORY_ITEM_ID
1273: , p_organization_id => l_org_id
1274: , p_resource_id => p_resource_id
1275: );
1276:

Line 1544: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child( p_inventory_item_id => inv_itm_id(i)

1540: ,P_PK1_NUM_VALUE => inst_id(i)
1541: );
1542:
1543: -- Add SYSTEM ITEMs
1544: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Pre_Insert_Child( p_inventory_item_id => inv_itm_id(i)
1545: , p_organization_id => inv_org_id(i)
1546: , p_resource_id => res_id(i)
1547: );
1548: END LOOP;

Line 1601: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child( p_inventory_item_id => inv_itm_id(i)

1597: ,P_RESOURCE_ID => res_id(i)
1598: );
1599:
1600: -- Delete SYSTEM ITEMs
1601: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.Post_Delete_Child( p_inventory_item_id => inv_itm_id(i)
1602: , p_organization_id => inv_org_id(i)
1603: , p_resource_id => res_id(i)
1604: );
1605: END LOOP;