eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_PROXY_ASSIGN_PKG dependencies on FND_RESPONSIBILITY

Line 31: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,

27: pa.effective_start_date l_effecttive_start_date,
28: pa.effective_end_date l_effective_end_date,
29: b.application_id as resp_application_id,
30: d.responsibility_key, e.security_group_key
31: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,
32: fnd_responsibility d, fnd_security_groups e, per_people_f ppf
33: where pa.ASSIGNEE_ID = c.user_id
34: and pa.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
35: and pa.ASSIGNOR_ID = p_assignor_id

Line 32: fnd_responsibility d, fnd_security_groups e, per_people_f ppf

28: pa.effective_end_date l_effective_end_date,
29: b.application_id as resp_application_id,
30: d.responsibility_key, e.security_group_key
31: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,
32: fnd_responsibility d, fnd_security_groups e, per_people_f ppf
33: where pa.ASSIGNEE_ID = c.user_id
34: and pa.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
35: and pa.ASSIGNOR_ID = p_assignor_id
36: and b.language = userenv('LANG')

Line 52: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,

48: pa.effective_start_date l_effecttive_start_date,
49: pa.effective_end_date l_effective_end_date,
50: b.application_id as resp_application_id,
51: d.responsibility_key, e.security_group_key
52: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,
53: fnd_responsibility d, fnd_security_groups e, per_people_f ppf
54: where pa.ASSIGNEE_ID = c.user_id
55: and pa.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
56: and pa.ASSIGNOR_ID = p_assignor_id

Line 53: fnd_responsibility d, fnd_security_groups e, per_people_f ppf

49: pa.effective_end_date l_effective_end_date,
50: b.application_id as resp_application_id,
51: d.responsibility_key, e.security_group_key
52: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,
53: fnd_responsibility d, fnd_security_groups e, per_people_f ppf
54: where pa.ASSIGNEE_ID = c.user_id
55: and pa.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
56: and pa.ASSIGNOR_ID = p_assignor_id
57: and b.language = userenv('LANG')

Line 168: l_resp_id := p_event.GetValueForParameter('FND_RESPONSIBILITY_ID');

164:
165: if (l_event_name = 'oracle.apps.fnd.user.role.update') then
166:
167: l_user_id := p_event.GetValueForParameter('FND_USER_ID');
168: l_resp_id := p_event.GetValueForParameter('FND_RESPONSIBILITY_ID');
169: l_app_short_name := p_event.GetValueForParameter('FND_APPS_SHORT_NAME');
170: l_resp_app_id := p_event.GetValueForParameter('FND_RESPONSIBILITY_APPS_ID');
171:
172: select end_date, security_group_id

Line 170: l_resp_app_id := p_event.GetValueForParameter('FND_RESPONSIBILITY_APPS_ID');

166:
167: l_user_id := p_event.GetValueForParameter('FND_USER_ID');
168: l_resp_id := p_event.GetValueForParameter('FND_RESPONSIBILITY_ID');
169: l_app_short_name := p_event.GetValueForParameter('FND_APPS_SHORT_NAME');
170: l_resp_app_id := p_event.GetValueForParameter('FND_RESPONSIBILITY_APPS_ID');
171:
172: select end_date, security_group_id
173: into l_end_date, l_sec_group_id
174: from fnd_user_resp_groups_direct

Line 222: | p_resp_name fnd responsibility name