APPS.AP_WEB_PROXY_ASSIGN_PKG dependencies on AP_WEB_PROXY_ASSIGNMENTS

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 86: update ap_web_proxy_assignments

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;
90: close c1;

Line 106: update ap_web_proxy_assignments

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;
110: close c2;

Line 130: | this package to update the ap_web_proxy_assignments table, update fnd responsibilities

126: | this function is subscribed to following events:
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