DBA Data[Home] [Help]

APPS.IGS_AD_WF_001 dependencies on FND_GLOBAL

Line 48: WHERE user_id = fnd_global.user_id;

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;
52: lv_raise_event VARCHAR2(100);

Line 162: WHERE user_id = fnd_global.user_id;

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:
166: IF p_raised_for ='MAC' THEN --Manual application creation in IGSAD046

Line 322: WHERE user_id = fnd_global.user_id;

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;
326: l_seq_val NUMBER;

Line 385: WHERE user_id = fnd_global.user_id;

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;
389: l_seq_val NUMBER;

Line 452: WHERE user_id = fnd_global.user_id;

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;
456: l_seq_val NUMBER;

Line 521: WHERE user_id = fnd_global.user_id;

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;
525: l_seq_val NUMBER;

Line 584: WHERE user_id = fnd_global.user_id;

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;
588: l_seq_val NUMBER;

Line 646: WHERE user_id = fnd_global.user_id;

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;
650: l_seq_val NUMBER;

Line 710: WHERE user_id = fnd_global.user_id;

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;
714: l_seq_val NUMBER;

Line 775: WHERE user_id = fnd_global.user_id;

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;
779: l_seq_val NUMBER;

Line 839: WHERE user_id = fnd_global.user_id;

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;
843: l_seq_val NUMBER;

Line 904: WHERE user_id = fnd_global.user_id;

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:
908: l_wf_role fnd_user.user_name%TYPE;

Line 969: WHERE user_id = fnd_global.user_id;

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:
973: l_wf_role fnd_user.user_name%TYPE;

Line 1035: WHERE user_id = fnd_global.user_id;

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:
1039: l_wf_role fnd_user.user_name%TYPE;

Line 1100: WHERE user_id = fnd_global.user_id;

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:
1104: l_wf_role fnd_user.user_name%TYPE;

Line 1228: WHERE user_id = fnd_global.user_id;

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
1232: FROM dual;

Line 1414: WHERE user_id = fnd_global.user_id;

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:
1418: l_wf_role fnd_user.user_name%TYPE;

Line 1474: WHERE user_id = fnd_global.user_id;

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:
1478: l_wf_role fnd_user.user_name%TYPE;

Line 1536: WHERE user_id = fnd_global.user_id;

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:
1540: l_wf_role fnd_user.user_name%TYPE;

Line 1597: WHERE user_id = fnd_global.user_id;

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:
1601: l_wf_role fnd_user.user_name%TYPE;

Line 1653: WHERE user_id = fnd_global.user_id;

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:
1657: l_wf_role fnd_user.user_name%TYPE;

Line 1711: WHERE user_id = fnd_global.user_id;

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:
1715: l_wf_role fnd_user.user_name%TYPE;

Line 1778: WHERE user_id = fnd_global.user_id;

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:
1782: l_wf_role fnd_user.user_name%TYPE;

Line 1848: WHERE user_id = fnd_global.user_id;

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:
1852: l_wf_role fnd_user.user_name%TYPE;