DBA Data[Home] [Help]

APPS.AMW_FINDINGS_PKG dependencies on FND_GLOBAL

Line 91: where responsibility_id = fnd_global.resp_id()

87:
88: select responsibility_key
89: into respkey
90: from fnd_responsibility_vl
91: where responsibility_id = fnd_global.resp_id()
92: and application_id = fnd_global.resp_appl_id();
93:
94: -- Always show for super user.
95:

Line 92: and application_id = fnd_global.resp_appl_id();

88: select responsibility_key
89: into respkey
90: from fnd_responsibility_vl
91: where responsibility_id = fnd_global.resp_id()
92: and application_id = fnd_global.resp_appl_id();
93:
94: -- Always show for super user.
95:
96: if ( respkey = 'AMW_SSW_NEW_RESP' ) then

Line 127: -- if ( AMW_WF_HIERARCHY_PKG.hasOrgAccess ( fnd_global.user_id(), org_id ) = 1 ) then

123: -- if ( change_category = 'AMW_PROC_CERT_ISSUES' ) then
124: --
125: -- -- Allow to create if current user is the owner of process or manager of org.
126: --
127: -- if ( AMW_WF_HIERARCHY_PKG.hasOrgAccess ( fnd_global.user_id(), org_id ) = 1 ) then
128: -- return 1;
129: -- end if;
130: --
131: -- select count ( fnd_user.person_party_id )

Line 136: -- and fnd_user.user_id = fnd_global.user_id()

132: -- into temp
133: -- from fnd_user, amw_process_all_vl proc, amw_proc_hierarchy_denorm aphd
134: -- where ( proc.process_id = myprocess_id
135: -- and proc.process_owner_id = fnd_user.person_party_id
136: -- and fnd_user.user_id = fnd_global.user_id()
137: -- )
138: -- or
139: -- (
140: -- aphd.process_id = myprocess_id

Line 144: -- and fnd_user.user_id = fnd_global.user_id()

140: -- aphd.process_id = myprocess_id
141: -- and aphd.up_down_ind = 'U'
142: -- and aphd.parent_child_id = proc.process_id
143: -- and proc.process_owner_id = fnd_user.person_party_id
144: -- and fnd_user.user_id = fnd_global.user_id()
145: -- );
146: --
147: -- if ( temp > 0 ) then
148: -- return 1;