APPS.MODAL_DELETE dependencies on BOM_DELETE_GROUPS

Line 30: BOM_DELETE_GROUPS

26: ent_comp_seq_id Component Sequence Id
27: ent_op_seq_id Operation Sequence Id
28: user_id User Id
29: MODIFIES
30: BOM_DELETE_GROUPS
31: BOM_DELETE_ENTITIES
32: BOM_DELETE_SUB_ENTITIES
33: RETURNS
34: New Delete Group Sequence Id

Line 66: SELECT BOM_DELETE_GROUPS_S.NEXTVAL group_id

62: sql_stmt_num NUMBER;
63: status_value NUMBER;
64: del_header NUMBER;
65: Cursor GetNewGroup is
66: SELECT BOM_DELETE_GROUPS_S.NEXTVAL group_id
67: FROM SYS.DUAL;
68: Cursor GetEntity is
69: Select bde.delete_entity_sequence_id
70: From bom_delete_entities bde

Line 127: INSERT INTO BOM_DELETE_GROUPS

123: new_group_seq_id_v := X_NewGroup.group_id;
124:
125: sql_stmt_num :=20;
126:
127: INSERT INTO BOM_DELETE_GROUPS
128: (DELETE_GROUP_SEQUENCE_ID,
129: DELETE_GROUP_NAME,
130: ORGANIZATION_ID,
131: DELETE_TYPE,

Line 395: BOM_DELETE_GROUPS

391: ent_comp_seq_id Component Sequence Id
392: ent_op_seq_id Operation Sequence Id
393: user_id User Id
394: MODIFIES
395: BOM_DELETE_GROUPS
396: BOM_DELETE_ENTITIES
397: BOM_DELETE_SUB_ENTITIES
398: RETURNS
399: 0 if successful

Line 433: From BOM_DELETE_GROUPS

429: INVALID_GRP EXCEPTION;
430:
431: Cursor DelGrpType is
432: Select delete_type
433: From BOM_DELETE_GROUPS
434: WHERE DELETE_GROUP_NAME = name;
435:
436: Cursor GetNewGroup is
437: SELECT BOM_DELETE_GROUPS_S.NEXTVAL group_id

Line 437: SELECT BOM_DELETE_GROUPS_S.NEXTVAL group_id

433: From BOM_DELETE_GROUPS
434: WHERE DELETE_GROUP_NAME = name;
435:
436: Cursor GetNewGroup is
437: SELECT BOM_DELETE_GROUPS_S.NEXTVAL group_id
438: FROM SYS.DUAL;
439:
440: Cursor GetEntity is
441: Select bde.delete_entity_sequence_id

Line 537: INSERT INTO BOM_DELETE_GROUPS

533: new_group_seq_id_v := X_NewGroup.group_id;
534:
535: sql_stmt_num :=20;
536:
537: INSERT INTO BOM_DELETE_GROUPS
538: (DELETE_GROUP_SEQUENCE_ID,
539: DELETE_GROUP_NAME,
540: ORGANIZATION_ID,
541: DELETE_TYPE,