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

Line 47: FROM fnd_user

43: AND admission_appl_number = p_admission_appl_number;
44:
45: CURSOR cur_user_name IS
46: SELECT user_name
47: FROM fnd_user
48: WHERE user_id = fnd_global.user_id;
49:
50:
51: l_cur_prof_value cur_prof_value%ROWTYPE;

Line 57: l_wf_role fnd_user.user_name%TYPE;

53: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
54: l_person_number igs_pe_person_base_v.person_number%TYPE;
55: l_person_name igs_pe_person_base_v.full_name%TYPE;
56: l_application_id igs_ad_appl_all.application_id%TYPE;
57: l_wf_role fnd_user.user_name%TYPE;
58:
59:
60: BEGIN
61: -- Checking if the Workflow is installed at the environment or not.

Line 139: l_wf_role fnd_user.user_name%TYPE;

135: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
136: l_person_number igs_pe_person_base_v.person_number%TYPE;
137: l_person_name igs_pe_person_base_v.full_name%TYPE;
138: l_application_id igs_ad_appl_all.application_id%TYPE;
139: l_wf_role fnd_user.user_name%TYPE;
140:
141:
142: -- Get a unique sequence number
143: CURSOR c_seq_num IS

Line 161: FROM fnd_user

157: AND admission_appl_number = p_admission_appl_number;
158:
159: CURSOR cur_user_name IS
160: SELECT user_name
161: FROM fnd_user
162: WHERE user_id = fnd_global.user_id;
163:
164: BEGIN
165:

Line 321: FROM fnd_user

317: FROM sys.dual;
318:
319: CURSOR cur_user_name IS
320: SELECT user_name
321: FROM fnd_user
322: WHERE user_id = fnd_global.user_id;
323:
324: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
325: l_wf_role fnd_user.user_name%TYPE;

Line 325: l_wf_role fnd_user.user_name%TYPE;

321: FROM fnd_user
322: WHERE user_id = fnd_global.user_id;
323:
324: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
325: l_wf_role fnd_user.user_name%TYPE;
326: l_seq_val NUMBER;
327: lv_raise_event VARCHAR2(100);
328:
329:

Line 384: FROM fnd_user

380: FROM sys.dual;
381:
382: CURSOR cur_user_name IS
383: SELECT user_name
384: FROM fnd_user
385: WHERE user_id = fnd_global.user_id;
386:
387: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
388: l_wf_role fnd_user.user_name%TYPE;

Line 388: l_wf_role fnd_user.user_name%TYPE;

384: FROM fnd_user
385: WHERE user_id = fnd_global.user_id;
386:
387: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
388: l_wf_role fnd_user.user_name%TYPE;
389: l_seq_val NUMBER;
390: lv_raise_event VARCHAR2(100);
391:
392:

Line 451: FROM fnd_user

447: FROM sys.dual;
448:
449: CURSOR cur_user_name IS
450: SELECT user_name
451: FROM fnd_user
452: WHERE user_id = fnd_global.user_id;
453:
454: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
455: l_wf_role fnd_user.user_name%TYPE;

Line 455: l_wf_role fnd_user.user_name%TYPE;

451: FROM fnd_user
452: WHERE user_id = fnd_global.user_id;
453:
454: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
455: l_wf_role fnd_user.user_name%TYPE;
456: l_seq_val NUMBER;
457: lv_raise_event VARCHAR2(100);
458:
459:

Line 520: FROM fnd_user

516: FROM sys.dual;
517:
518: CURSOR cur_user_name IS
519: SELECT user_name
520: FROM fnd_user
521: WHERE user_id = fnd_global.user_id;
522:
523: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
524: l_wf_role fnd_user.user_name%TYPE;

Line 524: l_wf_role fnd_user.user_name%TYPE;

520: FROM fnd_user
521: WHERE user_id = fnd_global.user_id;
522:
523: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
524: l_wf_role fnd_user.user_name%TYPE;
525: l_seq_val NUMBER;
526: lv_raise_event VARCHAR2(100);
527:
528:

Line 583: FROM fnd_user

579: FROM sys.dual;
580:
581: CURSOR cur_user_name IS
582: SELECT user_name
583: FROM fnd_user
584: WHERE user_id = fnd_global.user_id;
585:
586: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
587: l_wf_role fnd_user.user_name%TYPE;

Line 587: l_wf_role fnd_user.user_name%TYPE;

583: FROM fnd_user
584: WHERE user_id = fnd_global.user_id;
585:
586: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
587: l_wf_role fnd_user.user_name%TYPE;
588: l_seq_val NUMBER;
589: lv_raise_event VARCHAR2(100);
590:
591:

Line 645: FROM fnd_user

641: FROM sys.dual;
642:
643: CURSOR cur_user_name IS
644: SELECT user_name
645: FROM fnd_user
646: WHERE user_id = fnd_global.user_id;
647:
648: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
649: l_wf_role fnd_user.user_name%TYPE;

Line 649: l_wf_role fnd_user.user_name%TYPE;

645: FROM fnd_user
646: WHERE user_id = fnd_global.user_id;
647:
648: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
649: l_wf_role fnd_user.user_name%TYPE;
650: l_seq_val NUMBER;
651: lv_raise_event VARCHAR2(100);
652:
653:

Line 709: FROM fnd_user

705: FROM sys.dual;
706:
707: CURSOR cur_user_name IS
708: SELECT user_name
709: FROM fnd_user
710: WHERE user_id = fnd_global.user_id;
711:
712: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
713: l_wf_role fnd_user.user_name%TYPE;

Line 713: l_wf_role fnd_user.user_name%TYPE;

709: FROM fnd_user
710: WHERE user_id = fnd_global.user_id;
711:
712: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
713: l_wf_role fnd_user.user_name%TYPE;
714: l_seq_val NUMBER;
715: lv_raise_event VARCHAR2(100);
716:
717:

Line 774: FROM fnd_user

770: FROM sys.dual;
771:
772: CURSOR cur_user_name IS
773: SELECT user_name
774: FROM fnd_user
775: WHERE user_id = fnd_global.user_id;
776:
777: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
778: l_wf_role fnd_user.user_name%TYPE;

Line 778: l_wf_role fnd_user.user_name%TYPE;

774: FROM fnd_user
775: WHERE user_id = fnd_global.user_id;
776:
777: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
778: l_wf_role fnd_user.user_name%TYPE;
779: l_seq_val NUMBER;
780: lv_raise_event VARCHAR2(100);
781:
782:

Line 838: FROM fnd_user

834: FROM sys.dual;
835:
836: CURSOR cur_user_name IS
837: SELECT user_name
838: FROM fnd_user
839: WHERE user_id = fnd_global.user_id;
840:
841: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
842: l_wf_role fnd_user.user_name%TYPE;

Line 842: l_wf_role fnd_user.user_name%TYPE;

838: FROM fnd_user
839: WHERE user_id = fnd_global.user_id;
840:
841: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
842: l_wf_role fnd_user.user_name%TYPE;
843: l_seq_val NUMBER;
844: lv_raise_event VARCHAR2(100);
845:
846:

Line 903: FROM fnd_user

899: FROM sys.dual;
900:
901: CURSOR cur_user_name IS
902: SELECT user_name
903: FROM fnd_user
904: WHERE user_id = fnd_global.user_id;
905:
906: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
907:

Line 908: l_wf_role fnd_user.user_name%TYPE;

904: WHERE user_id = fnd_global.user_id;
905:
906: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
907:
908: l_wf_role fnd_user.user_name%TYPE;
909: l_seq_val NUMBER;
910: lv_raise_event VARCHAR2(100);
911:
912:

Line 968: FROM fnd_user

964: FROM sys.dual;
965:
966: CURSOR cur_user_name IS
967: SELECT user_name
968: FROM fnd_user
969: WHERE user_id = fnd_global.user_id;
970:
971: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
972:

Line 973: l_wf_role fnd_user.user_name%TYPE;

969: WHERE user_id = fnd_global.user_id;
970:
971: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
972:
973: l_wf_role fnd_user.user_name%TYPE;
974: l_seq_val NUMBER;
975: lv_raise_event VARCHAR2(100);
976:
977:

Line 1034: FROM fnd_user

1030: FROM sys.dual;
1031:
1032: CURSOR cur_user_name IS
1033: SELECT user_name
1034: FROM fnd_user
1035: WHERE user_id = fnd_global.user_id;
1036:
1037: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1038:

Line 1039: l_wf_role fnd_user.user_name%TYPE;

1035: WHERE user_id = fnd_global.user_id;
1036:
1037: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1038:
1039: l_wf_role fnd_user.user_name%TYPE;
1040: l_seq_val NUMBER;
1041: lv_raise_event VARCHAR2(100);
1042:
1043:

Line 1099: FROM fnd_user

1095: FROM sys.dual;
1096:
1097: CURSOR cur_user_name IS
1098: SELECT user_name
1099: FROM fnd_user
1100: WHERE user_id = fnd_global.user_id;
1101:
1102: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1103:

Line 1104: l_wf_role fnd_user.user_name%TYPE;

1100: WHERE user_id = fnd_global.user_id;
1101:
1102: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1103:
1104: l_wf_role fnd_user.user_name%TYPE;
1105: l_seq_val NUMBER;
1106: lv_raise_event VARCHAR2(100);
1107:
1108:

Line 1227: FROM fnd_user

1223: FROM sys.dual;
1224:
1225: CURSOR cur_user_name IS
1226: SELECT user_name
1227: FROM fnd_user
1228: WHERE user_id = fnd_global.user_id;
1229:
1230: CURSOR cur_prof_value IS
1231: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value

Line 1236: l_wf_role fnd_user.user_name%TYPE;

1232: FROM dual;
1233:
1234: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1235:
1236: l_wf_role fnd_user.user_name%TYPE;
1237: l_seq_val NUMBER;
1238: lv_raise_event VARCHAR2(100);
1239: l_cur_prof_value cur_prof_value%ROWTYPE;
1240:

Line 1413: FROM fnd_user

1409: FROM sys.dual;
1410:
1411: CURSOR cur_user_name IS
1412: SELECT user_name
1413: FROM fnd_user
1414: WHERE user_id = fnd_global.user_id;
1415:
1416: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1417:

Line 1418: l_wf_role fnd_user.user_name%TYPE;

1414: WHERE user_id = fnd_global.user_id;
1415:
1416: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1417:
1418: l_wf_role fnd_user.user_name%TYPE;
1419: l_seq_val NUMBER;
1420: lv_raise_event VARCHAR2(100);
1421:
1422:

Line 1473: FROM fnd_user

1469: FROM sys.dual;
1470:
1471: CURSOR cur_user_name IS
1472: SELECT user_name
1473: FROM fnd_user
1474: WHERE user_id = fnd_global.user_id;
1475:
1476: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1477:

Line 1478: l_wf_role fnd_user.user_name%TYPE;

1474: WHERE user_id = fnd_global.user_id;
1475:
1476: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1477:
1478: l_wf_role fnd_user.user_name%TYPE;
1479: l_seq_val NUMBER;
1480: lv_raise_event VARCHAR2(100);
1481:
1482:

Line 1535: FROM fnd_user

1531: FROM sys.dual;
1532:
1533: CURSOR cur_user_name IS
1534: SELECT user_name
1535: FROM fnd_user
1536: WHERE user_id = fnd_global.user_id;
1537:
1538: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1539:

Line 1540: l_wf_role fnd_user.user_name%TYPE;

1536: WHERE user_id = fnd_global.user_id;
1537:
1538: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1539:
1540: l_wf_role fnd_user.user_name%TYPE;
1541: l_seq_val NUMBER;
1542: lv_raise_event VARCHAR2(100);
1543:
1544:

Line 1596: FROM fnd_user

1592: FROM sys.dual;
1593:
1594: CURSOR cur_user_name IS
1595: SELECT user_name
1596: FROM fnd_user
1597: WHERE user_id = fnd_global.user_id;
1598:
1599: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1600:

Line 1601: l_wf_role fnd_user.user_name%TYPE;

1597: WHERE user_id = fnd_global.user_id;
1598:
1599: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1600:
1601: l_wf_role fnd_user.user_name%TYPE;
1602: l_seq_val NUMBER;
1603: lv_raise_event VARCHAR2(100);
1604: BEGIN
1605: OPEN cur_user_name;

Line 1652: FROM fnd_user

1648: FROM sys.dual;
1649:
1650: CURSOR cur_user_name IS
1651: SELECT user_name
1652: FROM fnd_user
1653: WHERE user_id = fnd_global.user_id;
1654:
1655: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1656:

Line 1657: l_wf_role fnd_user.user_name%TYPE;

1653: WHERE user_id = fnd_global.user_id;
1654:
1655: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1656:
1657: l_wf_role fnd_user.user_name%TYPE;
1658: l_seq_val NUMBER;
1659: lv_raise_event VARCHAR2(100);
1660: BEGIN
1661: OPEN cur_user_name;

Line 1710: FROM fnd_user

1706: FROM sys.dual;
1707:
1708: CURSOR cur_user_name IS
1709: SELECT user_name
1710: FROM fnd_user
1711: WHERE user_id = fnd_global.user_id;
1712:
1713: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1714:

Line 1715: l_wf_role fnd_user.user_name%TYPE;

1711: WHERE user_id = fnd_global.user_id;
1712:
1713: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1714:
1715: l_wf_role fnd_user.user_name%TYPE;
1716: l_seq_val NUMBER;
1717: lv_raise_event VARCHAR2(100);
1718: BEGIN
1719: OPEN cur_user_name;

Line 1777: FROM fnd_user

1773: FROM sys.dual;
1774:
1775: CURSOR cur_user_name IS
1776: SELECT user_name
1777: FROM fnd_user
1778: WHERE user_id = fnd_global.user_id;
1779:
1780: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1781:

Line 1782: l_wf_role fnd_user.user_name%TYPE;

1778: WHERE user_id = fnd_global.user_id;
1779:
1780: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1781:
1782: l_wf_role fnd_user.user_name%TYPE;
1783: l_seq_val NUMBER;
1784: lv_raise_event VARCHAR2(100);
1785: BEGIN
1786: OPEN cur_user_name;

Line 1847: FROM fnd_user

1843: FROM sys.dual;
1844:
1845: CURSOR cur_user_name IS
1846: SELECT user_name
1847: FROM fnd_user
1848: WHERE user_id = fnd_global.user_id;
1849:
1850: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1851:

Line 1852: l_wf_role fnd_user.user_name%TYPE;

1848: WHERE user_id = fnd_global.user_id;
1849:
1850: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1851:
1852: l_wf_role fnd_user.user_name%TYPE;
1853: l_seq_val NUMBER;
1854: lv_raise_event VARCHAR2(100);
1855: BEGIN
1856: OPEN cur_user_name;