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_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_SUB_RTN_QUAL

Line 6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,

2: /* $Header: IGSHE25B.pls 120.4 2006/09/12 01:18:21 jtmathew ship $ */
3:
4: PROCEDURE dlhe_identify_population (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: ) IS
10: /******************************************************************

Line 7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

3:
4: PROCEDURE dlhe_identify_population (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: ) IS
10: /******************************************************************
11: Created By : prasad marada

Line 8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE

4: PROCEDURE dlhe_identify_population (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER,
6: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
7: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
8: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE
9: ) IS
10: /******************************************************************
11: Created By : prasad marada
12: Date Created By : 20-Apr-2003

Line 22: CURSOR cur_qual_period (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,

18: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
19: *******************************************************************/
20:
21: -- Get the all qualifying periods under the submission order by closed
22: CURSOR cur_qual_period (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
23: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
24: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
25: SELECT qual.qual_period_code,
26: qual.qual_period_desc,

Line 23: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,

19: *******************************************************************/
20:
21: -- Get the all qualifying periods under the submission order by closed
22: CURSOR cur_qual_period (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
23: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
24: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
25: SELECT qual.qual_period_code,
26: qual.qual_period_desc,
27: qual.qual_period_type,

Line 24: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS

20:
21: -- Get the all qualifying periods under the submission order by closed
22: CURSOR cur_qual_period (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
23: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
24: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
25: SELECT qual.qual_period_code,
26: qual.qual_period_desc,
27: qual.qual_period_type,
28: qual.qual_period_start_date,

Line 31: FROM igs_he_sub_rtn_qual qual,

27: qual.qual_period_type,
28: qual.qual_period_start_date,
29: qual.qual_period_end_date,
30: qual.closed_ind
31: FROM igs_he_sub_rtn_qual qual,
32: igs_he_usr_rtn_clas urc
33: WHERE qual.submission_name = cp_submission_name
34: AND qual.return_name = cp_return_name
35: AND qual.qual_period_code = NVL(cp_qual_period, qual.qual_period_code)

Line 92: PROCEDURE dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,

88: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
89:
90: END dlhe_identify_population;
91:
92: PROCEDURE dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
93: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,

Line 93: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

89:
90: END dlhe_identify_population;
91:
92: PROCEDURE dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
93: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
97: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,

Line 94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,

90: END dlhe_identify_population;
91:
92: PROCEDURE dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
93: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
97: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
98: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE

Line 95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,

91:
92: PROCEDURE dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
93: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
97: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
98: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
99: ) IS

Line 96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,

92: PROCEDURE dlhe_identify_spa (p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
93: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
97: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
98: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
99: ) IS
100:

Line 97: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,

93: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
97: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
98: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
99: ) IS
100:
101: /******************************************************************

Line 98: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE

94: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
95: p_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
96: p_qual_start_date IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
97: p_qual_end_date IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
98: p_closed_ind IN igs_he_sub_rtn_qual.closed_ind%TYPE
99: ) IS
100:
101: /******************************************************************
102: Created By : prasad marada

Line 116: CURSOR cur_closed_dlhe (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,

112: Program and POOUS records for HE305 - Extract Improvements
113: *******************************************************************/
114:
115: -- Get the dlhe rowid for closed qualifying period records
116: CURSOR cur_closed_dlhe (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
117: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
118: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
119: SELECT rowid
120: FROM igs_he_stdnt_dlhe

Line 117: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,

113: *******************************************************************/
114:
115: -- Get the dlhe rowid for closed qualifying period records
116: CURSOR cur_closed_dlhe (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
117: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
118: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
119: SELECT rowid
120: FROM igs_he_stdnt_dlhe
121: WHERE submission_name = cp_submission_name

Line 118: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS

114:
115: -- Get the dlhe rowid for closed qualifying period records
116: CURSOR cur_closed_dlhe (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
117: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
118: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
119: SELECT rowid
120: FROM igs_he_stdnt_dlhe
121: WHERE submission_name = cp_submission_name
122: AND return_name = cp_return_name

Line 129: CURSOR cur_leavers_std (cp_qual_start_dt igs_he_sub_rtn_qual.qual_period_start_date%TYPE,

125:
126: -- Get the LEAVERS Students person_id and SPA details
127: -- smaddali modified cursor to remove condition course_attempt_status IN 'COMPLETED','DISCONTIN',
128: -- because the status need not be only completed/discontinued for a leaver, bug 3335847
129: CURSOR cur_leavers_std (cp_qual_start_dt igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
130: cp_qual_end_dt igs_he_sub_rtn_qual.qual_period_end_date%TYPE) IS
131: SELECT hst.person_id,
132: hst.course_cd,
133: sca.version_number

Line 130: cp_qual_end_dt igs_he_sub_rtn_qual.qual_period_end_date%TYPE) IS

126: -- Get the LEAVERS Students person_id and SPA details
127: -- smaddali modified cursor to remove condition course_attempt_status IN 'COMPLETED','DISCONTIN',
128: -- because the status need not be only completed/discontinued for a leaver, bug 3335847
129: CURSOR cur_leavers_std (cp_qual_start_dt igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
130: cp_qual_end_dt igs_he_sub_rtn_qual.qual_period_end_date%TYPE) IS
131: SELECT hst.person_id,
132: hst.course_cd,
133: sca.version_number
134: FROM igs_en_stdnt_ps_att sca,

Line 393: PROCEDURE dlhe_process_spa( P_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,

389:
390: END dlhe_identify_spa;
391:
392:
393: PROCEDURE dlhe_process_spa( P_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
394: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
397: p_person_id IN igs_he_st_spa.person_id%TYPE,

Line 394: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

390: END dlhe_identify_spa;
391:
392:
393: PROCEDURE dlhe_process_spa( P_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
394: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
397: p_person_id IN igs_he_st_spa.person_id%TYPE,
398: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

Line 395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,

391:
392:
393: PROCEDURE dlhe_process_spa( P_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
394: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
397: p_person_id IN igs_he_st_spa.person_id%TYPE,
398: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
399: p_version_number IN igs_he_st_spa.version_number%TYPE,

Line 396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,

392:
393: PROCEDURE dlhe_process_spa( P_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
394: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
395: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
396: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
397: p_person_id IN igs_he_st_spa.person_id%TYPE,
398: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
399: p_version_number IN igs_he_st_spa.version_number%TYPE,
400: p_cre_upd_dlhe OUT NOCOPY VARCHAR2

Line 413: CURSOR cur_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,

409: Who When What
410: *******************************************************************/
411:
412: -- Cursor to get the Qualification details for validations and update the student dlhe table.
413: CURSOR cur_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
414: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
415: cp_qual_period_code igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
416: SELECT qual.qual_period_start_date,
417: qual.qual_period_end_date,

Line 414: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,

410: *******************************************************************/
411:
412: -- Cursor to get the Qualification details for validations and update the student dlhe table.
413: CURSOR cur_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
414: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
415: cp_qual_period_code igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
416: SELECT qual.qual_period_start_date,
417: qual.qual_period_end_date,
418: qual.user_return_subclass,

Line 415: cp_qual_period_code igs_he_sub_rtn_qual.qual_period_code%TYPE) IS

411:
412: -- Cursor to get the Qualification details for validations and update the student dlhe table.
413: CURSOR cur_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
414: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
415: cp_qual_period_code igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
416: SELECT qual.qual_period_start_date,
417: qual.qual_period_end_date,
418: qual.user_return_subclass,
419: qual.closed_ind

Line 420: FROM igs_he_sub_rtn_qual qual,

416: SELECT qual.qual_period_start_date,
417: qual.qual_period_end_date,
418: qual.user_return_subclass,
419: qual.closed_ind
420: FROM igs_he_sub_rtn_qual qual,
421: igs_he_usr_rtn_clas urc
422: WHERE qual.submission_name = cp_submission_name
423: AND qual.return_name = cp_return_name
424: AND qual.qual_period_code = cp_qual_period_code

Line 692: PROCEDURE dlhe_review_spa( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,

688: App_Exception.Raise_Exception;
689:
690: END dlhe_process_spa;
691:
692: PROCEDURE dlhe_review_spa( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
693: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,

Line 693: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

689:
690: END dlhe_process_spa;
691:
692: PROCEDURE dlhe_review_spa( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
693: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,

Line 694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,

690: END dlhe_process_spa;
691:
692: PROCEDURE dlhe_review_spa( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
693: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
698: p_person_id IN igs_he_st_spa.person_id%TYPE,

Line 695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,

691:
692: PROCEDURE dlhe_review_spa( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
693: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
698: p_person_id IN igs_he_st_spa.person_id%TYPE,
699: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

Line 696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,

692: PROCEDURE dlhe_review_spa( p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
693: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
698: p_person_id IN igs_he_st_spa.person_id%TYPE,
699: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
700: p_version_number IN igs_he_st_spa.version_number%TYPE,

Line 697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,

693: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
694: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
695: P_qual_type IN igs_he_sub_rtn_qual.qual_period_type%TYPE,
696: p_qual_start_dt IN igs_he_sub_rtn_qual.qual_period_start_date%TYPE,
697: p_qual_end_dt IN igs_he_sub_rtn_qual.qual_period_end_date%TYPE,
698: p_person_id IN igs_he_st_spa.person_id%TYPE,
699: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
700: p_version_number IN igs_he_st_spa.version_number%TYPE,
701: p_include OUT NOCOPY VARCHAR2,