APPS.AP_WEB_PROXY_ASSIGN_PKG dependencies on FND_USER

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 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 84: -- call fnd_user_pkg.addResp l_assignee_name,

80: 'UPDATED',
81: l_effective_start_date,
82: l_end_date);
83: end if;
84: -- call fnd_user_pkg.addResp l_assignee_name,
85: FND_USER_PKG.addresp(l_assignee_name, p_app_short_name, l_resp_key, l_sec_key, null, l_effective_start_date, l_end_date);
86: update ap_web_proxy_assignments
87: set effective_end_date = l_end_date
88: where current of c1;

Line 85: FND_USER_PKG.addresp(l_assignee_name, p_app_short_name, l_resp_key, l_sec_key, null, l_effective_start_date, l_end_date);

81: l_effective_start_date,
82: l_end_date);
83: end if;
84: -- call fnd_user_pkg.addResp l_assignee_name,
85: FND_USER_PKG.addresp(l_assignee_name, p_app_short_name, l_resp_key, l_sec_key, null, l_effective_start_date, l_end_date);
86: update ap_web_proxy_assignments
87: set effective_end_date = l_end_date
88: where current of c1;
89: end loop;

Line 104: -- call fnd_user_pkg.addResp

100: 'UPDATED',
101: l_effective_start_date,
102: l_end_date);
103: end if;
104: -- call fnd_user_pkg.addResp
105: FND_USER_PKG.addresp(l_assignee_name, p_app_short_name, l_resp_key, l_sec_key, null, l_effective_start_date, l_end_date);
106: update ap_web_proxy_assignments
107: set effective_end_date = l_end_date
108: where current of c2;

Line 105: FND_USER_PKG.addresp(l_assignee_name, p_app_short_name, l_resp_key, l_sec_key, null, l_effective_start_date, l_end_date);

101: l_effective_start_date,
102: l_end_date);
103: end if;
104: -- call fnd_user_pkg.addResp
105: FND_USER_PKG.addresp(l_assignee_name, p_app_short_name, l_resp_key, l_sec_key, null, l_effective_start_date, l_end_date);
106: update ap_web_proxy_assignments
107: set effective_end_date = l_end_date
108: where current of c2;
109: end loop;

Line 131: | by calling fnd_user_pkg.addresp api and sending notificaiton to assignee.

127: | oracle.apps.fnd.wf.ds.userRole.updated
128: | oracle.apps.fnd.wf.ds.user.updated
129: | Based on event key and its paramters, function would call other private procedure within
130: | this package to update the ap_web_proxy_assignments table, update fnd responsibilities
131: | by calling fnd_user_pkg.addresp api and sending notificaiton to assignee.
132: |
133: | PARAMETERS
134: | p_subscription_guid
135: | p_event

Line 165: if (l_event_name = 'oracle.apps.fnd.user.role.update') then

161: end if;
162: l_event_name := p_event.getEventName();
163: l_event_key := p_event.GetEventKey;
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');

Line 167: l_user_id := p_event.GetValueForParameter('FND_USER_ID');

163: l_event_key := p_event.GetEventKey;
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:

Line 174: from fnd_user_resp_groups_direct

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
175: where responsibility_id = l_resp_id
176: and user_id = l_user_id
177: and rownum = 1;
178:

Line 188: into l_user_id, l_end_date from fnd_user

184: or ((p_event.GetValueForParameter('EXPIRATION_DATE')) <
185: (p_event.GetValueForParameter('OLD_END_DATE')) ) ) then
186: l_user_name := p_event.GetValueForParameter('USER_NAME');
187: select user_id, nvl(end_date, sysdate)
188: into l_user_id, l_end_date from fnd_user
189: where user_name = l_event_key;
190: end if;
191: end if;
192: -- this event to capture when an employee is terminated

Line 221: | p_user_name fnd user name

217: | assigned/ udpated Message indicates the responsibility name,
218: | start date and end date.
219: |
220: | PARAMETERS
221: | p_user_name fnd user name
222: | p_resp_name fnd responsibility name
223: | p_assignor_name fnd user_name of assignor
224: | p_start_date start date for the repsonsibility
225: | p_end_date end date for the responsibility.

Line 223: | p_assignor_name fnd user_name of assignor

219: |
220: | PARAMETERS
221: | p_user_name fnd user name
222: | p_resp_name fnd responsibility name
223: | p_assignor_name fnd user_name of assignor
224: | p_start_date start date for the repsonsibility
225: | p_end_date end date for the responsibility.
226: |
227: *----------------------------------------------------------------------------*/

Line 257: from fnd_user fu, hr_employees hre

253:
254: -- get Assignor full name from db
255: select full_name
256: into l_full_name
257: from fnd_user fu, hr_employees hre
258: where fu.employee_id = hre.employee_id
259: and user_name = p_assignor_name;
260:
261: -- Fetch the message used as the confirmation message subject