DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on FND_GLOBAL

Line 1805: request_id = fnd_global.conc_request_id ,

1801: /*Bug 6908428*/
1802:
1803: UPDATE wip_discrete_jobs
1804: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
1805: request_id = fnd_global.conc_request_id ,
1806: last_update_date = sysdate,
1807: last_updated_by = fnd_global.user_id,
1808: last_update_login = fnd_global.login_id,
1809: program_application_id = fnd_global.prog_appl_id,

Line 1807: last_updated_by = fnd_global.user_id,

1803: UPDATE wip_discrete_jobs
1804: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
1805: request_id = fnd_global.conc_request_id ,
1806: last_update_date = sysdate,
1807: last_updated_by = fnd_global.user_id,
1808: last_update_login = fnd_global.login_id,
1809: program_application_id = fnd_global.prog_appl_id,
1810: program_id = fnd_global.conc_program_id
1811: WHERE organization_id = p_organization_id

Line 1808: last_update_login = fnd_global.login_id,

1804: SET status_type = WIP_CONSTANTS.PEND_CLOSE ,
1805: request_id = fnd_global.conc_request_id ,
1806: last_update_date = sysdate,
1807: last_updated_by = fnd_global.user_id,
1808: last_update_login = fnd_global.login_id,
1809: program_application_id = fnd_global.prog_appl_id,
1810: program_id = fnd_global.conc_program_id
1811: WHERE organization_id = p_organization_id
1812: AND wip_entity_id in (SELECT wip_entity_id

Line 1809: program_application_id = fnd_global.prog_appl_id,

1805: request_id = fnd_global.conc_request_id ,
1806: last_update_date = sysdate,
1807: last_updated_by = fnd_global.user_id,
1808: last_update_login = fnd_global.login_id,
1809: program_application_id = fnd_global.prog_appl_id,
1810: program_id = fnd_global.conc_program_id
1811: WHERE organization_id = p_organization_id
1812: AND wip_entity_id in (SELECT wip_entity_id
1813: FROM wip_dj_close_temp

Line 1810: program_id = fnd_global.conc_program_id

1806: last_update_date = sysdate,
1807: last_updated_by = fnd_global.user_id,
1808: last_update_login = fnd_global.login_id,
1809: program_application_id = fnd_global.prog_appl_id,
1810: program_id = fnd_global.conc_program_id
1811: WHERE organization_id = p_organization_id
1812: AND wip_entity_id in (SELECT wip_entity_id
1813: FROM wip_dj_close_temp
1814: WHERE group_id = l_group_id

Line 2120: fnd_global.user_id,

2116: ENTITY_TYPE,
2117: TRANSACTION_DATE)
2118: SELECT
2119: SYSDATE,
2120: fnd_global.user_id,
2121: fnd_global.login_id ,
2122: SYSDATE,
2123: fnd_global.user_id,
2124: fnd_global.conc_request_id ,

Line 2121: fnd_global.login_id ,

2117: TRANSACTION_DATE)
2118: SELECT
2119: SYSDATE,
2120: fnd_global.user_id,
2121: fnd_global.login_id ,
2122: SYSDATE,
2123: fnd_global.user_id,
2124: fnd_global.conc_request_id ,
2125: fnd_global.prog_appl_id,

Line 2123: fnd_global.user_id,

2119: SYSDATE,
2120: fnd_global.user_id,
2121: fnd_global.login_id ,
2122: SYSDATE,
2123: fnd_global.user_id,
2124: fnd_global.conc_request_id ,
2125: fnd_global.prog_appl_id,
2126: fnd_global.conc_program_id ,
2127: SYSDATE,

Line 2124: fnd_global.conc_request_id ,

2120: fnd_global.user_id,
2121: fnd_global.login_id ,
2122: SYSDATE,
2123: fnd_global.user_id,
2124: fnd_global.conc_request_id ,
2125: fnd_global.prog_appl_id,
2126: fnd_global.conc_program_id ,
2127: SYSDATE,
2128: WIP_TRANSACTIONS_S.nextval,

Line 2125: fnd_global.prog_appl_id,

2121: fnd_global.login_id ,
2122: SYSDATE,
2123: fnd_global.user_id,
2124: fnd_global.conc_request_id ,
2125: fnd_global.prog_appl_id,
2126: fnd_global.conc_program_id ,
2127: SYSDATE,
2128: WIP_TRANSACTIONS_S.nextval,
2129: oap.ACCT_PERIOD_ID,

Line 2126: fnd_global.conc_program_id ,

2122: SYSDATE,
2123: fnd_global.user_id,
2124: fnd_global.conc_request_id ,
2125: fnd_global.prog_appl_id,
2126: fnd_global.conc_program_id ,
2127: SYSDATE,
2128: WIP_TRANSACTIONS_S.nextval,
2129: oap.ACCT_PERIOD_ID,
2130: l_costing_group_id,

Line 2164: p_user_id => fnd_global.user_id,

2160: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
2161: x_return_status => l_return_status,
2162: x_msg_count => l_msg_count,
2163: x_msg_data => l_msg_data,
2164: p_user_id => fnd_global.user_id,
2165: p_login_id => fnd_global.login_id,
2166: p_prg_appl_id => fnd_global.prog_appl_id,
2167: p_prg_id => fnd_global.conc_program_id,
2168: p_req_id => fnd_global.conc_request_id,

Line 2165: p_login_id => fnd_global.login_id,

2161: x_return_status => l_return_status,
2162: x_msg_count => l_msg_count,
2163: x_msg_data => l_msg_data,
2164: p_user_id => fnd_global.user_id,
2165: p_login_id => fnd_global.login_id,
2166: p_prg_appl_id => fnd_global.prog_appl_id,
2167: p_prg_id => fnd_global.conc_program_id,
2168: p_req_id => fnd_global.conc_request_id,
2169: p_wcti_group_id => l_costing_group_id,

Line 2166: p_prg_appl_id => fnd_global.prog_appl_id,

2162: x_msg_count => l_msg_count,
2163: x_msg_data => l_msg_data,
2164: p_user_id => fnd_global.user_id,
2165: p_login_id => fnd_global.login_id,
2166: p_prg_appl_id => fnd_global.prog_appl_id,
2167: p_prg_id => fnd_global.conc_program_id,
2168: p_req_id => fnd_global.conc_request_id,
2169: p_wcti_group_id => l_costing_group_id,
2170: p_org_id => p_organization_id

Line 2167: p_prg_id => fnd_global.conc_program_id,

2163: x_msg_data => l_msg_data,
2164: p_user_id => fnd_global.user_id,
2165: p_login_id => fnd_global.login_id,
2166: p_prg_appl_id => fnd_global.prog_appl_id,
2167: p_prg_id => fnd_global.conc_program_id,
2168: p_req_id => fnd_global.conc_request_id,
2169: p_wcti_group_id => l_costing_group_id,
2170: p_org_id => p_organization_id
2171: );

Line 2168: p_req_id => fnd_global.conc_request_id,

2164: p_user_id => fnd_global.user_id,
2165: p_login_id => fnd_global.login_id,
2166: p_prg_appl_id => fnd_global.prog_appl_id,
2167: p_prg_id => fnd_global.conc_program_id,
2168: p_req_id => fnd_global.conc_request_id,
2169: p_wcti_group_id => l_costing_group_id,
2170: p_org_id => p_organization_id
2171: );
2172: -- Bug 5370550

Line 2227: last_updated_by = fnd_global.user_id,

2223: AND wdj.ORGANIZATION_ID = p_organization_id
2224: AND wdj.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
2225: AND wdct.GROUP_ID = l_group_id),
2226: LAST_UPDATE_DATE = SYSDATE,
2227: last_updated_by = fnd_global.user_id,
2228: last_update_login = fnd_global.login_id,
2229: STATUS_TYPE = WIP_CONSTANTS.CLOSED
2230: WHERE ORGANIZATION_ID = p_organization_id
2231: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID

Line 2228: last_update_login = fnd_global.login_id,

2224: AND wdj.WIP_ENTITY_ID = wdct.WIP_ENTITY_ID
2225: AND wdct.GROUP_ID = l_group_id),
2226: LAST_UPDATE_DATE = SYSDATE,
2227: last_updated_by = fnd_global.user_id,
2228: last_update_login = fnd_global.login_id,
2229: STATUS_TYPE = WIP_CONSTANTS.CLOSED
2230: WHERE ORGANIZATION_ID = p_organization_id
2231: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2232: FROM WIP_DJ_CLOSE_TEMP

Line 2246: last_updated_by = fnd_global.user_id,

2242: WIP_CONSTANTS.LOTBASED ,
2243: WIP_CONSTANTS.CLOSED_OSFM ,
2244: WIP_CONSTANTS.CLOSED_DISC),
2245: LAST_UPDATE_DATE = SYSDATE,
2246: last_updated_by = fnd_global.user_id,
2247: last_update_login = fnd_global.login_id
2248: WHERE ORGANIZATION_ID = p_organization_id
2249: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
2250: FROM WIP_DJ_CLOSE_TEMP wdct

Line 2247: last_update_login = fnd_global.login_id

2243: WIP_CONSTANTS.CLOSED_OSFM ,
2244: WIP_CONSTANTS.CLOSED_DISC),
2245: LAST_UPDATE_DATE = SYSDATE,
2246: last_updated_by = fnd_global.user_id,
2247: last_update_login = fnd_global.login_id
2248: WHERE ORGANIZATION_ID = p_organization_id
2249: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
2250: FROM WIP_DJ_CLOSE_TEMP wdct
2251: WHERE wdct.ORGANIZATION_ID = p_organization_id

Line 2362: last_updated_by = fnd_global.user_id,

2358:
2359:
2360: UPDATE WIP_DISCRETE_JOBS wdj
2361: SET LAST_UPDATE_DATE = SYSDATE,
2362: last_updated_by = fnd_global.user_id,
2363: last_update_login = fnd_global.login_id,
2364: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
2365: WHERE ORGANIZATION_ID = p_organization_id
2366: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID

Line 2363: last_update_login = fnd_global.login_id,

2359:
2360: UPDATE WIP_DISCRETE_JOBS wdj
2361: SET LAST_UPDATE_DATE = SYSDATE,
2362: last_updated_by = fnd_global.user_id,
2363: last_update_login = fnd_global.login_id,
2364: STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
2365: WHERE ORGANIZATION_ID = p_organization_id
2366: AND WIP_ENTITY_ID IN (SELECT WIP_ENTITY_ID
2367: FROM WIP_DJ_CLOSE_TEMP