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 41: p_user_name fnd_user.user_name%type;

37: key varchar2(401);
38: userQuery varchar(15000);
39: DuserQuery varchar(1000);
40: DOlduserQuery varchar(1000);
41: p_user_name fnd_user.user_name%type;
42: p_user_pwd varchar2(10) := dbms_random.string('X', 10); --bug#14219828 nallkuma
43: p_user_valid number;
44: p_user_resp number;
45: p_user_fname per_all_people_f.first_name%type;

Line 49: p_user_fax fnd_user.fax%type;

45: p_user_fname per_all_people_f.first_name%type;
46: p_user_lname per_all_people_f.last_name%type;
47: p_user_org_name hr_all_organization_units.name%type;
48: p_user_wrkphone per_all_people_f.work_telephone%type;
49: p_user_fax fnd_user.fax%type;
50: p_user_email fnd_user.email_address%type;
51: -- p_user_language number; --commenting out MLS nallkuma
52: p_user_product number;
53: Duser_cnt number;

Line 50: p_user_email fnd_user.email_address%type;

46: p_user_lname per_all_people_f.last_name%type;
47: p_user_org_name hr_all_organization_units.name%type;
48: p_user_wrkphone per_all_people_f.work_telephone%type;
49: p_user_fax fnd_user.fax%type;
50: p_user_email fnd_user.email_address%type;
51: -- p_user_language number; --commenting out MLS nallkuma
52: p_user_product number;
53: Duser_cnt number;
54: DOlduser_cnt number;

Line 85: FROM fnd_user

81:
82: CURSOR c_get_user_id (p_user_name varchar2)
83: IS
84: SELECT to_char(user_id)
85: FROM fnd_user
86: WHERE user_name = p_user_name;
87:
88: BEGIN
89:

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

131:
132: /*** BEGIN - Get the user name from the event ***/
133: If ( eventName = 'oracle.apps.fnd.wf.ds.userRole.created'
134: OR eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
135: OR eventName = 'oracle.apps.fnd.user.delete'
136: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated'
137: OR eventName = 'oracle.apps.fnd.wf.ds.user.nameChanged')
138: THEN
139: x_curr_name := p_event.getValueForParameter('USER_NAME');

Line 184: FROM fnd_user_resp_groups_all fug,

180: ' select fu.user_name, decode(sign(fu.end_date - sysdate),-1,2,1),
181: (SELECT sum(a) FROM (SELECT 1 a
182: FROM dual
183: WHERE EXISTS ( SELECT 1
184: FROM fnd_user_resp_groups_all fug,
185: fnd_responsibility fr,
186: fnd_menu_entries fme,
187: fnd_form_functions fff
188: WHERE

Line 200: FROM fnd_user_resp_groups_all fug,

196: AND fme.sub_menu_id IS NULL
197: AND fff.function_id = fme.function_id
198: AND fff.function_name = ''MSD_DEM_DEMPLANR'')
199: OR EXISTS ( SELECT 1
200: FROM fnd_user_resp_groups_all fug,
201: fnd_responsibility fr,
202: fnd_menu_entries fme,
203: fnd_menu_entries sub_fme,
204: fnd_form_functions fff

Line 221: FROM fnd_user_resp_groups_all fug,

217: UNION ALL
218: SELECT 2 a
219: FROM dual
220: WHERE EXISTS ( SELECT 2
221: FROM fnd_user_resp_groups_all fug,
222: fnd_responsibility fr,
223: fnd_menu_entries fme,
224: fnd_form_functions fff
225: WHERE

Line 237: FROM fnd_user_resp_groups_all fug,

233: AND fme.sub_menu_id IS NULL
234: AND fff.function_id = fme.function_id
235: AND fff.function_name = ''MSD_DEM_WF_MGR'')
236: OR EXISTS ( SELECT 2
237: FROM fnd_user_resp_groups_all fug,
238: fnd_responsibility fr,
239: fnd_menu_entries fme,
240: fnd_menu_entries sub_fme,
241: fnd_form_functions fff

Line 323: from fnd_user fu

319: and pap.email_address is not null
320: and rownum <2),
321: fu.email_address) email_address,
322: 1 product
323: from fnd_user fu
324: where fu.user_id = :userid5';
325:
326: IF (eventName = 'oracle.apps.fnd.user.delete')
327: THEN

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

322: 1 product
323: from fnd_user fu
324: where fu.user_id = :userid5';
325:
326: IF (eventName = 'oracle.apps.fnd.user.delete')
327: THEN
328: p_user_name := x_curr_name;
329: ELSE
330:

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

347: END IF;
348:
349:
350: /* Get the user type */
351: IF (eventName = 'oracle.apps.fnd.user.delete')
352: THEN
353: NULL;
354: ELSIF (p_user_resp = 1)
355: THEN

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

359: x_user_permission := 'DPA';
360: ELSIF ( eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
361: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated')
362: THEN
363: eventName := 'oracle.apps.fnd.user.resp.delete';
364: ELSE
365: log ('Not a DM User');
366: RETURN SUCCESS;
367: END IF;

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

484: End If;
485: End If;
486:
487: /* Delete existing User */
488: Elsif (eventName = 'oracle.apps.fnd.user.delete') THEN
489:
490: /* invoke API_DROP_ORA_DEM_USER(user name) */
491: log_debug('User Delete - Deleting User');
492: log_debug(x_drop_user_sql);

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

493:
494: EXECUTE IMMEDIATE x_drop_user_sql;
495:
496: /* Delete responsibility */
497: Elsif (eventName = 'oracle.apps.fnd.user.resp.delete') THEN
498:
499: /* User exists in Demantra */
500: If (Duser_cnt > 0 AND x_user_permission IS NOT NULL) Then
501:

Line 627: p_user_name fnd_user.user_name%type;

623: key varchar2(401);
624: userQuery varchar(10000);
625: DuserQuery varchar(1000);
626: DOlduserQuery varchar(1000);
627: p_user_name fnd_user.user_name%type;
628: p_user_pwd varchar2(10) := dbms_random.string('X', 10); --bug#14219828 nallkuma
629: p_user_valid number;
630: p_user_resp number;
631: p_user_fname per_all_people_f.first_name%type;

Line 635: p_user_fax fnd_user.fax%type;

631: p_user_fname per_all_people_f.first_name%type;
632: p_user_lname per_all_people_f.last_name%type;
633: p_user_org_name hr_all_organization_units.name%type;
634: p_user_wrkphone per_all_people_f.work_telephone%type;
635: p_user_fax fnd_user.fax%type;
636: p_user_email fnd_user.email_address%type;
637: -- p_user_language number; --commenting out MLS nallkuma
638: p_user_product number;
639: Duser_cnt number;

Line 636: p_user_email fnd_user.email_address%type;

632: p_user_lname per_all_people_f.last_name%type;
633: p_user_org_name hr_all_organization_units.name%type;
634: p_user_wrkphone per_all_people_f.work_telephone%type;
635: p_user_fax fnd_user.fax%type;
636: p_user_email fnd_user.email_address%type;
637: -- p_user_language number; --commenting out MLS nallkuma
638: p_user_product number;
639: Duser_cnt number;
640: DOlduser_cnt number;

Line 660: FROM fnd_user

656:
657: CURSOR c_get_user_id (p_user_name varchar2)
658: IS
659: SELECT to_char(user_id)
660: FROM fnd_user
661: WHERE user_name = p_user_name;
662:
663:
664: BEGIN

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

674:
675: /*** BEGIN - Get the user name from the event ***/
676: If ( eventName = 'oracle.apps.fnd.wf.ds.userRole.created'
677: OR eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
678: OR eventName = 'oracle.apps.fnd.user.delete'
679: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated'
680: OR eventName = 'oracle.apps.fnd.wf.ds.user.nameChanged')
681: THEN
682: x_curr_name := p_event.getValueForParameter('USER_NAME');

Line 727: FROM fnd_user_resp_groups_all fug,

723: ' select fu.user_name, decode(sign(fu.end_date - sysdate),-1,2,1),
724: (SELECT sum(a) FROM (SELECT 1 a
725: FROM dual
726: WHERE EXISTS ( SELECT 1
727: FROM fnd_user_resp_groups_all fug,
728: fnd_responsibility fr,
729: fnd_menu_entries fme,
730: fnd_form_functions fff
731: WHERE

Line 746: FROM fnd_user_resp_groups_all fug,

742: UNION ALL
743: SELECT 2 a
744: FROM dual
745: WHERE EXISTS ( SELECT 1
746: FROM fnd_user_resp_groups_all fug,
747: fnd_responsibility fr,
748: fnd_menu_entries fme,
749: fnd_form_functions fff
750: WHERE

Line 830: from fnd_user fu

826: and pap.email_address is not null
827: and rownum <2),
828: fu.email_address) email_address,
829: 1 product
830: from fnd_user fu
831: where fu.user_id = :userid3';
832:
833: IF (eventName = 'oracle.apps.fnd.user.delete')
834: THEN

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

829: 1 product
830: from fnd_user fu
831: where fu.user_id = :userid3';
832:
833: IF (eventName = 'oracle.apps.fnd.user.delete')
834: THEN
835: p_user_name := x_curr_name;
836: ELSE
837:

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

854: END IF;
855:
856:
857: /* Get the user type */
858: IF (eventName = 'oracle.apps.fnd.user.delete')
859: THEN
860: NULL;
861: ELSIF (p_user_resp = 1)
862: THEN

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

866: x_user_permission := 'DPA';
867: ELSIF ( eventName = 'oracle.apps.fnd.wf.ds.userRole.updated'
868: OR eventName = 'oracle.apps.fnd.wf.ds.user.updated')
869: THEN
870: eventName := 'oracle.apps.fnd.user.resp.delete';
871: ELSE
872: log ('Not a SOP User');
873: RETURN SUCCESS;
874: END IF;

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

997: End If;
998: End If;
999:
1000: /* Delete existing User */
1001: Elsif (eventName = 'oracle.apps.fnd.user.delete') THEN
1002:
1003: /* invoke API_DROP_ORA_DEM_USER(user name) */
1004: log_debug('User Delete - Deleting User');
1005: log_debug(x_drop_user_sql);

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

1006:
1007: EXECUTE IMMEDIATE x_drop_user_sql;
1008:
1009: /* Delete responsibility */
1010: Elsif (eventName = 'oracle.apps.fnd.user.resp.delete') THEN
1011:
1012: /* User exists in Demantra */
1013: If (Duser_cnt > 0 AND x_user_permission IS NOT NULL) Then
1014: