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.

APPS.IGS_EN_GEN_011 dependencies on IGS_EN_STDNT_PS_ATT

Line 22: -- ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

18: -- running the 'Bulk Program Offering Option Transfer Process' as per bug 3985220
19: --ckasu 13-Sep-2004 Modified Enrp_Prc_Sua_Blk_E_D procedure inorder to consider Person step validations in
20: -- Discontinuing and Droping units as part of Bug 3823810.
21: --vkarthik 31-Aug-2004 Deny all hold validation added to bulk enrollment/discontinuation job as part of Bug 3823810
22: -- ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
23: -- call as a part of bug 3544927.
24:
25: --rvangala 13-Feb-2004 Bug 3433542. Modified Cursor c_sua in enrp_prc_sua_blk_trn to ensure that students with end_date
26: -- prior to sysdate are not processed

Line 60: -- igs_en_stdnt_ps_att and enrp_get_var_window

56: --pradhakr 12/07/2001 Added one parameter p_dcnt_reason_cd in
57: -- the procedure Enrp_prc_sua_enr_ds as part
58: -- of Enrollment build (Bug # 1832130 )
59: --smaddali 1-08-2001 Modified calls to igs_en_su_attempt and
60: -- igs_en_stdnt_ps_att and enrp_get_var_window
61: -- and enrp_get_rec_window , added new columns(Bug # 1832130 )
62: --Bayadav 5-sep-2001 Added refernces to column ORG_UNIT_CD incall to
63: -- IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
64: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.

Line 64: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.

60: -- igs_en_stdnt_ps_att and enrp_get_var_window
61: -- and enrp_get_rec_window , added new columns(Bug # 1832130 )
62: --Bayadav 5-sep-2001 Added refernces to column ORG_UNIT_CD incall to
63: -- IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
64: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
65: -- Added four new parameters to call it as per the Bug# 2027984.
66: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
67: --nalkumar 21-NOV-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
68: -- Added key program parameter to call it as per the Bug# 2027984.

Line 67: --nalkumar 21-NOV-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.

63: -- IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
64: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
65: -- Added four new parameters to call it as per the Bug# 2027984.
66: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
67: --nalkumar 21-NOV-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
68: -- Added key program parameter to call it as per the Bug# 2027984.
69: --pradhakr 07-Dec-2001 Added the column deg_aud_detail_id in the
70: -- TBH calls as part of Degree Audit Interface build.
71: -- (Bug# 2033208)

Line 261: FROM igs_en_stdnt_ps_att sca

257: sca.course_attempt_status,
258: sca.commencement_dt,
259: sca.coo_id,
260: sca.funding_source
261: FROM igs_en_stdnt_ps_att sca
262: WHERE
263: sca.course_cd = p_course_cd
264: AND
265: ((sca.person_id in (select person_id from IGS_PE_PRSID_GRP_MEM WHERE

Line 309: v_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE ;

305: v_total_lock_count NUMBER := 0;
306: v_sca_error_count NUMBER := 0;
307: v_sca_warn_count NUMBER := 0;
308: v_sca_trnsfr_count NUMBER := 0;
309: v_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE ;
310: v_to_crs_version_number
311: IGS_EN_STDNT_PS_ATT.version_number%TYPE ;
312: v_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE ;
313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;

Line 311: IGS_EN_STDNT_PS_ATT.version_number%TYPE ;

307: v_sca_warn_count NUMBER := 0;
308: v_sca_trnsfr_count NUMBER := 0;
309: v_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE ;
310: v_to_crs_version_number
311: IGS_EN_STDNT_PS_ATT.version_number%TYPE ;
312: v_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE ;
313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;
314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;
315: PROCEDURE enrpl_upd_sca_coo(

Line 312: v_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE ;

308: v_sca_trnsfr_count NUMBER := 0;
309: v_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE ;
310: v_to_crs_version_number
311: IGS_EN_STDNT_PS_ATT.version_number%TYPE ;
312: v_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE ;
313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;
314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;
315: PROCEDURE enrpl_upd_sca_coo(
316: p_person_id IGS_PE_PERSON.person_id%TYPE,

Line 313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;

309: v_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE ;
310: v_to_crs_version_number
311: IGS_EN_STDNT_PS_ATT.version_number%TYPE ;
312: v_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE ;
313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;
314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;
315: PROCEDURE enrpl_upd_sca_coo(
316: p_person_id IGS_PE_PERSON.person_id%TYPE,
317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;

310: v_to_crs_version_number
311: IGS_EN_STDNT_PS_ATT.version_number%TYPE ;
312: v_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE ;
313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;
314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;
315: PROCEDURE enrpl_upd_sca_coo(
316: p_person_id IGS_PE_PERSON.person_id%TYPE,
317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

Line 317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;
314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;
315: PROCEDURE enrpl_upd_sca_coo(
316: p_person_id IGS_PE_PERSON.person_id%TYPE,
317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,

Line 318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;
315: PROCEDURE enrpl_upd_sca_coo(
316: p_person_id IGS_PE_PERSON.person_id%TYPE,
317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,

Line 321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,

317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,

Line 322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,

318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

Line 323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,

319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,

Line 324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,

320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,

Line 325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,

321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
329: p_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,

Line 326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
329: p_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
330: p_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,

Line 327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,

323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
329: p_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
330: p_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
331: p_sca_error_count IN OUT NOCOPY NUMBER,

Line 328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,

324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,
325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
329: p_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
330: p_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
331: p_sca_error_count IN OUT NOCOPY NUMBER,
332: p_sca_warn_count IN OUT NOCOPY NUMBER,

Line 329: p_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,

325: p_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE,
326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
329: p_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
330: p_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
331: p_sca_error_count IN OUT NOCOPY NUMBER,
332: p_sca_warn_count IN OUT NOCOPY NUMBER,
333: p_sca_trnsfr_count IN OUT NOCOPY NUMBER)

Line 330: p_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,

326: p_to_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
327: p_to_acad_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
328: p_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
329: p_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
330: p_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
331: p_sca_error_count IN OUT NOCOPY NUMBER,
332: p_sca_warn_count IN OUT NOCOPY NUMBER,
333: p_sca_trnsfr_count IN OUT NOCOPY NUMBER)
334: AS

Line 340: sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

336:
337: /****************************************************************************
338: History
339: Who When Why
340: sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
341: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
342: call as a part of bug 3544927.
343: stutta 03-Nov-2004 Added call igs_en_val_sca.enrp_val_chgo_alwd to log a
344: warning message. bug#3959306

Line 341: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

337: /****************************************************************************
338: History
339: Who When Why
340: sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
341: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
342: call as a part of bug 3544927.
343: stutta 03-Nov-2004 Added call igs_en_val_sca.enrp_val_chgo_alwd to log a
344: warning message. bug#3959306
345: jtmathew 05-Nov-2004 Modifications as per HESA DLD for bug 3985220

Line 410: SELECT rowid,IGS_EN_STDNT_PS_ATT.*

406: coous.coo_id = cp_coo_id ;
407:
408: v_coousv_exists VARCHAR2(1);
409: CURSOR c_sca_upd IS
410: SELECT rowid,IGS_EN_STDNT_PS_ATT.*
411: FROM IGS_EN_STDNT_PS_ATT
412: WHERE person_id = p_person_id AND
413: course_cd = p_course_cd
414: FOR UPDATE OF

Line 411: FROM IGS_EN_STDNT_PS_ATT

407:
408: v_coousv_exists VARCHAR2(1);
409: CURSOR c_sca_upd IS
410: SELECT rowid,IGS_EN_STDNT_PS_ATT.*
411: FROM IGS_EN_STDNT_PS_ATT
412: WHERE person_id = p_person_id AND
413: course_cd = p_course_cd
414: FOR UPDATE OF
415: version_number,

Line 653: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

649: END IF;
650: END IF; -- If enrolled.
651: FOR v_sca_upd_exists In c_sca_upd LOOP
652: -- Update the record.
653: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
654: X_ROWID => v_sca_upd_exists.rowid,
655: X_PERSON_ID => v_sca_upd_exists.PERSON_ID,
656: X_COURSE_CD => v_sca_upd_exists.COURSE_CD,
657: X_ADVANCED_STANDING_IND => v_sca_upd_exists.ADVANCED_STANDING_IND,

Line 1345: FROM IGS_EN_STDNT_PS_ATT sca

1341: CURSOR c_sca IS SELECT sca.person_id,
1342: sca.course_cd,
1343: sca.version_number,
1344: sca.coo_id
1345: FROM IGS_EN_STDNT_PS_ATT sca
1346: WHERE -- person_id matches
1347:
1348: (p_group_id IS NULL OR
1349: EXISTS (

Line 2793: igs_en_stdnt_ps_att sca

2789: sca.version_number program_version_number,
2790: sua.uoo_id
2791: FROM
2792: igs_en_su_attempt sua,
2793: igs_en_stdnt_ps_att sca
2794: WHERE (
2795: (p_course_cd IS NULL OR sca.course_cd LIKE p_course_cd) AND
2796: (sca.course_attempt_status NOT IN ('LAPSED','DISCONTIN')) AND
2797: (p_location_cd IS NULL OR

Line 3099: FROM igs_en_stdnt_ps_att spa,

3095: cp_load_cal_type IN VARCHAR2,
3096: cp_load_sequence_number IN NUMBER)
3097: IS
3098: SELECT NVL(spat.coo_id, spa.coo_id) coo_id
3099: FROM igs_en_stdnt_ps_att spa,
3100: igs_en_spa_terms spat
3101: WHERE
3102: spa.course_cd = cp_course_cd AND
3103: spa.person_id = cp_person_id AND

Line 5867: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

5863: acaiv.cndtnl_offer_must_be_stsfd_ind) = 'Y'
5864: ORDER BY
5865: acaiv.offer_dt DESC;
5866: CURSOR c_acai_upd (
5867: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5868: cp_admission_appl_number
5869: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
5870: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
5871: cp_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS

Line 5869: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,

5865: acaiv.offer_dt DESC;
5866: CURSOR c_acai_upd (
5867: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5868: cp_admission_appl_number
5869: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
5870: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
5871: cp_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
5872: SELECT rowid,acai.*
5873: FROM IGS_AD_PS_APPL_INST acai

Line 5870: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,

5866: CURSOR c_acai_upd (
5867: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5868: cp_admission_appl_number
5869: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
5870: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
5871: cp_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
5872: SELECT rowid,acai.*
5873: FROM IGS_AD_PS_APPL_INST acai
5874: WHERE acai.person_id = cp_person_id AND

Line 5871: cp_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS

5867: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5868: cp_admission_appl_number
5869: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
5870: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
5871: cp_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
5872: SELECT rowid,acai.*
5873: FROM IGS_AD_PS_APPL_INST acai
5874: WHERE acai.person_id = cp_person_id AND
5875: acai.admission_appl_number = cp_admission_appl_number AND