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.

[Home] [Help]

APPS.IGS_AD_WF_001 dependencies on DUAL

Line 25: FROM dual;

21: */
22:
23: CURSOR cur_prof_value IS
24: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
25: FROM dual;
26:
27: -- Get a unique sequence number
28: CURSOR c_seq_num IS
29: SELECT igs_ad_acadindex_wf_s.NEXTVAL

Line 30: FROM sys.dual;

26:
27: -- Get a unique sequence number
28: CURSOR c_seq_num IS
29: SELECT igs_ad_acadindex_wf_s.NEXTVAL
30: FROM sys.dual;
31: ln_seq_val NUMBER;
32:
33: -- Get Person number and full name.
34: CURSOR get_person_attr IS

Line 145: FROM sys.dual;

141:
142: -- Get a unique sequence number
143: CURSOR c_seq_num IS
144: SELECT igs_ad_wf_req_submit_s.NEXTVAL
145: FROM sys.dual;
146:
147: -- Get Person number and full name.
148: CURSOR get_person_attr IS
149: SELECT person_number, full_name

Line 266: FROM SYS.DUAL;

262: c_seq_num
263: IS
264: SELECT
265: IGS_AD_WF_TXCPT_S.NEXTVAL
266: FROM SYS.DUAL;
267:
268:
269: BEGIN
270:

Line 317: FROM sys.dual;

313: ) AS
314: -- Get a unique sequence number
315: CURSOR c_seq_num IS
316: SELECT igs_ad_wf_tstscr_crt_s.NEXTVAL
317: FROM sys.dual;
318:
319: CURSOR cur_user_name IS
320: SELECT user_name
321: FROM fnd_user

Line 380: FROM sys.dual;

376: ) AS
377: -- Get a unique sequence number
378: CURSOR c_seq_num IS
379: SELECT igs_ad_wf_tstseg_crt_s.NEXTVAL
380: FROM sys.dual;
381:
382: CURSOR cur_user_name IS
383: SELECT user_name
384: FROM fnd_user

Line 447: FROM sys.dual;

443: ) AS
444: -- Get a unique sequence number
445: CURSOR c_seq_num IS
446: SELECT igs_ad_wf_tstscr_upd_s.NEXTVAL
447: FROM sys.dual;
448:
449: CURSOR cur_user_name IS
450: SELECT user_name
451: FROM fnd_user

Line 516: FROM sys.dual;

512: ) AS
513: -- Get a unique sequence number
514: CURSOR c_seq_num IS
515: SELECT igs_ad_wf_tstseg_upd_s.NEXTVAL
516: FROM sys.dual;
517:
518: CURSOR cur_user_name IS
519: SELECT user_name
520: FROM fnd_user

Line 579: FROM sys.dual;

575: ) AS
576: -- Get a unique sequence number
577: CURSOR c_seq_num IS
578: SELECT igs_ad_wf_acadhist_crt_s.NEXTVAL
579: FROM sys.dual;
580:
581: CURSOR cur_user_name IS
582: SELECT user_name
583: FROM fnd_user

Line 641: FROM sys.dual;

637: ) AS
638: -- Get a unique sequence number
639: CURSOR c_seq_num IS
640: SELECT igs_ad_wf_acadhist_upd_s.NEXTVAL
641: FROM sys.dual;
642:
643: CURSOR cur_user_name IS
644: SELECT user_name
645: FROM fnd_user

Line 705: FROM sys.dual;

701: ) AS
702: -- Get a unique sequence number
703: CURSOR c_seq_num IS
704: SELECT igs_ad_wf_txcpt_upd_s.NEXTVAL
705: FROM sys.dual;
706:
707: CURSOR cur_user_name IS
708: SELECT user_name
709: FROM fnd_user

Line 770: FROM sys.dual;

766: ) AS
767: -- Get a unique sequence number
768: CURSOR c_seq_num IS
769: SELECT igs_ad_wf_applcomp_upd_s.NEXTVAL
770: FROM sys.dual;
771:
772: CURSOR cur_user_name IS
773: SELECT user_name
774: FROM fnd_user

Line 834: FROM sys.dual;

830: ) AS
831: -- Get a unique sequence number
832: CURSOR c_seq_num IS
833: SELECT IGS_AD_WF_ENTQUAL_UPD_S.NEXTVAL
834: FROM sys.dual;
835:
836: CURSOR cur_user_name IS
837: SELECT user_name
838: FROM fnd_user

Line 899: FROM sys.dual;

895: ) AS
896: -- Get a unique sequence number
897: CURSOR c_seq_num IS
898: SELECT IGS_AD_WF_LATEFEE_UPD_S.NEXTVAL
899: FROM sys.dual;
900:
901: CURSOR cur_user_name IS
902: SELECT user_name
903: FROM fnd_user

Line 964: FROM sys.dual;

960: ) AS
961: -- Get a unique sequence number
962: CURSOR c_seq_num IS
963: SELECT IGS_AD_WF_CNDOFFER_UPD_S.NEXTVAL
964: FROM sys.dual;
965:
966: CURSOR cur_user_name IS
967: SELECT user_name
968: FROM fnd_user

Line 1030: FROM sys.dual;

1026: ) AS
1027: -- Get a unique sequence number
1028: CURSOR c_seq_num IS
1029: SELECT IGS_AD_WF_OFER_DEFER_UPD_S.NEXTVAL
1030: FROM sys.dual;
1031:
1032: CURSOR cur_user_name IS
1033: SELECT user_name
1034: FROM fnd_user

Line 1095: FROM sys.dual;

1091: ) AS
1092: -- Get a unique sequence number
1093: CURSOR c_seq_num IS
1094: SELECT IGS_AD_WF_WAITLIST_UPD_S.NEXTVAL
1095: FROM sys.dual;
1096:
1097: CURSOR cur_user_name IS
1098: SELECT user_name
1099: FROM fnd_user

Line 1223: FROM sys.dual;

1219: ) AS
1220: -- Get a unique sequence number
1221: CURSOR c_seq_num IS
1222: SELECT IGS_AD_WF_CRT_APPL_S.NEXTVAL
1223: FROM sys.dual;
1224:
1225: CURSOR cur_user_name IS
1226: SELECT user_name
1227: FROM fnd_user

Line 1232: FROM dual;

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;
1233:
1234: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1235:
1236: l_wf_role fnd_user.user_name%TYPE;

Line 1409: FROM sys.dual;

1405: ) AS
1406: -- Get a unique sequence number
1407: CURSOR c_seq_num IS
1408: SELECT IGS_AD_WF_ASSREQ_S.NEXTVAL
1409: FROM sys.dual;
1410:
1411: CURSOR cur_user_name IS
1412: SELECT user_name
1413: FROM fnd_user

Line 1469: FROM sys.dual;

1465: ) AS
1466: -- Get a unique sequence number
1467: CURSOR c_seq_num IS
1468: SELECT IGS_AD_WF_FEE_PAY_CRT_S.NEXTVAL
1469: FROM sys.dual;
1470:
1471: CURSOR cur_user_name IS
1472: SELECT user_name
1473: FROM fnd_user

Line 1531: FROM sys.dual;

1527: ) AS
1528: -- Get a unique sequence number
1529: CURSOR c_seq_num IS
1530: SELECT IGS_AD_WF_FEE_PAY_UPD_S.NEXTVAL
1531: FROM sys.dual;
1532:
1533: CURSOR cur_user_name IS
1534: SELECT user_name
1535: FROM fnd_user

Line 1592: FROM sys.dual;

1588: ) AS
1589: -- Get a unique sequence number
1590: CURSOR c_seq_num IS
1591: SELECT IGS_AD_WF_APP_PROC_STAT_UPD_S.NEXTVAL
1592: FROM sys.dual;
1593:
1594: CURSOR cur_user_name IS
1595: SELECT user_name
1596: FROM fnd_user

Line 1648: FROM sys.dual;

1644: ) AS
1645: -- Get a unique sequence number
1646: CURSOR c_seq_num IS
1647: SELECT IGS_AD_WF_APP_INST_STAT_UPD_S.NEXTVAL
1648: FROM sys.dual;
1649:
1650: CURSOR cur_user_name IS
1651: SELECT user_name
1652: FROM fnd_user

Line 1706: FROM sys.dual;

1702: ) AS
1703: -- Get a unique sequence number
1704: CURSOR c_seq_num IS
1705: SELECT IGS_AD_WF_APP_RECONS_REQ_S.NEXTVAL
1706: FROM sys.dual;
1707:
1708: CURSOR cur_user_name IS
1709: SELECT user_name
1710: FROM fnd_user

Line 1773: FROM sys.dual;

1769: ) AS
1770: -- Get a unique sequence number
1771: CURSOR c_seq_num IS
1772: SELECT IGS_AD_WF_APP_RECONS_REQ_S.NEXTVAL
1773: FROM sys.dual;
1774:
1775: CURSOR cur_user_name IS
1776: SELECT user_name
1777: FROM fnd_user

Line 1843: FROM sys.dual;

1839: ) AS
1840: -- Get a unique sequence number
1841: CURSOR c_seq_num IS
1842: SELECT IGS_AD_WF_APP_QUAL_CODE_S.NEXTVAL
1843: FROM sys.dual;
1844:
1845: CURSOR cur_user_name IS
1846: SELECT user_name
1847: FROM fnd_user

Line 1902: FROM sys.dual;

1898: ) AS
1899: -- Get a unique sequence number
1900: CURSOR c_seq_num IS
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: