DBA Data[Home] [Help]

APPS.RRS_SITE_UDA_BULKLOAD_INTF 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) := 'RRS_SITE_UDA_BULKLOAD_INTF';
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) := 'RRS_SITE_UDA_BULKLOAD_INTF';
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) := 'RRS_SITE_UDA_BULKLOAD_INTF';
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) := 'RRS_SITE_UDA_BULKLOAD_INTF';
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 357: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => G_API_VERSION, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => l_site_id_list(i).site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

353: p_processing_errors := rrs_processing_errors_tab();
354: local_processing_errors := rrs_processing_errors_tab();
355:
356:
357: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => G_API_VERSION, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => l_site_id_list(i).site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
358:
359: null;
360: else
361: l_row_status := 'E';

Line 382: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

378: end if;
379:
380: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => G_API_VERSION, p_privilege => 'RRS_EDIT_SITE',
381: p_object_name => 'RRS_SITE', p_object_key => l_site_id_list(i).site_id,
382: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
383:
384: null;
385: else
386: l_row_status := 'E';

Line 780: WHERE request_id = fnd_global.conc_request_id

776: ,'3'
777: ,NULL
778: ,p_batch_id
779: FROM mtl_interface_errors
780: WHERE request_id = fnd_global.conc_request_id
781: AND program_application_id = FND_GLOBAL.PROG_APPL_ID;
782:
783: END;
784:

Line 781: AND program_application_id = FND_GLOBAL.PROG_APPL_ID;

777: ,NULL
778: ,p_batch_id
779: FROM mtl_interface_errors
780: WHERE request_id = fnd_global.conc_request_id
781: AND program_application_id = FND_GLOBAL.PROG_APPL_ID;
782:
783: END;
784:
785: