APPS.MODAL_DELETE dependencies on BOM_DELETE_ENTITIES

Line 31: BOM_DELETE_ENTITIES

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
35: NOTES

Line 70: From bom_delete_entities bde

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
71: Where bde.delete_group_sequence_id = new_group_seq_id_v
72: And nvl(bde.bill_sequence_id, 0) = nvl(ent_bill_seq_id, 0)
73: And nvl(bde.routing_sequence_id, 0) = nvl(ent_rtg_seq_id, 0)
74: And nvl(bde.inventory_item_id, 0) = nvl(ent_inv_item_id, 0)

Line 76: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;

72: And nvl(bde.bill_sequence_id, 0) = nvl(ent_bill_seq_id, 0)
73: And nvl(bde.routing_sequence_id, 0) = nvl(ent_rtg_seq_id, 0)
74: And nvl(bde.inventory_item_id, 0) = nvl(ent_inv_item_id, 0)
75: And nvl(bde.organization_id, 0) = nvl(org_id, 0);
76: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;
77: Cursor GetNewEntity is
78: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id
79: From sys.dual;
80: Cursor GetComponent is

Line 78: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id

74: And nvl(bde.inventory_item_id, 0) = nvl(ent_inv_item_id, 0)
75: And nvl(bde.organization_id, 0) = nvl(org_id, 0);
76: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;
77: Cursor GetNewEntity is
78: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id
79: From sys.dual;
80: Cursor GetComponent is
81: SELECT BIC.COMPONENT_SEQUENCE_ID,
82: BIC.EFFECTIVITY_DATE,

Line 192: INSERT INTO bom_delete_entities

188: For X_NewEntity in GetNewEntity loop
189: X_EntSeqId := X_NewEntity.Entity_Id;
190:
191: sql_stmt_num := 40;
192: INSERT INTO bom_delete_entities
193: (DELETE_ENTITY_SEQUENCE_ID,
194: DELETE_GROUP_SEQUENCE_ID,
195: DELETE_ENTITY_TYPE,
196: BILL_SEQUENCE_ID,

Line 396: BOM_DELETE_ENTITIES

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
400: SQLCODE if error

Line 442: From bom_delete_entities bde

438: FROM SYS.DUAL;
439:
440: Cursor GetEntity is
441: Select bde.delete_entity_sequence_id
442: From bom_delete_entities bde
443: Where bde.delete_group_sequence_id = new_group_seq_id_v
444: And nvl(bde.bill_sequence_id, 0) = nvl(ent_bill_seq_id, 0)
445: And nvl(bde.routing_sequence_id, 0) = nvl(ent_rtg_seq_id, 0)
446: And nvl(bde.inventory_item_id, 0) = nvl(ent_inv_item_id, 0)

Line 449: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;

445: And nvl(bde.routing_sequence_id, 0) = nvl(ent_rtg_seq_id, 0)
446: And nvl(bde.inventory_item_id, 0) = nvl(ent_inv_item_id, 0)
447: And nvl(bde.organization_id, 0) = nvl(org_id, 0);
448:
449: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;
450:
451: Cursor GetNewEntity is
452: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id
453: From sys.dual;

Line 452: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id

448:
449: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;
450:
451: Cursor GetNewEntity is
452: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id
453: From sys.dual;
454:
455: Cursor GetComponent is
456: SELECT BIC.COMPONENT_SEQUENCE_ID,

Line 602: INSERT INTO bom_delete_entities

598: For X_NewEntity in GetNewEntity loop
599: X_EntSeqId := X_NewEntity.Entity_Id;
600:
601: sql_stmt_num := 40;
602: INSERT INTO bom_delete_entities
603: (DELETE_ENTITY_SEQUENCE_ID,
604: DELETE_GROUP_SEQUENCE_ID,
605: DELETE_ENTITY_TYPE,
606: BILL_SEQUENCE_ID,