APPS.MODAL_DELETE dependencies on BOM_DELETE_SUB_ENTITIES

Line 32: BOM_DELETE_SUB_ENTITIES

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
36: Function sends error message to Forms message line and raises an

Line 98: FROM BOM_DELETE_SUB_ENTITIES BDSE

94: AND MSIK.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
95: AND MSIK.ORGANIZATION_ID = org_id
96: AND NOT EXISTS (
97: SELECT NULL
98: FROM BOM_DELETE_SUB_ENTITIES BDSE
99: WHERE BDSE.DELETE_ENTITY_SEQUENCE_ID = X_EntSeqId
100: AND BDSE.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID);
101: Cursor GetOperation is
102: SELECT BOS.OPERATION_SEQUENCE_ID,

Line 114: FROM BOM_DELETE_SUB_ENTITIES BDSE

110: WHERE BOS.OPERATION_SEQUENCE_ID = ent_op_seq_id
111: AND BOS.DEPARTMENT_ID = BD.DEPARTMENT_ID
112: AND NOT EXISTS (
113: SELECT NULL
114: FROM BOM_DELETE_SUB_ENTITIES BDSE
115: WHERE BDSE.DELETE_ENTITY_SEQUENCE_ID = X_EntSeqId
116: AND BDSE.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID);
117: BEGIN
118: SAVEPOINT BEGIN_DELETE;

Line 253: INSERT INTO bom_delete_sub_entities

249: If del_type = COMP then
250: sql_stmt_num := 50;
251: For X_Component in GetComponent loop
252: sql_stmt_num := 60;
253: INSERT INTO bom_delete_sub_entities
254: (DELETE_ENTITY_SEQUENCE_ID,
255: COMPONENT_SEQUENCE_ID,
256: OPERATION_SEQUENCE_ID,
257: OPERATION_SEQ_NUM,

Line 308: INSERT INTO bom_delete_sub_entities

304: Elsif del_type = OPER then
305: sql_stmt_num := 70;
306: For X_Operation in GetOperation loop
307: sql_stmt_num := 80;
308: INSERT INTO bom_delete_sub_entities
309: (DELETE_ENTITY_SEQUENCE_ID,
310: COMPONENT_SEQUENCE_ID,
311: OPERATION_SEQUENCE_ID,
312: OPERATION_SEQ_NUM,

Line 397: BOM_DELETE_SUB_ENTITIES

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

Line 471: FROM BOM_DELETE_SUB_ENTITIES BDSE

467: AND MSIK.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
468: AND MSIK.ORGANIZATION_ID = org_id
469: AND NOT EXISTS (
470: SELECT NULL
471: FROM BOM_DELETE_SUB_ENTITIES BDSE
472: WHERE BDSE.DELETE_ENTITY_SEQUENCE_ID = X_EntSeqId
473: AND BDSE.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID);
474:
475: Cursor GetOperation is

Line 488: FROM BOM_DELETE_SUB_ENTITIES BDSE

484: WHERE BOS.OPERATION_SEQUENCE_ID = ent_op_seq_id
485: AND BOS.DEPARTMENT_ID = BD.DEPARTMENT_ID
486: AND NOT EXISTS (
487: SELECT NULL
488: FROM BOM_DELETE_SUB_ENTITIES BDSE
489: WHERE BDSE.DELETE_ENTITY_SEQUENCE_ID = X_EntSeqId
490: AND BDSE.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID);
491: l_UserId NUMBER;
492: l_LoginId NUMBER;

Line 663: INSERT INTO bom_delete_sub_entities

659: If del_type = COMP then
660: sql_stmt_num := 50;
661: For X_Component in GetComponent loop
662: sql_stmt_num := 60;
663: INSERT INTO bom_delete_sub_entities
664: (DELETE_ENTITY_SEQUENCE_ID,
665: COMPONENT_SEQUENCE_ID,
666: OPERATION_SEQUENCE_ID,
667: OPERATION_SEQ_NUM,

Line 714: INSERT INTO bom_delete_sub_entities

710: Elsif del_type = OPER then
711: sql_stmt_num := 70;
712: For X_Operation in GetOperation loop
713: sql_stmt_num := 80;
714: INSERT INTO bom_delete_sub_entities
715: (DELETE_ENTITY_SEQUENCE_ID,
716: COMPONENT_SEQUENCE_ID,
717: OPERATION_SEQUENCE_ID,
718: OPERATION_SEQ_NUM,