DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on FND_GLOBAL

Line 2240: request_id = fnd_global.conc_request_id ,

2236: /*Bug 6908428*/
2237:
2238: UPDATE wip_discrete_jobs
2239: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
2240: request_id = fnd_global.conc_request_id ,
2241: last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,

Line 2242: last_updated_by = fnd_global.user_id,

2238: UPDATE wip_discrete_jobs
2239: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
2240: request_id = fnd_global.conc_request_id ,
2241: last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id
2246: WHERE organization_id = p_organization_id

Line 2243: last_update_login = fnd_global.login_id,

2239: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
2240: request_id = fnd_global.conc_request_id ,
2241: last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id
2246: WHERE organization_id = p_organization_id
2247: AND wip_entity_id in (SELECT wip_entity_id

Line 2244: program_application_id = fnd_global.prog_appl_id,

2240: request_id = fnd_global.conc_request_id ,
2241: last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id
2246: WHERE organization_id = p_organization_id
2247: AND wip_entity_id in (SELECT wip_entity_id
2248: FROM wip_dj_close_temp

Line 2245: program_id = fnd_global.conc_program_id

2241: last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id
2246: WHERE organization_id = p_organization_id
2247: AND wip_entity_id in (SELECT wip_entity_id
2248: FROM wip_dj_close_temp
2249: WHERE group_id = l_group_id

Line 2621: fnd_global.user_id,

2617: ENTITY_TYPE,
2618: TRANSACTION_DATE)
2619: SELECT
2620: SYSDATE,
2621: fnd_global.user_id,
2622: fnd_global.login_id ,
2623: SYSDATE,
2624: fnd_global.user_id,
2625: fnd_global.conc_request_id ,

Line 2622: fnd_global.login_id ,

2618: TRANSACTION_DATE)
2619: SELECT
2620: SYSDATE,
2621: fnd_global.user_id,
2622: fnd_global.login_id ,
2623: SYSDATE,
2624: fnd_global.user_id,
2625: fnd_global.conc_request_id ,
2626: fnd_global.prog_appl_id,

Line 2624: fnd_global.user_id,

2620: SYSDATE,
2621: fnd_global.user_id,
2622: fnd_global.login_id ,
2623: SYSDATE,
2624: fnd_global.user_id,
2625: fnd_global.conc_request_id ,
2626: fnd_global.prog_appl_id,
2627: fnd_global.conc_program_id ,
2628: SYSDATE,

Line 2625: fnd_global.conc_request_id ,

2621: fnd_global.user_id,
2622: fnd_global.login_id ,
2623: SYSDATE,
2624: fnd_global.user_id,
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,

Line 2626: fnd_global.prog_appl_id,

2622: fnd_global.login_id ,
2623: SYSDATE,
2624: fnd_global.user_id,
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,

Line 2627: fnd_global.conc_program_id ,

2623: SYSDATE,
2624: fnd_global.user_id,
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,

Line 2665: p_user_id => fnd_global.user_id,

2661: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2662: x_return_status => l_return_status,
2663: x_msg_count => l_msg_count,
2664: x_msg_data => l_msg_data,
2665: p_user_id => fnd_global.user_id,
2666: p_login_id => fnd_global.login_id,
2667: p_prg_appl_id => fnd_global.prog_appl_id,
2668: p_prg_id => fnd_global.conc_program_id,
2669: p_req_id => fnd_global.conc_request_id,

Line 2666: p_login_id => fnd_global.login_id,

2662: x_return_status => l_return_status,
2663: x_msg_count => l_msg_count,
2664: x_msg_data => l_msg_data,
2665: p_user_id => fnd_global.user_id,
2666: p_login_id => fnd_global.login_id,
2667: p_prg_appl_id => fnd_global.prog_appl_id,
2668: p_prg_id => fnd_global.conc_program_id,
2669: p_req_id => fnd_global.conc_request_id,
2670: p_wcti_group_id => l_costing_group_id,

Line 2667: p_prg_appl_id => fnd_global.prog_appl_id,

2663: x_msg_count => l_msg_count,
2664: x_msg_data => l_msg_data,
2665: p_user_id => fnd_global.user_id,
2666: p_login_id => fnd_global.login_id,
2667: p_prg_appl_id => fnd_global.prog_appl_id,
2668: p_prg_id => fnd_global.conc_program_id,
2669: p_req_id => fnd_global.conc_request_id,
2670: p_wcti_group_id => l_costing_group_id,
2671: p_org_id => p_organization_id

Line 2668: p_prg_id => fnd_global.conc_program_id,

2664: x_msg_data => l_msg_data,
2665: p_user_id => fnd_global.user_id,
2666: p_login_id => fnd_global.login_id,
2667: p_prg_appl_id => fnd_global.prog_appl_id,
2668: p_prg_id => fnd_global.conc_program_id,
2669: p_req_id => fnd_global.conc_request_id,
2670: p_wcti_group_id => l_costing_group_id,
2671: p_org_id => p_organization_id
2672: );

Line 2669: p_req_id => fnd_global.conc_request_id,

2665: p_user_id => fnd_global.user_id,
2666: p_login_id => fnd_global.login_id,
2667: p_prg_appl_id => fnd_global.prog_appl_id,
2668: p_prg_id => fnd_global.conc_program_id,
2669: p_req_id => fnd_global.conc_request_id,
2670: p_wcti_group_id => l_costing_group_id,
2671: p_org_id => p_organization_id
2672: );
2673: -- Bug 5370550

Line 2731: last_updated_by = fnd_global.user_id,

2727: AND wdj.ORGANIZATION_ID = p_organization_id
2728: AND wdj.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
2729: AND wdct.GROUP_ID = l_group_id),
2730: LAST_UPDATE_DATE = SYSDATE,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_login = fnd_global.login_id,
2733: STATUS_TYPE = WIP_CONSTANTS.CLOSED
2734: WHERE ORGANIZATION_ID = p_organization_id
2735: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID

Line 2732: last_update_login = fnd_global.login_id,

2728: AND wdj.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
2729: AND wdct.GROUP_ID = l_group_id),
2730: LAST_UPDATE_DATE = SYSDATE,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_login = fnd_global.login_id,
2733: STATUS_TYPE = WIP_CONSTANTS.CLOSED
2734: WHERE ORGANIZATION_ID = p_organization_id
2735: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2736: FROM WIP_DJ_CLOSE_TEMP

Line 2757: last_updated_by = fnd_global.user_id,

2753: WIP_CONSTANTS.LOTBASED ,
2754: WIP_CONSTANTS.CLOSED_OSFM ,
2755: WIP_CONSTANTS.CLOSED_DISC),
2756: LAST_UPDATE_DATE = SYSDATE,
2757: last_updated_by = fnd_global.user_id,
2758: last_update_login = fnd_global.login_id
2759: WHERE ORGANIZATION_ID = p_organization_id
2760: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
2761: FROM WIP_DJ_CLOSE_TEMP wdct

Line 2758: last_update_login = fnd_global.login_id

2754: WIP_CONSTANTS.CLOSED_OSFM ,
2755: WIP_CONSTANTS.CLOSED_DISC),
2756: LAST_UPDATE_DATE = SYSDATE,
2757: last_updated_by = fnd_global.user_id,
2758: last_update_login = fnd_global.login_id
2759: WHERE ORGANIZATION_ID = p_organization_id
2760: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
2761: FROM WIP_DJ_CLOSE_TEMP wdct
2762: WHERE wdct.ORGANIZATION_ID = p_organization_id

Line 2876: last_updated_by = fnd_global.user_id,

2872:
2873:
2874: UPDATE WIP_DISCRETE_JOBS wdj
2875: SET LAST_UPDATE_DATE = SYSDATE,
2876: last_updated_by = fnd_global.user_id,
2877: last_update_login = fnd_global.login_id,
2878: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
2879: WHERE ORGANIZATION_ID = p_organization_id
2880: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID

Line 2877: last_update_login = fnd_global.login_id,

2873:
2874: UPDATE WIP_DISCRETE_JOBS wdj
2875: SET LAST_UPDATE_DATE = SYSDATE,
2876: last_updated_by = fnd_global.user_id,
2877: last_update_login = fnd_global.login_id,
2878: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
2879: WHERE ORGANIZATION_ID = p_organization_id
2880: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2881: FROM WIP_DJ_CLOSE_TEMP