APPS.BOM_DELETE_GROUPS_API dependencies on BOM_DELETE_ENTITIES

Line 238: BOM_DELETE_ENTITIES bdent,

234: CURSOR delete_errors ( c_delete_group_id NUMBER )
235: IS
236: SELECT 1
237: FROM
238: BOM_DELETE_ENTITIES bdent,
239: BOM_DELETE_SUB_ENTITIES bdsubent
240: WHERE
241: bdent.DELETE_ENTITY_SEQUENCE_ID = bdsubent.DELETE_ENTITY_SEQUENCE_ID(+)
242: AND ( ( bdent.DELETE_STATUS_TYPE = 3 ) OR ( bdsubent.DELETE_STATUS_TYPE = 3 ) )

Line 376: FROM BOM_DELETE_ENTITIES BDE, MTL_PARAMETERS MP

372: DELETE_ENTITY_SEQUENCE_ID delete_entity_seq_id,
373: MP.ORGANIZATION_CODE organization_code,
374: BDE.ITEM_CONCAT_SEGMENTS item_name, --bug:6193035 Removed substrb
375: BDE.ITEM_DESCRIPTION description
376: FROM BOM_DELETE_ENTITIES BDE, MTL_PARAMETERS MP
377: WHERE DELETE_GROUP_SEQUENCE_ID = p_group_id
378: AND DELETE_STATUS_TYPE in (1,2, decode(process_errored_rows, 'Y', 3, 1))
379: AND BDE.ORGANIZATION_ID = MP.ORGANIZATION_ID
380: ORDER BY decode(MP.MASTER_ORGANIZATION_ID,

Line 402: FROM BOM_DELETE_ENTITIES A, BOM_DELETE_SUB_ENTITIES B,

398: to_char(B.EFFECTIVITY_DATE, 'YYYY/MM/DD HH24:MI') effectivity_date,
399: A.ITEM_CONCAT_SEGMENTS item_name,
400: B.COMPONENT_CONCAT_SEGMENTS comp_name,
401: B.description description
402: FROM BOM_DELETE_ENTITIES A, BOM_DELETE_SUB_ENTITIES B,
403: MTL_PARAMETERS MP
404: WHERE A.DELETE_GROUP_SEQUENCE_ID = p_group_id
405: AND B.DELETE_STATUS_TYPE in (1,2,3)
406: AND A.DELETE_ENTITY_SEQUENCE_ID =

Line 545: UPDATE BOM_DELETE_ENTITIES

541: end if;
542: /*
543: ** set the status
544: */
545: UPDATE BOM_DELETE_ENTITIES
546: SET DELETE_STATUS_TYPE = action_status,
547: DELETE_DATE = decode(action_status, 4,
548: sysdate, NULL),
549: LAST_UPDATE_DATE = sysdate,

Line 559: UPDATE BOM_DELETE_ENTITIES

555: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id;
556:
557: END LOOP; /* for */
558: /* Added for bug 13077632 */
559: UPDATE BOM_DELETE_ENTITIES
560: SET REQUEST_ID = req_id
561: WHERE DELETE_GROUP_SEQUENCE_ID = group_id
562: AND DELETE_STATUS_TYPE = 5;
563: