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_EN_WORKFLOW dependencies on DUAL

Line 44: FROM DUAL;

40:
41: CURSOR cur_seq_val
42: IS
43: SELECT igs_en_status_mail_req_s.nextval seq_val
44: FROM DUAL;
45:
46: l_cur_seq_val cur_seq_val%ROWTYPE;
47: l_wf_parameter_list_t WF_PARAMETER_LIST_T:= wf_parameter_list_t();
48: l_wf_installed fnd_lookups.lookup_code%TYPE;

Line 101: FROM DUAL;

97:
98: CURSOR cur_seq_val
99: IS
100: SELECT igs_en_inst_action_s.nextval seq_val
101: FROM DUAL;
102:
103: l_cur_seq_val cur_seq_val%ROWTYPE;
104: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();
105: l_wf_installed fnd_lookups.lookup_code%TYPE;

Line 159: CURSOR cur_seq_val IS SELECT igs_en_stud_splperm_req_s.NEXTVAL seq_val FROM DUAL;

155: --knaraset 24-oct-02 Added parameter p_request_type and p_transaction_type, as part of build TD Audit,
156: --
157: -------------------------------------------------------------------------------------------------
158:
159: CURSOR cur_seq_val IS SELECT igs_en_stud_splperm_req_s.NEXTVAL seq_val FROM DUAL;
160:
161: l_cur_seq_val cur_seq_val%ROWTYPE;
162: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();
163: l_wf_installed fnd_lookups.lookup_code%TYPE;

Line 228: FROM dual;

224: -- Gets a unique sequence number
225:
226: CURSOR c_seq_num IS
227: SELECT igs_en_intrmn_s.NEXTVAL
228: FROM dual;
229:
230:
231: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
232:

Line 235: FROM dual;

231: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
232:
233: CURSOR cur_prof_value IS
234: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
235: FROM dual;
236:
237: -- Cursor for fetching the Program Type based on the program Attempt.
238:
239: CURSOR cur_prog_type IS

Line 364: FROM dual;

360: -- Gets a unique sequence number
361:
362: CURSOR c_seq_num IS
363: SELECT igs_en_prgdsc_s.NEXTVAL
364: FROM dual;
365:
366:
367: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
368:

Line 371: FROM dual;

367: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
368:
369: CURSOR cur_prof_value IS
370: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
371: FROM dual;
372:
373: -- Getting the logged in User
374:
375: CURSOR cur_user_id IS

Line 377: FROM dual;

373: -- Getting the logged in User
374:
375: CURSOR cur_user_id IS
376: SELECT FND_GLOBAL.USER_ID user_id
377: FROM dual;
378:
379: -- Getting the Discontinuation Reason for a Discontinuation Type
380:
381: CURSOR cur_discontinue_reason IS

Line 493: FROM dual;

489: -- Gets a unique sequence number
490:
491: CURSOR c_seq_num IS
492: SELECT igs_en_prgtrn_s.NEXTVAL
493: FROM dual;
494:
495:
496: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
497:

Line 500: FROM dual;

496: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
497:
498: CURSOR cur_prof_value IS
499: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
500: FROM dual;
501:
502: -- Getting the logged in User
503:
504: CURSOR cur_user_id IS

Line 506: FROM dual;

502: -- Getting the logged in User
503:
504: CURSOR cur_user_id IS
505: SELECT FND_GLOBAL.USER_ID user_id
506: FROM dual;
507:
508: l_cur_prof_value cur_prof_value%ROWTYPE;
509: l_cur_user_id cur_user_id%ROWTYPE;
510:

Line 611: FROM dual;

607: -- Gets a unique sequence number
608:
609: CURSOR c_seq_num IS
610: SELECT igs_en_profop_s.NEXTVAL
611: FROM dual;
612:
613:
614: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
615:

Line 618: FROM dual;

614: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
615:
616: CURSOR cur_prof_value IS
617: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
618: FROM dual;
619:
620: -- Getting the logged in User
621:
622: CURSOR cur_user_id IS

Line 624: FROM dual;

620: -- Getting the logged in User
621:
622: CURSOR cur_user_id IS
623: SELECT FND_GLOBAL.USER_ID user_id
624: FROM dual;
625:
626: l_cur_prof_value cur_prof_value%ROWTYPE;
627: l_cur_user_id cur_user_id%ROWTYPE;
628:

Line 1564: FROM dual;

1560:
1561: -- Gets a unique sequence number
1562: CURSOR c_seq_num IS
1563: SELECT igs_en_student_placement_s.NEXTVAL
1564: FROM dual;
1565:
1566: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
1567: CURSOR cur_prof_value IS
1568: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value

Line 1569: FROM dual;

1565:
1566: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment
1567: CURSOR cur_prof_value IS
1568: SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
1569: FROM dual;
1570:
1571: -- Cursor to fetch the person number
1572: CURSOR cur_pers_number(cp_person_id NUMBER) IS
1573: SELECT party_number

Line 1757: SELECT igs_en_withdraw_perm_S.nextval INTO l_t_temp from dual;

1753:
1754: --
1755: -- raise the event
1756:
1757: SELECT igs_en_withdraw_perm_S.nextval INTO l_t_temp from dual;
1758:
1759: wf_event.raise (
1760: p_event_name => 'oracle.apps.igs.en.withdraw_perm',
1761: p_event_key => 'WITHDRAW'||l_t_temp,

Line 1792: FROM DUAL;

1788:
1789:
1790: CURSOR cur_seq_val IS
1791: SELECT igs_en_intm_rcond_s.nextval seq_val
1792: FROM DUAL;
1793:
1794: CURSOR c_person_dtls (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
1795: SELECT party_number,party_name
1796: FROM hz_parties