APPS.EDW_SEC_PKG dependencies on FND_PROFILE

Line 61: ses_resp_id := FND_PROFILE.VALUE('RESP_ID');

57:
58:
59: --Get responsibility_id
60:
61: ses_resp_id := FND_PROFILE.VALUE('RESP_ID');
62:
63: --Get database version
64:
65: DBMS_UTILITY.DB_VERSION(x_db_version, x_compatible);

Line 154: x_default_sec := FND_PROFILE.VALUE('EDW_DEFAULT_SECURITY');

150:
151:
152: --Get edw_default_security_profile
153:
154: x_default_sec := FND_PROFILE.VALUE('EDW_DEFAULT_SECURITY');
155: x_default_sec := UPPER(x_default_sec);
156:
157: dbms_session.set_context('edw_context', 'DEF_SEC_ENABLE', x_default_sec);
158:

Line 413: x_user_name := FND_PROFILE.VALUE('USERNAME');

409: -- Capture apps user and get person_id by going across db_link to fnd_user on master source instance.
410:
411: -- Find application user
412:
413: x_user_name := FND_PROFILE.VALUE('USERNAME');
414:
415:
416: -- Find master source instance
417:

Line 777: --ses_resp_id := FND_PROFILE.VALUE('RESP_ID');

773: edw_sec_pkg.set_context;
774:
775: --Get responsibility_id
776:
777: --ses_resp_id := FND_PROFILE.VALUE('RESP_ID');
778: ses_resp_id := SYS_CONTEXT( 'edw_context', 'resp_context');
779:
780: select distinct fact_id into x_fact_id
781: from edw_sec_fact_info_t