APPS.RRS_IMPORT_INTERFACE_PKG dependencies on FND_PROFILE

Line 506: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');

502: x_num_rows number;
503:
504: l_site_id_num number;
505: l_site_id_num_exist varchar2(30);
506: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');
507: l_site_author_role VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_AUTO_ASSIGN_SITE_AUTHOR'),'N');
508: l_security_passed VARCHAR2(1) := 'Y';
509:
510: l_msg VARCHAR2(1000);

Line 507: l_site_author_role VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_AUTO_ASSIGN_SITE_AUTHOR'),'N');

503:
504: l_site_id_num number;
505: l_site_id_num_exist varchar2(30);
506: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');
507: l_site_author_role VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_AUTO_ASSIGN_SITE_AUTHOR'),'N');
508: l_security_passed VARCHAR2(1) := 'Y';
509:
510: l_msg VARCHAR2(1000);
511: Begin

Line 577: IF (FND_PROFILE.VALUE('RRS_AUTO_DEFAULT_SITE_NUM') = '1' ) then

573: * ***********************************************************/
574:
575: If l_security_passed = 'Y' then
576:
577: IF (FND_PROFILE.VALUE('RRS_AUTO_DEFAULT_SITE_NUM') = '1' ) then
578:
579:
580: FOR site_id_num IN c_default_site_id_num(l_batch_id) LOOP
581:

Line 1185: IF (FND_PROFILE.VALUE('RRS_GEOCODE_SRC_PREFERENCE') = 'RRS_USER_ENTERED') then

1181:
1182: elsif site_data.GEOMETRY_SOURCE is NULL and site_data.LONGITUDE is NULL and site_data.LATITUDE is NULL then
1183: If site_data.location_status = 'N' then
1184:
1185: IF (FND_PROFILE.VALUE('RRS_GEOCODE_SRC_PREFERENCE') = 'RRS_USER_ENTERED') then
1186: l_geo_source := 'RRS_USER_ENTERED';
1187: else
1188: l_geo_source := 'RRS_GOOGLE';
1189: end if;

Line 1201: IF (FND_PROFILE.VALUE('RRS_GEOCODE_SRC_PREFERENCE') = 'RRS_USER_ENTERED') then

1197: from hz_locations
1198: where location_id = site_data.location_id;
1199:
1200: If l_db_geo_source is NULL then
1201: IF (FND_PROFILE.VALUE('RRS_GEOCODE_SRC_PREFERENCE') = 'RRS_USER_ENTERED') then
1202: l_geo_source := 'RRS_USER_ENTERED';
1203: else
1204: l_geo_source := 'RRS_GOOGLE';
1205: end if;

Line 2207: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');

2203: and RSI.transaction_type = G_TX_TYPE_CREATE;
2204:
2205: conc_status Boolean;
2206: l_api_version Number := 1.0;
2207: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');
2208: l_site_author_role VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_AUTO_ASSIGN_SITE_AUTHOR'),'N');
2209: l_errorcode NUMBER;
2210: l_return_status VARCHAR2(1);
2211: -- l_grant_guid FND_GRANTS.GRANT_GUID%TYPE;

Line 2208: l_site_author_role VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_AUTO_ASSIGN_SITE_AUTHOR'),'N');

2204:
2205: conc_status Boolean;
2206: l_api_version Number := 1.0;
2207: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');
2208: l_site_author_role VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_AUTO_ASSIGN_SITE_AUTHOR'),'N');
2209: l_errorcode NUMBER;
2210: l_return_status VARCHAR2(1);
2211: -- l_grant_guid FND_GRANTS.GRANT_GUID%TYPE;
2212: l_grant_guid RAW(16);

Line 2586: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');

2582: x_num_rows number;
2583: p_object_version_number number;
2584:
2585: l_api_version Number := 1.0;
2586: l_security_enabled VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');
2587: l_security_passed VARCHAR2(1) := 'Y';
2588:
2589: l_msg VARCHAR2(1000);
2590: