DBA Data[Home] [Help]

APPS.RRS_IMPORT_INTERFACE_PKG dependencies on FND_GLOBAL

Line 10: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

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

Line 11: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;

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

Line 12: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

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

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

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

Line 14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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

Line 15: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;

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

Line 2384: where user_id = FND_GLOBAL.USER_ID;

2380:
2381: select nvl(customer_id,person_party_id)
2382: into l_party_id
2383: from fnd_user
2384: where user_id = FND_GLOBAL.USER_ID;
2385:
2386:
2387: For c_check_grants in c_new_sites(p_batch_id) Loop
2388:

Line 2389: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => c_check_grants.site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

2385:
2386:
2387: For c_check_grants in c_new_sites(p_batch_id) Loop
2388:
2389: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => c_check_grants.site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
2390:
2391: FND_FILE.PUT_LINE(FND_FILE.LOG,'User has View Site access for Site : '||c_check_grants.site_id );
2392: l_view_priv := 'Y';
2393:

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

2394: end if;
2395:
2396: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_EDIT_SITE',
2397: p_object_name => 'RRS_SITE', p_object_key => c_check_grants.site_id,
2398: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
2399:
2400: l_edit_priv := 'Y';
2401:
2402:

Line 3169: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => site_data.site_id_intf, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

3165: /* RBAC 2 validations start */
3166: if l_security_enabled = 'Y' then
3167:
3168:
3169: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => site_data.site_id_intf, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
3170:
3171: null;
3172: else
3173: l_row_status := 'E';

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

3189: end if;
3190:
3191: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => l_api_version, p_privilege => 'RRS_EDIT_SITE',
3192: p_object_name => 'RRS_SITE', p_object_key => site_data.site_id_intf,
3193: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
3194:
3195: null;
3196: else
3197: l_row_status := 'E';