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

Line 37: p_user_name fnd_user.user_name%type;

33: key varchar2(401);
34: userQuery varchar(10000);
35: DuserQuery varchar(1000);
36: DOlduserQuery varchar(1000);
37: p_user_name fnd_user.user_name%type;
38: p_user_pwd varchar2(10) := dbms_random.string('A', 10);
39: p_user_valid number;
40: p_user_resp number;
41: p_user_fname per_all_people_f.first_name%type;

Line 45: p_user_fax fnd_user.fax%type;

41: p_user_fname per_all_people_f.first_name%type;
42: p_user_lname per_all_people_f.last_name%type;
43: p_user_org_name hr_all_organization_units.name%type;
44: p_user_wrkphone per_all_people_f.work_telephone%type;
45: p_user_fax fnd_user.fax%type;
46: p_user_email fnd_user.email_address%type;
47: p_user_product number;
48: Duser_cnt number;
49: DOlduser_cnt number;

Line 46: p_user_email fnd_user.email_address%type;

42: p_user_lname per_all_people_f.last_name%type;
43: p_user_org_name hr_all_organization_units.name%type;
44: p_user_wrkphone per_all_people_f.work_telephone%type;
45: p_user_fax fnd_user.fax%type;
46: p_user_email fnd_user.email_address%type;
47: p_user_product number;
48: Duser_cnt number;
49: DOlduser_cnt number;
50: userid varchar2 (400);

Line 78: FROM fnd_user

74:
75: CURSOR c_get_user_id (p_user_name varchar2)
76: IS
77: SELECT to_char(user_id)
78: FROM fnd_user
79: WHERE user_name = p_user_name;
80:
81: BEGIN
82:

Line 128: OR eventName = 'oracle.apps.fnd.user.delete'

124:
125: /*** BEGIN - Get the user name from the event ***/
126: If ( eventName = 'oracle.apps.fnd.wf.ds.userRole.created'
127: OR eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
128: OR eventName = 'oracle.apps.fnd.user.delete'
129: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated'
130: OR eventName = 'oracle.apps.fnd.wf.ds.user.nameChanged')
131: THEN
132: x_curr_name := p_event.getValueForParameter('USER_NAME');

Line 175: FROM fnd_user_resp_groups_all fug,

171: ' select fu.user_name, decode(sign(fu.end_date - sysdate),-1,2,1),
172: (SELECT sum(a) FROM (SELECT 1 a
173: FROM dual
174: WHERE EXISTS ( SELECT 1
175: FROM fnd_user_resp_groups_all fug,
176: fnd_responsibility fr,
177: fnd_menu_entries fme,
178: fnd_form_functions fff
179: WHERE

Line 194: FROM fnd_user_resp_groups_all fug,

190: UNION ALL
191: SELECT 2 a
192: FROM dual
193: WHERE EXISTS ( SELECT 1
194: FROM fnd_user_resp_groups_all fug,
195: fnd_responsibility fr,
196: fnd_menu_entries fme,
197: fnd_form_functions fff
198: WHERE

Line 278: from fnd_user fu

274: and pap.email_address is not null
275: and rownum <2),
276: fu.email_address) email_address,
277: 1 product
278: from fnd_user fu
279: where fu.user_id = :userid3';
280:
281: IF (eventName = 'oracle.apps.fnd.user.delete')
282: THEN

Line 281: IF (eventName = 'oracle.apps.fnd.user.delete')

277: 1 product
278: from fnd_user fu
279: where fu.user_id = :userid3';
280:
281: IF (eventName = 'oracle.apps.fnd.user.delete')
282: THEN
283: p_user_name := x_curr_name;
284: ELSE
285:

Line 306: IF (eventName = 'oracle.apps.fnd.user.delete')

302: END IF;
303:
304:
305: /* Get the user type */
306: IF (eventName = 'oracle.apps.fnd.user.delete')
307: THEN
308: NULL;
309: ELSIF (p_user_resp = 1)
310: THEN

Line 318: eventName := 'oracle.apps.fnd.user.resp.delete';

314: x_user_permission := 'DPA';
315: ELSIF ( eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
316: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated')
317: THEN
318: eventName := 'oracle.apps.fnd.user.resp.delete';
319: ELSE
320: log ('Not a DM User');
321: RETURN SUCCESS;
322: END IF;

Line 444: Elsif (eventName = 'oracle.apps.fnd.user.delete') THEN

440: End If;
441: End If;
442:
443: /* Delete existing User */
444: Elsif (eventName = 'oracle.apps.fnd.user.delete') THEN
445:
446: /* invoke API_DROP_ORA_DEM_USER(user name) */
447: log_debug('User Delete - Deleting User');
448: log_debug(x_drop_user_sql);

Line 453: Elsif (eventName = 'oracle.apps.fnd.user.resp.delete') THEN

449:
450: EXECUTE IMMEDIATE x_drop_user_sql;
451:
452: /* Delete responsibility */
453: Elsif (eventName = 'oracle.apps.fnd.user.resp.delete') THEN
454:
455: /* User exists in Demantra */
456: If (Duser_cnt > 0 AND x_user_permission IS NOT NULL) Then
457:

Line 583: p_user_name fnd_user.user_name%type;

579: key varchar2(401);
580: userQuery varchar(10000);
581: DuserQuery varchar(1000);
582: DOlduserQuery varchar(1000);
583: p_user_name fnd_user.user_name%type;
584: p_user_pwd varchar2(10) := dbms_random.string('A', 10);
585: p_user_valid number;
586: p_user_resp number;
587: p_user_fname per_all_people_f.first_name%type;

Line 591: p_user_fax fnd_user.fax%type;

587: p_user_fname per_all_people_f.first_name%type;
588: p_user_lname per_all_people_f.last_name%type;
589: p_user_org_name hr_all_organization_units.name%type;
590: p_user_wrkphone per_all_people_f.work_telephone%type;
591: p_user_fax fnd_user.fax%type;
592: p_user_email fnd_user.email_address%type;
593: p_user_product number;
594: Duser_cnt number;
595: DOlduser_cnt number;

Line 592: p_user_email fnd_user.email_address%type;

588: p_user_lname per_all_people_f.last_name%type;
589: p_user_org_name hr_all_organization_units.name%type;
590: p_user_wrkphone per_all_people_f.work_telephone%type;
591: p_user_fax fnd_user.fax%type;
592: p_user_email fnd_user.email_address%type;
593: p_user_product number;
594: Duser_cnt number;
595: DOlduser_cnt number;
596: userid varchar2 (400);

Line 613: FROM fnd_user

609:
610: CURSOR c_get_user_id (p_user_name varchar2)
611: IS
612: SELECT to_char(user_id)
613: FROM fnd_user
614: WHERE user_name = p_user_name;
615:
616:
617: BEGIN

Line 631: OR eventName = 'oracle.apps.fnd.user.delete'

627:
628: /*** BEGIN - Get the user name from the event ***/
629: If ( eventName = 'oracle.apps.fnd.wf.ds.userRole.created'
630: OR eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
631: OR eventName = 'oracle.apps.fnd.user.delete'
632: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated'
633: OR eventName = 'oracle.apps.fnd.wf.ds.user.nameChanged')
634: THEN
635: x_curr_name := p_event.getValueForParameter('USER_NAME');

Line 678: FROM fnd_user_resp_groups_all fug,

674: ' select fu.user_name, decode(sign(fu.end_date - sysdate),-1,2,1),
675: (SELECT sum(a) FROM (SELECT 1 a
676: FROM dual
677: WHERE EXISTS ( SELECT 1
678: FROM fnd_user_resp_groups_all fug,
679: fnd_responsibility fr,
680: fnd_menu_entries fme,
681: fnd_form_functions fff
682: WHERE

Line 697: FROM fnd_user_resp_groups_all fug,

693: UNION ALL
694: SELECT 2 a
695: FROM dual
696: WHERE EXISTS ( SELECT 1
697: FROM fnd_user_resp_groups_all fug,
698: fnd_responsibility fr,
699: fnd_menu_entries fme,
700: fnd_form_functions fff
701: WHERE

Line 781: from fnd_user fu

777: and pap.email_address is not null
778: and rownum <2),
779: fu.email_address) email_address,
780: 1 product
781: from fnd_user fu
782: where fu.user_id = :userid3';
783:
784: IF (eventName = 'oracle.apps.fnd.user.delete')
785: THEN

Line 784: IF (eventName = 'oracle.apps.fnd.user.delete')

780: 1 product
781: from fnd_user fu
782: where fu.user_id = :userid3';
783:
784: IF (eventName = 'oracle.apps.fnd.user.delete')
785: THEN
786: p_user_name := x_curr_name;
787: ELSE
788:

Line 809: IF (eventName = 'oracle.apps.fnd.user.delete')

805: END IF;
806:
807:
808: /* Get the user type */
809: IF (eventName = 'oracle.apps.fnd.user.delete')
810: THEN
811: NULL;
812: ELSIF (p_user_resp = 1)
813: THEN

Line 821: eventName := 'oracle.apps.fnd.user.resp.delete';

817: x_user_permission := 'DPA';
818: ELSIF ( eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
819: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated')
820: THEN
821: eventName := 'oracle.apps.fnd.user.resp.delete';
822: ELSE
823: log ('Not a SOP User');
824: RETURN SUCCESS;
825: END IF;

Line 953: Elsif (eventName = 'oracle.apps.fnd.user.delete') THEN

949: End If;
950: End If;
951:
952: /* Delete existing User */
953: Elsif (eventName = 'oracle.apps.fnd.user.delete') THEN
954:
955: /* invoke API_DROP_ORA_DEM_USER(user name) */
956: log_debug('User Delete - Deleting User');
957: log_debug(x_drop_user_sql);

Line 962: Elsif (eventName = 'oracle.apps.fnd.user.resp.delete') THEN

958:
959: EXECUTE IMMEDIATE x_drop_user_sql;
960:
961: /* Delete responsibility */
962: Elsif (eventName = 'oracle.apps.fnd.user.resp.delete') THEN
963:
964: /* User exists in Demantra */
965: If (Duser_cnt > 0 AND x_user_permission IS NOT NULL) Then
966: