DBA Data[Home] [Help]

APPS.POS_BULKLOAD_ENTITIES dependencies on FND_GLOBAL

Line 8: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

4: ----------------------------------------------------------------------------
5: -- Global constants
6: ----------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';
8: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;

5: -- Global constants
6: ----------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';
8: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;

Line 10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

6: ----------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';
8: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
14: G_CURRENT_USER_ID NUMBER;

Line 11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';
8: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
14: G_CURRENT_USER_ID NUMBER;
15: G_CURRENT_LOGIN_ID NUMBER;

Line 12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

8: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
14: G_CURRENT_USER_ID NUMBER;
15: G_CURRENT_LOGIN_ID NUMBER;
16: G_API_VERSION NUMBER := 1.0;

Line 13: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;

9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
14: G_CURRENT_USER_ID NUMBER;
15: G_CURRENT_LOGIN_ID NUMBER;
16: G_API_VERSION NUMBER := 1.0;
17: G_HZ_PARTY_ID VARCHAR2(30);

Line 1224: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

1220: Write_Conclog('User Defined Attributes Import Program *STARTED*');
1221: UPDATE EGO_BULKLOAD_INTF
1222: SET
1223: PROCESS_STATUS = G_PS_IN_PROCESS,
1224: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1225: REQUEST_ID = FND_GLOBAL.conc_request_id,
1226: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1227: PROGRAM_ID = FND_GLOBAL.conc_program_id
1228: WHERE RESULTFMT_USAGE_ID = result_format_usage_id

Line 1225: REQUEST_ID = FND_GLOBAL.conc_request_id,

1221: UPDATE EGO_BULKLOAD_INTF
1222: SET
1223: PROCESS_STATUS = G_PS_IN_PROCESS,
1224: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1225: REQUEST_ID = FND_GLOBAL.conc_request_id,
1226: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1227: PROGRAM_ID = FND_GLOBAL.conc_program_id
1228: WHERE RESULTFMT_USAGE_ID = result_format_usage_id
1229: AND process_status = G_PS_TO_BE_PROCESSED;

Line 1226: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

1222: SET
1223: PROCESS_STATUS = G_PS_IN_PROCESS,
1224: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1225: REQUEST_ID = FND_GLOBAL.conc_request_id,
1226: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1227: PROGRAM_ID = FND_GLOBAL.conc_program_id
1228: WHERE RESULTFMT_USAGE_ID = result_format_usage_id
1229: AND process_status = G_PS_TO_BE_PROCESSED;
1230:

Line 1227: PROGRAM_ID = FND_GLOBAL.conc_program_id

1223: PROCESS_STATUS = G_PS_IN_PROCESS,
1224: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1225: REQUEST_ID = FND_GLOBAL.conc_request_id,
1226: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1227: PROGRAM_ID = FND_GLOBAL.conc_program_id
1228: WHERE RESULTFMT_USAGE_ID = result_format_usage_id
1229: AND process_status = G_PS_TO_BE_PROCESSED;
1230:
1231: --Bug 16384042 Calling Resolve PK Values to set PK3 and PK4 in EBI table

Line 1276: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

1272:
1273: IF l_retcode = 'S' THEN
1274: UPDATE EGO_BULKLOAD_INTF
1275: SET PROCESS_STATUS = G_PS_SUCCESS,
1276: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1277: REQUEST_ID = FND_GLOBAL.conc_request_id,
1278: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1279: PROGRAM_ID = FND_GLOBAL.conc_program_id
1280: WHERE RESULTFMT_USAGE_ID = result_format_usage_id

Line 1277: REQUEST_ID = FND_GLOBAL.conc_request_id,

1273: IF l_retcode = 'S' THEN
1274: UPDATE EGO_BULKLOAD_INTF
1275: SET PROCESS_STATUS = G_PS_SUCCESS,
1276: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1277: REQUEST_ID = FND_GLOBAL.conc_request_id,
1278: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1279: PROGRAM_ID = FND_GLOBAL.conc_program_id
1280: WHERE RESULTFMT_USAGE_ID = result_format_usage_id
1281: AND process_status = G_PS_IN_PROCESS;

Line 1278: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

1274: UPDATE EGO_BULKLOAD_INTF
1275: SET PROCESS_STATUS = G_PS_SUCCESS,
1276: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1277: REQUEST_ID = FND_GLOBAL.conc_request_id,
1278: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1279: PROGRAM_ID = FND_GLOBAL.conc_program_id
1280: WHERE RESULTFMT_USAGE_ID = result_format_usage_id
1281: AND process_status = G_PS_IN_PROCESS;
1282: END IF ;

Line 1279: PROGRAM_ID = FND_GLOBAL.conc_program_id

1275: SET PROCESS_STATUS = G_PS_SUCCESS,
1276: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1277: REQUEST_ID = FND_GLOBAL.conc_request_id,
1278: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
1279: PROGRAM_ID = FND_GLOBAL.conc_program_id
1280: WHERE RESULTFMT_USAGE_ID = result_format_usage_id
1281: AND process_status = G_PS_IN_PROCESS;
1282: END IF ;
1283: ERRBUF := l_errbuf;