APPS.IBE_PROD_RELATION_PVT dependencies on IBE_CT_REL_EXCLUSIONS

Line 547: IBE_UTIL.debug('Deleting rows in IBE_CT_REL_EXCLUSIONS.');

543: FROM ibe_ct_related_items
544: WHERE relation_type_code = p_rel_type_code_tbl(i);
545:
546: IF (l_debug = 'Y') THEN
547: IBE_UTIL.debug('Deleting rows in IBE_CT_REL_EXCLUSIONS.');
548: END IF;
549: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
550: DELETE
551: FROM ibe_ct_rel_exclusions

Line 551: FROM ibe_ct_rel_exclusions

547: IBE_UTIL.debug('Deleting rows in IBE_CT_REL_EXCLUSIONS.');
548: END IF;
549: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
550: DELETE
551: FROM ibe_ct_rel_exclusions
552: WHERE relation_type_code = p_rel_type_code_tbl(i);
553: -- End of API body.
554: IF (l_debug = 'Y') THEN
555: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Delete_Relationship(-)');

Line 642: INSERT INTO IBE_CT_REL_EXCLUSIONS(

638: IBE_UTIL.debug('IBE_Prod_Relation_PVT.Exclude_Related_Items(+)');
639: END IF;
640: -- API body
641: FORALL i IN p_inventory_item_id_tbl.FIRST..p_inventory_item_id_tbl.LAST
642: INSERT INTO IBE_CT_REL_EXCLUSIONS(
643: organization_id, relation_type_code, inventory_item_id,
644: related_item_id, object_version_number, created_by,
645: creation_date, last_updated_by, last_update_date
646: )

Line 742: FROM IBE_CT_REL_EXCLUSIONS

738: END IF;
739: -- API body
740: FORALL i IN p_inventory_item_id_tbl.FIRST..p_inventory_item_id_tbl.LAST
741: DELETE
742: FROM IBE_CT_REL_EXCLUSIONS
743: WHERE relation_type_code = p_rel_type_code
744: AND inventory_item_id = p_inventory_item_id_tbl(i)
745: AND related_item_id = p_related_item_id_tbl(i)
746: AND organization_id = L_ORGANIZATION_ID; --Bug 2922902

Line 977: FROM IBE_CT_REL_EXCLUSIONS ICRE

973: PROCEDURE Remove_Invalid_Exclusions
974: IS
975: BEGIN
976: DELETE
977: FROM IBE_CT_REL_EXCLUSIONS ICRE
978: WHERE NOT EXISTS( SELECT NULL
979: FROM IBE_CT_RELATED_ITEMS ICRI
980: WHERE ICRI.relation_type_code = ICRE.relation_type_code
981: AND ICRI.inventory_item_id = ICRE.inventory_item_id