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.ZPB_USER_UPDATE dependencies on FND_USER

Line 28: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c

24: l_user_exists VARCHAR2(1);
25:
26: cursor usernames is
27: select /*+ LEADING (c) */ distinct(a.user_name) name, a.user_id
28: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c
29: where a.user_id=b.user_id
30: and b.responsibility_id=c.responsibility_id
31: and c.application_id=n_epbproductid;
32:

Line 42: fnd_user u

38: CURSOR expired_user_resp_csr
39: IS
40: SELECT z.user_id, z.resp_id
41: FROM zpb_account_states z,
42: fnd_user u
43: WHERE z.user_id = u.user_id
44: AND (u.end_date IS NOT NULL AND u.end_date < SYSDATE)
45: AND z.business_area_id = p_business_area_id
46: UNION

Line 49: fnd_user_resp_groups_all u,

45: AND z.business_area_id = p_business_area_id
46: UNION
47: SELECT /*+ LEADING (r) */ z.user_id, z.resp_id
48: FROM zpb_account_states z,
49: fnd_user_resp_groups_all u,
50: fnd_responsibility r
51: WHERE z.user_id = u.user_id
52: AND z.resp_id = u.responsibility_id
53: AND (u.end_date IS NOT NULL AND u.end_date < SYSDATE)

Line 72: fnd_user u

68: CURSOR new_user_resp_csr
69: IS
70: SELECT z.user_id, z.resp_id
71: FROM zpb_account_states z,
72: fnd_user u
73: WHERE z.user_id = u.user_id
74: AND (u.end_date IS NULL OR u.end_date >= SYSDATE)
75: AND z.business_area_id = p_business_area_id
76: UNION

Line 79: fnd_user_resp_groups_all u

75: AND z.business_area_id = p_business_area_id
76: UNION
77: SELECT /*+ LEADING (z) */ z.user_id, z.resp_id
78: FROM zpb_account_states z,
79: fnd_user_resp_groups_all u
80: WHERE z.user_id = u.user_id
81: AND (u.end_date IS NULL OR u.end_date >= SYSDATE)
82: AND z.business_area_id = p_business_area_id
83: AND responsibility_application_id = n_epbproductid

Line 96: FROM fnd_user_resp_groups a, fnd_responsibility b

92:
93: CURSOR brand_new_user_resp_csr
94: IS
95: SELECT /*+ LEADING (b) */ a.user_id, a.responsibility_id resp_id
96: FROM fnd_user_resp_groups a, fnd_responsibility b
97: WHERE a.responsibility_id = b.responsibility_id
98: AND b.application_id = n_epbproductid
99: MINUS
100: SELECT user_id, resp_id

Line 116: from fnd_user a,

112: b1.subject_type user_sub_type,
113: b2.subject_id resp_sub_id,
114: b2.subject_type resp_sub_type,
115: b2.subject_name resp_sub_name
116: from fnd_user a,
117: fnd_user_resp_groups b,
118: fnd_responsibility c,
119: bism_subjects b1,
120: bism_subjects b2

Line 117: fnd_user_resp_groups b,

113: b2.subject_id resp_sub_id,
114: b2.subject_type resp_sub_type,
115: b2.subject_name resp_sub_name
116: from fnd_user a,
117: fnd_user_resp_groups b,
118: fnd_responsibility c,
119: bism_subjects b1,
120: bism_subjects b2
121: where a.user_id = b.user_id and

Line 139: from fnd_user a,

135: select subject_name from bism_subjects
136: where subject_name <> BIBEANS and subject_name <> ZPBUSER
137: minus
138: (select /*+ LEADING (c) */ distinct(a.user_name)
139: from fnd_user a,
140: fnd_user_resp_groups b,
141: fnd_responsibility c
142: where a.user_id=b.user_id
143: and (a.end_date is NULL or a.end_date >= SYSDATE)

Line 140: fnd_user_resp_groups b,

136: where subject_name <> BIBEANS and subject_name <> ZPBUSER
137: minus
138: (select /*+ LEADING (c) */ distinct(a.user_name)
139: from fnd_user a,
140: fnd_user_resp_groups b,
141: fnd_responsibility c
142: where a.user_id=b.user_id
143: and (a.end_date is NULL or a.end_date >= SYSDATE)
144: and b.responsibility_id=c.responsibility_id

Line 158: fnd_user a,

154: cursor reinstated is
155: select /*+LEADING (x) */ y.subject_name
156: from zpb_account_states x,
157: bism_subjects y,
158: fnd_user a,
159: fnd_user_resp_groups b,
160: fnd_responsibility c
161: where x.subject_id = y.subject_id
162: and x.business_area_id = p_business_area_id

Line 159: fnd_user_resp_groups b,

155: select /*+LEADING (x) */ y.subject_name
156: from zpb_account_states x,
157: bism_subjects y,
158: fnd_user a,
159: fnd_user_resp_groups b,
160: fnd_responsibility c
161: where x.subject_id = y.subject_id
162: and x.business_area_id = p_business_area_id
163: and x.account_status in (EXP_USER, HIDE_ACCOUNT)

Line 186: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c

182: and g.subject_id = s.group_id
183: and s.business_area_id = p_business_area_id
184: minus
185: (select /*+ LEADING (c) */ a.user_name, c.responsibility_key
186: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c
187: where a.user_id = b.user_id
188: and (b.end_date is NULL or b.end_date > SYSDATE)
189: and b.responsibility_id=c.responsibility_id
190: and c.application_id=n_epbproductid);

Line 195: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c,

191:
192: -- roles resinstated for an active user.
193: cursor reinstatedroles is
194: select /*+LEADING (s) */ a.user_name uname, c.responsibility_key gname
195: from fnd_user a, fnd_user_resp_groups b, fnd_responsibility c,
196: zpb_account_states s, bism_subjects u, bism_subjects g
197: where a.user_id = b.user_id
198: and (a.end_date is NULL or a.end_date > SYSDATE)
199: and (b.end_date is NULL or b.end_date > SYSDATE)

Line 214: -- loop for adding users to the Catalog from the fnd_user table

210: -- check logging requirement for this module
211: b_writetolog := (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
212: --FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME);
213:
214: -- loop for adding users to the Catalog from the fnd_user table
215: for each in usernames loop
216: if length(each.name) <= n_namelength then
217: begin
218: b_userexists := true;

Line 333: fnd_user b

329:
330: SELECT subject_id
331: INTO l_subj_user_id
332: FROM bism_subjects a,
333: fnd_user b
334: WHERE a.subject_name = b.user_name
335: AND b.user_id = brand_new_user_resp_rec.user_id
336: AND a.subject_type = 'u';
337:

Line 703: fnd_user u

699: CURSOR expired_sec_user_resp_csr
700: IS
701: SELECT z.user_id, z.resp_id
702: FROM zpb_account_states z,
703: fnd_user u
704: WHERE z.user_id = u.user_id
705: AND (u.end_date IS NOT NULL AND u.end_date < SYSDATE)
706: AND z.business_area_id = p_business_area_id
707: UNION

Line 710: fnd_user_resp_groups_all u,

706: AND z.business_area_id = p_business_area_id
707: UNION
708: SELECT /*+ LEADING (r) */ z.user_id, z.resp_id
709: FROM zpb_account_states z,
710: fnd_user_resp_groups_all u,
711: fnd_responsibility r
712: WHERE z.user_id = u.user_id
713: AND z.resp_id = u.responsibility_id
714: AND z.resp_id = r.responsibility_id

Line 734: fnd_user b,

730: CURSOR new_sec_user_resp_csr
731: IS
732: SELECT a.user_id, a.resp_id
733: FROM zpb_account_states a,
734: fnd_user b,
735: fnd_responsibility c,
736: fnd_user_resp_groups d,
737: zpb_busarea_users e
738: WHERE a.user_id = b.user_id

Line 736: fnd_user_resp_groups d,

732: SELECT a.user_id, a.resp_id
733: FROM zpb_account_states a,
734: fnd_user b,
735: fnd_responsibility c,
736: fnd_user_resp_groups d,
737: zpb_busarea_users e
738: WHERE a.user_id = b.user_id
739: AND a.resp_id = c.responsibility_id
740: AND a.resp_id = d.responsibility_id

Line 779: FND_USER_RESP_GROUPS B,

775: FND_GLOBAL.LOGIN_ID,
776: sysdate,
777: FND_GLOBAL.USER_ID
778: from ZPB_BUSAREA_USERS A,
779: FND_USER_RESP_GROUPS B,
780: FND_RESPONSIBILITY C
781: where A.USER_ID = B.USER_ID
782: and B.RESPONSIBILITY_APPLICATION_ID = 210
783: and B.RESPONSIBILITY_ID = C.RESPONSIBILITY_ID

Line 820: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d

816: from ZPB_BUSAREA_USERS B
817: where B.BUSINESS_AREA_ID = p_business_area_id
818: and b.USER_ID = A.USER_ID)
819: and (A.RESP_ID = (select C.RESPONSIBILITY_ID
820: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d
821: where C.APPLICATION_ID = 210
822: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
823: and c.responsibility_id = d.responsibility_id
824: and d.user_id = a.user_id

Line 827: from fnd_user fu

823: and c.responsibility_id = d.responsibility_id
824: and d.user_id = a.user_id
825: and (d.end_date is NULL or d.end_date >= sysdate))
826: and exists (select user_id
827: from fnd_user fu
828: where nvl(fu.end_date,sysdate) >= sysdate
829: and A.user_id = fu.user_id));
830:
831: -- Added the following update statement for Bug: 5077013

Line 839: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d

835: update ZPB_ACCOUNT_STATES A
836: set ACCOUNT_STATUS = RMV_ROLE
837: where A.BUSINESS_AREA_ID = p_business_area_id
838: and (A.RESP_ID in (select C.RESPONSIBILITY_ID
839: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d
840: where C.APPLICATION_ID = 210
841: and c.responsibility_id = d.responsibility_id
842: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
843: and d.user_id = a.user_id

Line 847: from fnd_user fu

843: and d.user_id = a.user_id
844: and d.end_date is NOT NULL
845: and d.end_date < sysdate)
846: or A.USER_ID = (select user_id
847: from fnd_user fu
848: where nvl(fu.end_date,sysdate) < sysdate
849: and A.user_id = fu.user_id));
850:
851: update ZPB_ACCOUNT_STATES A

Line 856: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d

852: set A.ACCOUNT_STATUS = ADD_ROLE
853: where A.BUSINESS_AREA_ID = p_business_area_id
854: and A.ACCOUNT_STATUS = RMV_ROLE
855: and (A.RESP_ID in (select C.RESPONSIBILITY_ID
856: from FND_RESPONSIBILITY C, fnd_user_resp_groups_all d
857: where C.APPLICATION_ID = 210
858: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
859: and c.responsibility_id = d.responsibility_id
860: and (d.end_date IS NULL or d.end_date >= sysdate))

Line 862: from fnd_user fu

858: and C.RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP'
859: and c.responsibility_id = d.responsibility_id
860: and (d.end_date IS NULL or d.end_date >= sysdate))
861: and A.USER_ID = (select user_id
862: from fnd_user fu
863: where nvl(fu.end_date, sysdate) >= sysdate
864: and A.user_id = fu.user_id));
865: ----------------------------------------------------------------------------------*/
866:

Line 914: from fnd_user a,fnd_user_resp_groups b,fnd_responsibility c

910: from zpb_busarea_users
911: where business_area_id = p_business_area_id
912: intersect
913: select /*+ LEADING (c) */ distinct(a.user_id)
914: from fnd_user a,fnd_user_resp_groups b,fnd_responsibility c
915: where a.user_id=b.user_id
916: and b.responsibility_id=c.responsibility_id
917: and c.responsibility_key = 'ZPB_MANAGER_RESP'
918: and ((a.end_date < SYSDATE) or