APPS.BOMPCMBM dependencies on BOM_DELETE_GROUPS

Line 480: -- Create delete group records and then call the bom_delete-groups API

476: l_bill_exists := 0; -- Cannot delete as existing bill is not common
477: End if;
478:
479: if (l_bill_exists = 1) then
480: -- Create delete group records and then call the bom_delete-groups API
481: -- that will delete the common bill record.
482:
483: If (((scope = 2 or scope = 3) and (t_org_code_list(I) <> current_org_id))
484: OR (scope = 1)) then

Line 492: SELECT BOM_DELETE_GROUPS_S.NEXTVAL

488: WHERE ASSEMBLY_ITEM_ID = l_item_id
489: AND ORGANIZATION_ID = l_org_id
490: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
491:
492: SELECT BOM_DELETE_GROUPS_S.NEXTVAL
493: INTO delete_group_id
494: FROM DUAL;
495:
496: SELECT BOM_DELETE_ENTITIES_S.NEXTVAL

Line 506: INSERT INTO BOM_DELETE_GROUPS

502: else
503: del_group_name := delete_group_id;
504: End if;
505:
506: INSERT INTO BOM_DELETE_GROUPS
507: (DELETE_GROUP_SEQUENCE_ID,
508: DELETE_GROUP_NAME,
509: DELETE_ORG_TYPE,
510: ORGANIZATION_ID,

Line 569: Bom_Delete_Groups_Api.Delete_Groups

565: to_number(FND_PROFILE.Value('USER_ID')),
566: SYSDATE,
567: to_number(FND_PROFILE.Value('USER_ID')));
568:
569: Bom_Delete_Groups_Api.Delete_Groups
570: (ERRBUF => ERROR_MSG,
571: RETCODE => RETCOD,
572: delete_group_id => delete_group_id,
573: action_type => 2,