1141: SELECT WIP_ENTITY_NAME
1142: FROM WIP_DJ_CLOSE_TEMP
1143: WHERE WIP_ENTITY_ID IN
1144: (SELECT wdct.WIP_ENTITY_ID
1145: FROM WIP_TRANSACTIONS wt,
1146: WIP_DJ_CLOSE_TEMP wdct
1147: WHERE wdct.GROUP_ID = p_group_id
1148: AND wdct.ORGANIZATION_ID = p_organization_id
1149: AND wdct.WIP_ENTITY_ID = wt.WIP_ENTITY_ID
2590: ******************************************/
2591:
2592: SAVEPOINT wip_close; --Bug#13639508- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back
2593:
2594: SELECT WIP_TRANSACTIONS_S.nextval
2595: INTO l_costing_group_id
2596: FROM DUAL;
2597:
2598: INSERT INTO WIP_COST_TXN_INTERFACE
2625: fnd_global.conc_request_id ,
2626: fnd_global.prog_appl_id,
2627: fnd_global.conc_program_id ,
2628: SYSDATE,
2629: WIP_TRANSACTIONS_S.nextval,
2630: oap.ACCT_PERIOD_ID,
2631: l_costing_group_id,
2632: 2, -- PROCESS_STATUS
2633: 3, -- PROCESS_PHASE