APPS.BOM_RTG_OI_UTIL dependencies on BOM_INTERFACE_DELETE_GROUPS

Line 251: /* Update the delete_group_name from bom_interface_delete_groups */

247: WHERE wl2.organization_id = BORI.organization_id
248: AND nvl(wl2.disable_date, trunc(sysdate) + 1) > trunc(sysdate));
249:
250: stmt_num := 9;
251: /* Update the delete_group_name from bom_interface_delete_groups */
252: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
253: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
254: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
255: FROM bom_interface_delete_groups

Line 255: FROM bom_interface_delete_groups

251: /* Update the delete_group_name from bom_interface_delete_groups */
252: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
253: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
254: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
255: FROM bom_interface_delete_groups
256: Where upper(entity_name) = G_RtgDelEntity
257: And rownum = 1)
258: WHERE process_flag = 1
259: AND upper(transaction_type) in (G_Delete)

Line 268: FROM bom_interface_delete_groups

264: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
265: OR ( p_batch_id = BORI.batch_id )
266: )
267: AND exists (SELECT 'x'
268: FROM bom_interface_delete_groups
269: Where upper(entity_name) = G_RtgDelEntity
270: );
271:
272: stmt_num := 10;

Line 702: /* Update the delete_group_name from bom_interface_delete_groups */

698: AND BSO1.organization_id = BOSI.organization_id
699: AND BOS1.standard_operation_id = BSO1.standard_operation_id);
700:
701: stmt_num := 10;
702: /* Update the delete_group_name from bom_interface_delete_groups */
703: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
704: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
705: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
706: FROM bom_interface_delete_groups

Line 706: FROM bom_interface_delete_groups

702: /* Update the delete_group_name from bom_interface_delete_groups */
703: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
704: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
705: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
706: FROM bom_interface_delete_groups
707: Where upper(entity_name) = G_OprDelEntity
708: And rownum = 1)
709: WHERE process_flag = 1
710: AND upper(transaction_type) in (G_Delete)

Line 718: FROM bom_interface_delete_groups

714: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
715: OR ( p_batch_id = BOSI.batch_id )
716: )
717: AND exists (SELECT 'x'
718: FROM bom_interface_delete_groups
719: Where upper(entity_name) = G_RtgDelEntity
720: );
721:
722: stmt_num := 11;