APPS.ZX_HR_LOCATIONS_REPORTING_HOOK dependencies on FND_GLOBAL

Line 68: X_REQUEST_ID => fnd_global.conc_request_id ,

64: X_EXCEPTION_CODE => NULL ,
65: X_EFFECTIVE_FROM => sysdate ,
66: X_EFFECTIVE_TO => NULL ,
67: X_RECORD_TYPE_CODE => 'USER_DEFINED' ,
68: X_REQUEST_ID => fnd_global.conc_request_id ,
69: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,
70: X_REPORTING_CODE_NAME => p_location_code ,
71: X_CREATION_DATE => sysdate ,
72: X_CREATED_BY => fnd_global.user_id ,

Line 69: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,

65: X_EFFECTIVE_FROM => sysdate ,
66: X_EFFECTIVE_TO => NULL ,
67: X_RECORD_TYPE_CODE => 'USER_DEFINED' ,
68: X_REQUEST_ID => fnd_global.conc_request_id ,
69: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,
70: X_REPORTING_CODE_NAME => p_location_code ,
71: X_CREATION_DATE => sysdate ,
72: X_CREATED_BY => fnd_global.user_id ,
73: X_LAST_UPDATE_DATE => sysdate ,

Line 72: X_CREATED_BY => fnd_global.user_id ,

68: X_REQUEST_ID => fnd_global.conc_request_id ,
69: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,
70: X_REPORTING_CODE_NAME => p_location_code ,
71: X_CREATION_DATE => sysdate ,
72: X_CREATED_BY => fnd_global.user_id ,
73: X_LAST_UPDATE_DATE => sysdate ,
74: X_LAST_UPDATED_BY => fnd_global.user_id ,
75: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
76: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,

Line 74: X_LAST_UPDATED_BY => fnd_global.user_id ,

70: X_REPORTING_CODE_NAME => p_location_code ,
71: X_CREATION_DATE => sysdate ,
72: X_CREATED_BY => fnd_global.user_id ,
73: X_LAST_UPDATE_DATE => sysdate ,
74: X_LAST_UPDATED_BY => fnd_global.user_id ,
75: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
76: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
77: X_PROGRAM_ID => fnd_global.conc_program_id ,
78: X_OBJECT_VERSION_NUMBER => 1);

Line 75: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,

71: X_CREATION_DATE => sysdate ,
72: X_CREATED_BY => fnd_global.user_id ,
73: X_LAST_UPDATE_DATE => sysdate ,
74: X_LAST_UPDATED_BY => fnd_global.user_id ,
75: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
76: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
77: X_PROGRAM_ID => fnd_global.conc_program_id ,
78: X_OBJECT_VERSION_NUMBER => 1);
79: END LOOP;

Line 76: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,

72: X_CREATED_BY => fnd_global.user_id ,
73: X_LAST_UPDATE_DATE => sysdate ,
74: X_LAST_UPDATED_BY => fnd_global.user_id ,
75: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
76: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
77: X_PROGRAM_ID => fnd_global.conc_program_id ,
78: X_OBJECT_VERSION_NUMBER => 1);
79: END LOOP;
80: END IF;

Line 77: X_PROGRAM_ID => fnd_global.conc_program_id ,

73: X_LAST_UPDATE_DATE => sysdate ,
74: X_LAST_UPDATED_BY => fnd_global.user_id ,
75: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
76: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
77: X_PROGRAM_ID => fnd_global.conc_program_id ,
78: X_OBJECT_VERSION_NUMBER => 1);
79: END LOOP;
80: END IF;
81: END IF;

Line 219: X_REQUEST_ID => fnd_global.conc_request_id ,

215: X_EXCEPTION_CODE => NULL ,
216: X_EFFECTIVE_FROM => sysdate ,
217: X_EFFECTIVE_TO => NULL ,
218: X_RECORD_TYPE_CODE => 'USER_DEFINED' ,
219: X_REQUEST_ID => fnd_global.conc_request_id ,
220: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,
221: X_REPORTING_CODE_NAME => p_location_code ,
222: X_CREATION_DATE => sysdate ,
223: X_CREATED_BY => fnd_global.user_id ,

Line 220: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,

216: X_EFFECTIVE_FROM => sysdate ,
217: X_EFFECTIVE_TO => NULL ,
218: X_RECORD_TYPE_CODE => 'USER_DEFINED' ,
219: X_REQUEST_ID => fnd_global.conc_request_id ,
220: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,
221: X_REPORTING_CODE_NAME => p_location_code ,
222: X_CREATION_DATE => sysdate ,
223: X_CREATED_BY => fnd_global.user_id ,
224: X_LAST_UPDATE_DATE => sysdate ,

Line 223: X_CREATED_BY => fnd_global.user_id ,

219: X_REQUEST_ID => fnd_global.conc_request_id ,
220: X_PROGRAM_LOGIN_ID => fnd_global.conc_login_id ,
221: X_REPORTING_CODE_NAME => p_location_code ,
222: X_CREATION_DATE => sysdate ,
223: X_CREATED_BY => fnd_global.user_id ,
224: X_LAST_UPDATE_DATE => sysdate ,
225: X_LAST_UPDATED_BY => fnd_global.user_id ,
226: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
227: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,

Line 225: X_LAST_UPDATED_BY => fnd_global.user_id ,

221: X_REPORTING_CODE_NAME => p_location_code ,
222: X_CREATION_DATE => sysdate ,
223: X_CREATED_BY => fnd_global.user_id ,
224: X_LAST_UPDATE_DATE => sysdate ,
225: X_LAST_UPDATED_BY => fnd_global.user_id ,
226: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
227: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
228: X_PROGRAM_ID => fnd_global.conc_program_id ,
229: X_OBJECT_VERSION_NUMBER => 1);

Line 226: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,

222: X_CREATION_DATE => sysdate ,
223: X_CREATED_BY => fnd_global.user_id ,
224: X_LAST_UPDATE_DATE => sysdate ,
225: X_LAST_UPDATED_BY => fnd_global.user_id ,
226: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
227: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
228: X_PROGRAM_ID => fnd_global.conc_program_id ,
229: X_OBJECT_VERSION_NUMBER => 1);
230:

Line 227: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,

223: X_CREATED_BY => fnd_global.user_id ,
224: X_LAST_UPDATE_DATE => sysdate ,
225: X_LAST_UPDATED_BY => fnd_global.user_id ,
226: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
227: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
228: X_PROGRAM_ID => fnd_global.conc_program_id ,
229: X_OBJECT_VERSION_NUMBER => 1);
230:
231: SELECT reporting_code_id

Line 228: X_PROGRAM_ID => fnd_global.conc_program_id ,

224: X_LAST_UPDATE_DATE => sysdate ,
225: X_LAST_UPDATED_BY => fnd_global.user_id ,
226: X_LAST_UPDATE_LOGIN => fnd_global.user_id ,
227: X_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id ,
228: X_PROGRAM_ID => fnd_global.conc_program_id ,
229: X_OBJECT_VERSION_NUMBER => 1);
230:
231: SELECT reporting_code_id
232: BULK COLLECT INTO