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 700: /* Update the delete_group_name from bom_interface_delete_groups */

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

Line 704: FROM bom_interface_delete_groups

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

Line 716: FROM bom_interface_delete_groups

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