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_ST_GEN_004 dependencies on IGS_ST_GVT_STDNTLOAD

Line 267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;

263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;
267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;
269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;
270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;

Line 317: v_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE;

313: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
314: v_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE;
315: v_hecs_fee NUMBER;
316: v_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
317: v_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE;
318: v_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE DEFAULT NULL;
319: v_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE DEFAULT NULL;
320: v_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE;
321: v_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%TYPE;

Line 318: v_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE DEFAULT NULL;

314: v_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE;
315: v_hecs_fee NUMBER;
316: v_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
317: v_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE;
318: v_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE DEFAULT NULL;
319: v_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE DEFAULT NULL;
320: v_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE;
321: v_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%TYPE;
322: v_total_eftsu IGS_ST_GVT_STDNT_LBL.total_eftsu%TYPE;

Line 319: v_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE DEFAULT NULL;

315: v_hecs_fee NUMBER;
316: v_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
317: v_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE;
318: v_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE DEFAULT NULL;
319: v_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE DEFAULT NULL;
320: v_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE;
321: v_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%TYPE;
322: v_total_eftsu IGS_ST_GVT_STDNT_LBL.total_eftsu%TYPE;
323: v_hecs_prexmt_exie_update IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;

Line 320: v_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE;

316: v_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
317: v_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE;
318: v_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE DEFAULT NULL;
319: v_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE DEFAULT NULL;
320: v_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE;
321: v_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%TYPE;
322: v_total_eftsu IGS_ST_GVT_STDNT_LBL.total_eftsu%TYPE;
323: v_hecs_prexmt_exie_update IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;
324: v_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;

Line 338: v_unit_total_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;

334: v_major_course IGS_ST_GOVT_STDNT_EN.major_course%TYPE;
335: v_on BOOLEAN DEFAULT FALSE;
336: v_off BOOLEAN DEFAULT FALSE;
337: v_composite BOOLEAN DEFAULT FALSE;
338: v_unit_total_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;
339: v_unit_industrial_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;
340: v_logged_ind BOOLEAN;
341: v_s_log_type Varchar2(10);
342: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;

Line 339: v_unit_industrial_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;

335: v_on BOOLEAN DEFAULT FALSE;
336: v_off BOOLEAN DEFAULT FALSE;
337: v_composite BOOLEAN DEFAULT FALSE;
338: v_unit_total_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;
339: v_unit_industrial_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;
340: v_logged_ind BOOLEAN;
341: v_s_log_type Varchar2(10);
342: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
343: v_upd_total_eftsu IGS_ST_GVT_STDNT_LBL.total_eftsu%TYPE;

Line 352: v_old_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;

348: v_ret INTEGER;
349: v_start_dt_time DATE;
350: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
351: v_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE;
352: v_old_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
353: v_old_person_id IGS_PE_PERSON.person_id%TYPE;
354: v_old_course_cd IGS_PS_VER.course_cd%TYPE;
355: v_appl_owner all_indexes.owner%TYPE;
356: v_start_dt DATE;

Line 365: FROM IGS_ST_GVT_STDNTLOAD sgs,

361: v_ret INTEGER;
362: v_unit_completion_stat NUMBER;
363: CURSOR Cur_si_st_govtstdldtmp IS
364: SELECT sgs.*,uoo.uoo_id
365: FROM IGS_ST_GVT_STDNTLOAD sgs,
366: igs_ps_unit_ofr_opt uoo
367: WHERE sgs.submission_yr = p_submission_yr AND
368: sgs.submission_number = (p_submission_number - 1) AND
369: sgs.unit_cd = uoo.unit_cd AND

Line 512: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,

508: FROM IGS_ST_GOVT_STDNT_EN gse
509: WHERE gse.submission_yr = p_submission_yr AND
510: gse.submission_number = p_submission_number;
511: CURSOR c_gslo (
512: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
513: cp_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE) IS
514: SELECT gslo.unit_cd,
515: gslo.sua_cal_type,
516: gslo.sua_ci_sequence_number,

Line 513: cp_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE) IS

509: WHERE gse.submission_yr = p_submission_yr AND
510: gse.submission_number = p_submission_number;
511: CURSOR c_gslo (
512: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
513: cp_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE) IS
514: SELECT gslo.unit_cd,
515: gslo.sua_cal_type,
516: gslo.sua_ci_sequence_number,
517: gslo.govt_semester,

Line 524: FROM IGS_ST_GVT_STDNTLOAD gslo

520: gslo.discipline_group_cd,
521: gslo.govt_discipline_group_cd,
522: gslo.sua_location_cd,
523: gslo.unit_class
524: FROM IGS_ST_GVT_STDNTLOAD gslo
525: WHERE gslo.submission_yr = p_submission_yr AND
526: gslo.submission_number = p_submission_number AND
527: gslo.person_id = cp_person_id AND
528: gslo.course_cd = cp_course_cd AND

Line 568: FROM IGS_ST_GVT_STDNTLOAD gsl

564: WHERE gse.submission_yr = p_submission_yr AND
565: gse.submission_number = p_submission_number AND
566: cp_lower_enr_load_range <=
567: (SELECT SUM(gsl.eftsu)
568: FROM IGS_ST_GVT_STDNTLOAD gsl
569: WHERE gsl.submission_yr = p_submission_yr AND
570: gsl.submission_number = p_submission_number AND
571: gsl.person_id = gse.person_id);
572: -- Cursor for searching through ess records to find students

Line 589: IGS_ST_GVT_STDNTLOAD gslo,

585: SELECT gse.person_id,
586: gse.course_cd,
587: SUM(gslo.eftsu)
588: FROM IGS_ST_GOVT_STDNT_EN gse,
589: IGS_ST_GVT_STDNTLOAD gslo,
590: IGS_EN_STDNT_PS_ATT sca
591: WHERE gse.submission_yr = p_submission_yr AND
592: gse.submission_number = p_submission_number AND
593: gse.person_id = cp_person_id AND

Line 631: FROM IGS_ST_GVT_STDNTLOAD gslo

627: gsli.govt_semester = cp_govt_semester
628: FOR UPDATE OF gsli.last_updated_by NOWAIT;
629: CURSOR c_gslo_upd IS
630: SELECT rowid,gslo.*
631: FROM IGS_ST_GVT_STDNTLOAD gslo
632: WHERE submission_yr = p_submission_yr AND
633: submission_number = p_submission_number
634: FOR UPDATE OF gslo.last_updated_by NOWAIT;
635: CURSOR c_get_indus_ind (

Line 647: FROM IGS_ST_GVT_STDNTLOAD gslo

643: SELECT gslo.person_id,
644: gslo.course_cd,
645: gslo.govt_semester,
646: NVL(SUM(gslo.eftsu), 0) v_upd_total_eftsu
647: FROM IGS_ST_GVT_STDNTLOAD gslo
648: WHERE gslo.submission_yr = p_submission_yr AND
649: gslo.submission_number = p_submission_number
650: GROUP BY gslo.person_id,
651: gslo.course_cd,

Line 658: FROM IGS_ST_GVT_STDNTLOAD gslo

654: SELECT gslo.person_id,
655: gslo.course_cd,
656: gslo.govt_semester,
657: NVL(SUM(gslo.eftsu), 0) v_upd_indus_eftsu
658: FROM IGS_ST_GVT_STDNTLOAD gslo
659: WHERE gslo.submission_yr = p_submission_yr AND
660: gslo.submission_number = p_submission_number AND
661: gslo.industrial_ind = 'Y'
662: GROUP BY gslo.person_id,

Line 758: p_sub_yr IGS_ST_GVT_STDNTLOAD.submission_yr%TYPE,

754: IGS_GE_MSG_STACK.ADD;
755: App_Exception.Raise_Exception;
756: END stapl_val_unit_compltn_status;
757: PROCEDURE stapl_ins_govt_sdnt_load_rec(
758: p_sub_yr IGS_ST_GVT_STDNTLOAD.submission_yr%TYPE,
759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,
760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,

Line 759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,

755: App_Exception.Raise_Exception;
756: END stapl_val_unit_compltn_status;
757: PROCEDURE stapl_ins_govt_sdnt_load_rec(
758: p_sub_yr IGS_ST_GVT_STDNTLOAD.submission_yr%TYPE,
759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,
760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,

Line 760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,

756: END stapl_val_unit_compltn_status;
757: PROCEDURE stapl_ins_govt_sdnt_load_rec(
758: p_sub_yr IGS_ST_GVT_STDNTLOAD.submission_yr%TYPE,
759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,
760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,

Line 761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,

757: PROCEDURE stapl_ins_govt_sdnt_load_rec(
758: p_sub_yr IGS_ST_GVT_STDNTLOAD.submission_yr%TYPE,
759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,
760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,

Line 762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,

758: p_sub_yr IGS_ST_GVT_STDNTLOAD.submission_yr%TYPE,
759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,
760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,

Line 763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,

759: p_sub_number IGS_ST_GVT_STDNTLOAD.submission_number%TYPE,
760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,

Line 764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,

760: p_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,

Line 765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,

761: p_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE,
762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,

Line 766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,

762: p_crv_version_number IGS_ST_GVT_STDNTLOAD.crv_version_number%TYPE,
763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,

Line 767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,

763: p_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,
771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,

Line 768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,

764: p_unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,
771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
772: p_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,

Line 769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,

765: p_uv_version_number IGS_ST_GVT_STDNTLOAD.uv_version_number%TYPE,
766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,
771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
772: p_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
773: p_eftsu NUMBER,

Line 770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,

766: p_sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,
771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
772: p_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
773: p_eftsu NUMBER,
774: p_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE,

Line 771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,

767: p_sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,
771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
772: p_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
773: p_eftsu NUMBER,
774: p_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE,
775: p_logged_ind IN OUT NOCOPY BOOLEAN,

Line 772: p_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,

768: p_tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
769: p_tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,
771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
772: p_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
773: p_eftsu NUMBER,
774: p_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE,
775: p_logged_ind IN OUT NOCOPY BOOLEAN,
776: p_s_log_type VARCHAR2,

Line 774: p_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE,

770: p_discipline_group_cd IGS_ST_GVT_STDNTLOAD.discipline_group_cd%TYPE,
771: p_govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
772: p_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
773: p_eftsu NUMBER,
774: p_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE,
775: p_logged_ind IN OUT NOCOPY BOOLEAN,
776: p_s_log_type VARCHAR2,
777: p_creation_dt DATE,
778: p_sua_location_cd IN IGS_ST_GVT_STDNTLOAD.sua_location_cd%TYPE,

Line 778: p_sua_location_cd IN IGS_ST_GVT_STDNTLOAD.sua_location_cd%TYPE,

774: p_unit_completion_status IGS_ST_GVT_STDNTLOAD.unit_completion_status%TYPE,
775: p_logged_ind IN OUT NOCOPY BOOLEAN,
776: p_s_log_type VARCHAR2,
777: p_creation_dt DATE,
778: p_sua_location_cd IN IGS_ST_GVT_STDNTLOAD.sua_location_cd%TYPE,
779: p_unit_class IN IGS_ST_GVT_STDNTLOAD.unit_class%TYPE)
780: AS
781: gv_other_detail VARCHAR2(255);
782: BEGIN

Line 779: p_unit_class IN IGS_ST_GVT_STDNTLOAD.unit_class%TYPE)

775: p_logged_ind IN OUT NOCOPY BOOLEAN,
776: p_s_log_type VARCHAR2,
777: p_creation_dt DATE,
778: p_sua_location_cd IN IGS_ST_GVT_STDNTLOAD.sua_location_cd%TYPE,
779: p_unit_class IN IGS_ST_GVT_STDNTLOAD.unit_class%TYPE)
780: AS
781: gv_other_detail VARCHAR2(255);
782: BEGIN
783: DECLARE

Line 786: -- insert a record into IGS_ST_GVT_STDNTLOAD

782: BEGIN
783: DECLARE
784: v_rowid VARCHAR2(25);
785: BEGIN
786: -- insert a record into IGS_ST_GVT_STDNTLOAD
787: -- to insert row using the insertrow of TBH package
788: IGS_ST_GVT_STDNTLOAD_PKG.INSERT_ROW(
789: X_ROWID => v_rowid,
790: X_SUBMISSION_YR => p_sub_yr,

Line 788: IGS_ST_GVT_STDNTLOAD_PKG.INSERT_ROW(

784: v_rowid VARCHAR2(25);
785: BEGIN
786: -- insert a record into IGS_ST_GVT_STDNTLOAD
787: -- to insert row using the insertrow of TBH package
788: IGS_ST_GVT_STDNTLOAD_PKG.INSERT_ROW(
789: X_ROWID => v_rowid,
790: X_SUBMISSION_YR => p_sub_yr,
791: X_SUBMISSION_NUMBER => p_sub_number,
792: X_PERSON_ID => p_person_id,

Line 1304: IGS_ST_GVT_STDNTLOAD_PKG.DELETE_ROW(

1300: END;
1301: BEGIN
1302: FOR v_gslo_upd_rec IN c_gslo_upd LOOP
1303:
1304: IGS_ST_GVT_STDNTLOAD_PKG.DELETE_ROW(
1305: X_ROWID => v_gslo_upd_rec.rowid);
1306:
1307: END LOOP;
1308: EXCEPTION

Line 2094: -- get IGS_ST_GVT_STDNTLOAD details

2090:
2091: IF (p_submission_number = 1) THEN
2092: -- Update the Attendance Mode value for inserted records.
2093: FOR v_gse_att_mode IN c_gse_att_mode LOOP
2094: -- get IGS_ST_GVT_STDNTLOAD details
2095: FOR v_gslo IN c_gslo(
2096: v_gse_att_mode.person_id,
2097: v_gse_att_mode.course_cd) LOOP
2098: -- determine the system IGS_PS_UNIT mode of the IGS_PS_UNIT

Line 2833: unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,

2829: -- comment.
2830: DECLARE
2831: -- table to hold old units
2832: TYPE r_units_typ IS RECORD (
2833: unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
2834: sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,

Line 2834: sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,

2830: DECLARE
2831: -- table to hold old units
2832: TYPE r_units_typ IS RECORD (
2833: unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
2834: sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,

Line 2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,

2831: -- table to hold old units
2832: TYPE r_units_typ IS RECORD (
2833: unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
2834: sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,

Line 2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,

2832: TYPE r_units_typ IS RECORD (
2833: unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
2834: sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,
2840: industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,

Line 2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,

2833: unit_cd IGS_ST_GVT_STDNTLOAD.unit_cd%TYPE,
2834: sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,
2840: industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
2841: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE);

Line 2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,

2834: sua_cal_type IGS_ST_GVT_STDNTLOAD.sua_cal_type%TYPE,
2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,
2840: industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
2841: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE);
2842: r_units r_units_typ;

Line 2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,

2835: sua_ci_sequence_number IGS_ST_GVT_STDNTLOAD.sua_ci_sequence_number%TYPE,
2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,
2840: industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
2841: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE);
2842: r_units r_units_typ;
2843: TYPE t_units_typ IS TABLE OF r_units%TYPE

Line 2840: industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,

2836: tr_org_unit_cd IGS_ST_GVT_STDNTLOAD.tr_org_unit_cd%TYPE,
2837: tr_ou_start_dt IGS_ST_GVT_STDNTLOAD.tr_ou_start_dt%TYPE,
2838: govt_discipline_group_cd IGS_ST_GVT_STDNTLOAD.govt_discipline_group_cd%TYPE,
2839: eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE,
2840: industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE,
2841: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE);
2842: r_units r_units_typ;
2843: TYPE t_units_typ IS TABLE OF r_units%TYPE
2844: INDEX BY BINARY_INTEGER;

Line 2969: cp_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,

2965: scho.end_dt IS NOT NULL -- AND
2966: -- scho.end_dt > cp_effective_dt
2967: ORDER BY scho.end_dt DESC;
2968: CURSOR c_gslo (
2969: cp_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
2970: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
2971: cp_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE) IS
2972: SELECT gslo.unit_cd,
2973: gslo.sua_cal_type,

Line 2970: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,

2966: -- scho.end_dt > cp_effective_dt
2967: ORDER BY scho.end_dt DESC;
2968: CURSOR c_gslo (
2969: cp_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
2970: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
2971: cp_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE) IS
2972: SELECT gslo.unit_cd,
2973: gslo.sua_cal_type,
2974: gslo.sua_ci_sequence_number,

Line 2971: cp_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE) IS

2967: ORDER BY scho.end_dt DESC;
2968: CURSOR c_gslo (
2969: cp_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE,
2970: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,
2971: cp_course_cd IGS_ST_GVT_STDNTLOAD.course_cd%TYPE) IS
2972: SELECT gslo.unit_cd,
2973: gslo.sua_cal_type,
2974: gslo.sua_ci_sequence_number,
2975: gslo.tr_org_unit_cd,

Line 2981: FROM IGS_ST_GVT_STDNTLOAD gslo,

2977: gslo.govt_discipline_group_cd,
2978: gslo.eftsu,
2979: gslo.industrial_ind,
2980: uoo.uoo_id
2981: FROM IGS_ST_GVT_STDNTLOAD gslo,
2982: igs_ps_unit_ofr_opt uoo
2983: WHERE gslo.submission_yr = p_submission_yr AND
2984: gslo.submission_number = p_submission_number AND
2985: gslo.govt_semester = cp_govt_semester AND