DBA Data[Home] [Help]

APPS.IGS_AD_WF_001 dependencies on WF_PARAMETER_LIST_T

Line 53: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

49:
50:
51: l_cur_prof_value cur_prof_value%ROWTYPE;
52: lv_raise_event VARCHAR2(100);
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;

Line 135: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

131:
132: ln_seq_val NUMBER;
133: lv_raise_event VARCHAR2(30);
134: lv_item_type VARCHAR2(100) ;
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;

Line 257: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

253:
254: ln_seq_val NUMBER;
255: lv_raise_event VARCHAR2(50);
256: lv_item_type VARCHAR2(100) ;
257: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
258:
259:
260: -- Get a unique sequence number
261: CURSOR

Line 324: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 387: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 454: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 523: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 586: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 648: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 712: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 777: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 841: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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

Line 906: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
909: l_seq_val NUMBER;
910: lv_raise_event VARCHAR2(100);

Line 971: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
974: l_seq_val NUMBER;
975: lv_raise_event VARCHAR2(100);

Line 1037: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1040: l_seq_val NUMBER;
1041: lv_raise_event VARCHAR2(100);

Line 1102: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1105: l_seq_val NUMBER;
1106: lv_raise_event VARCHAR2(100);

Line 1234: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

1230: CURSOR cur_prof_value IS
1231: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
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);

Line 1416: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1419: l_seq_val NUMBER;
1420: lv_raise_event VARCHAR2(100);

Line 1476: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1479: l_seq_val NUMBER;
1480: lv_raise_event VARCHAR2(100);

Line 1538: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1541: l_seq_val NUMBER;
1542: lv_raise_event VARCHAR2(100);

Line 1599: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1602: l_seq_val NUMBER;
1603: lv_raise_event VARCHAR2(100);

Line 1655: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1658: l_seq_val NUMBER;
1659: lv_raise_event VARCHAR2(100);

Line 1713: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1716: l_seq_val NUMBER;
1717: lv_raise_event VARCHAR2(100);

Line 1780: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1783: l_seq_val NUMBER;
1784: lv_raise_event VARCHAR2(100);

Line 1850: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

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;
1853: l_seq_val NUMBER;
1854: lv_raise_event VARCHAR2(100);

Line 1905: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();

1901: SELECT IGS_AD_BE_PRESUB_APPL_S.NEXTVAL
1902: FROM sys.dual;
1903:
1904:
1905: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1906:
1907: l_seq_val NUMBER;
1908: lv_raise_event VARCHAR2(100);
1909: BEGIN