APPS.FA_SECURITY dependencies on FA_SECURITY

Line 1: PACKAGE BODY FA_SECURITY AS

1: PACKAGE BODY FA_SECURITY AS
2: /* $Header: faxsecb.pls 120.8 2005/07/25 19:43:37 bridgway ship $ */
3:
4: /* =============================================================================
5: Name: build_predicate

Line 24: fnd_profile.get('FA_SECURITY_PROFILE_ID', l_security_profile_id);

20: if (not G_predicate_init or
21: G_user_id <> fnd_global.user_id or
22: G_resp_id <> fnd_global.resp_id) then
23:
24: fnd_profile.get('FA_SECURITY_PROFILE_ID', l_security_profile_id);
25:
26: IF (l_security_profile_id is NULL) THEN
27:
28: G_predicate_stmt := '';

Line 33: 'fa_security_profile_id',

29:
30: ELSE
31:
32: DBMS_SESSION.SET_CONTEXT('fixed_assets',
33: 'fa_security_profile_id',
34: l_security_profile_id);
35:
36: G_predicate_stmt :=
37: 'org_id is null or

Line 42: SYS_CONTEXT(''fixed_assets'', ''fa_security_profile_id''))';

38: org_id in
39: (SELECT organization_id
40: FROM per_organization_list
41: WHERE security_profile_id =
42: SYS_CONTEXT(''fixed_assets'', ''fa_security_profile_id''))';
43:
44: END IF;
45:
46: G_predicate_init := TRUE;

Line 61: END fa_security;

57: return g_predicate_stmt;
58:
59: END build_predicate;
60:
61: END fa_security;
62: