APPS.BOMPCMBM dependencies on BOM_DELETE_GROUPS

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

378: l_bill_exists := 0; -- Cannot delete as existing bill is not common
379: End if;
380:
381: if (l_bill_exists = 1) then
382: -- Create delete group records and then call the bom_delete-groups API
383: -- that will delete the common bill record.
384:
385: If (((scope = 2 or scope = 3) and (t_org_code_list(I) <> current_org_id))
386: OR (scope = 1)) then

Line 394: SELECT BOM_DELETE_GROUPS_S.NEXTVAL

390: WHERE ASSEMBLY_ITEM_ID = l_item_id
391: AND ORGANIZATION_ID = l_org_id
392: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
393:
394: SELECT BOM_DELETE_GROUPS_S.NEXTVAL
395: INTO delete_group_id
396: FROM DUAL;
397:
398: SELECT BOM_DELETE_ENTITIES_S.NEXTVAL

Line 408: INSERT INTO BOM_DELETE_GROUPS

404: else
405: del_group_name := delete_group_id;
406: End if;
407:
408: INSERT INTO BOM_DELETE_GROUPS
409: (DELETE_GROUP_SEQUENCE_ID,
410: DELETE_GROUP_NAME,
411: DELETE_ORG_TYPE,
412: ORGANIZATION_ID,

Line 471: Bom_Delete_Groups_Api.Delete_Groups

467: to_number(FND_PROFILE.Value('USER_ID')),
468: SYSDATE,
469: to_number(FND_PROFILE.Value('USER_ID')));
470:
471: Bom_Delete_Groups_Api.Delete_Groups
472: (ERRBUF => ERROR_MSG,
473: RETCODE => RETCOD,
474: delete_group_id => delete_group_id,
475: action_type => 2,