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

Line 311: v_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;

307: v_basis_for_admission_type
308: IGS_ST_GOVT_STDNT_EN.basis_for_admission_type%TYPE;
309: v_govt_basis_for_adm_type
310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;
311: v_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%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;

Line 314: v_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE;

310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;
311: v_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%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;

Line 316: v_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;

312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%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;

Line 321: v_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%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;
325: v_first_flag BOOLEAN;

Line 322: v_total_eftsu IGS_ST_GVT_STDNT_LBL.total_eftsu%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;
325: v_first_flag BOOLEAN;
326: v_temp_person_id NUMBER;

Line 323: v_hecs_prexmt_exie_update IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;

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;
325: v_first_flag BOOLEAN;
326: v_temp_person_id NUMBER;
327: v_tmp_person_id NUMBER;

Line 324: v_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;

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;
325: v_first_flag BOOLEAN;
326: v_temp_person_id NUMBER;
327: v_tmp_person_id NUMBER;
328: v_flag BOOLEAN;

Line 343: v_upd_total_eftsu IGS_ST_GVT_STDNT_LBL.total_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;
344: v_upd_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%TYPE;
345: v_owner all_indexes.owner%TYPE;
346: v_command VARCHAR2(600);
347: v_command_cursor INTEGER;

Line 344: v_upd_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_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;
344: v_upd_indus_eftsu IGS_ST_GVT_STDNT_LBL.industrial_eftsu%TYPE;
345: v_owner all_indexes.owner%TYPE;
346: v_command VARCHAR2(600);
347: v_command_cursor INTEGER;
348: v_ret INTEGER;

Line 613: FROM IGS_ST_GVT_STDNT_LBL gsli

609: SUM(gslo.eftsu) DESC,
610: sca.commencement_dt ASC;
611: CURSOR c_gsli_upd IS
612: SELECT rowid, gsli.*
613: FROM IGS_ST_GVT_STDNT_LBL gsli
614: WHERE submission_yr = p_submission_yr AND
615: submission_number = p_submission_number
616: FOR UPDATE OF gsli.last_updated_by NOWAIT;
617: CURSOR c_gsli_upd2 (

Line 618: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,

614: WHERE submission_yr = p_submission_yr AND
615: submission_number = p_submission_number
616: FOR UPDATE OF gsli.last_updated_by NOWAIT;
617: CURSOR c_gsli_upd2 (
618: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
619: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
620: cp_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE) IS
621: SELECT rowid, gsli.*
622: FROM IGS_ST_GVT_STDNT_LBL gsli

Line 619: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,

615: submission_number = p_submission_number
616: FOR UPDATE OF gsli.last_updated_by NOWAIT;
617: CURSOR c_gsli_upd2 (
618: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
619: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
620: cp_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE) IS
621: SELECT rowid, gsli.*
622: FROM IGS_ST_GVT_STDNT_LBL gsli
623: WHERE gsli.submission_yr = p_submission_yr AND

Line 620: cp_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE) IS

616: FOR UPDATE OF gsli.last_updated_by NOWAIT;
617: CURSOR c_gsli_upd2 (
618: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
619: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
620: cp_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE) IS
621: SELECT rowid, gsli.*
622: FROM IGS_ST_GVT_STDNT_LBL gsli
623: WHERE gsli.submission_yr = p_submission_yr AND
624: gsli.submission_number = p_submission_number AND

Line 622: FROM IGS_ST_GVT_STDNT_LBL gsli

618: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
619: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
620: cp_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE) IS
621: SELECT rowid, gsli.*
622: FROM IGS_ST_GVT_STDNT_LBL gsli
623: WHERE gsli.submission_yr = p_submission_yr AND
624: gsli.submission_number = p_submission_number AND
625: gsli.person_id = cp_person_id AND
626: gsli.course_cd = cp_course_cd AND

Line 695: FROM IGS_ST_GVT_STDNT_LBL gsli

691: gsli.person_id,
692: gsli.course_cd,
693: gsli.version_number,
694: gsli.commencement_dt
695: FROM IGS_ST_GVT_STDNT_LBL gsli
696: WHERE gsli.submission_yr = p_submission_yr AND
697: gsli.submission_number = p_submission_number;
698: CURSOR c_gsli_upd_commencement (
699: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,

Line 699: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,

695: FROM IGS_ST_GVT_STDNT_LBL gsli
696: WHERE gsli.submission_yr = p_submission_yr AND
697: gsli.submission_number = p_submission_number;
698: CURSOR c_gsli_upd_commencement (
699: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
700: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS
701: SELECT rowid,gsli.*
702: FROM IGS_ST_GVT_STDNT_LBL gsli
703: WHERE gsli.submission_yr = p_submission_yr AND

Line 700: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS

696: WHERE gsli.submission_yr = p_submission_yr AND
697: gsli.submission_number = p_submission_number;
698: CURSOR c_gsli_upd_commencement (
699: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
700: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS
701: SELECT rowid,gsli.*
702: FROM IGS_ST_GVT_STDNT_LBL gsli
703: WHERE gsli.submission_yr = p_submission_yr AND
704: gsli.submission_number = p_submission_number AND

Line 702: FROM IGS_ST_GVT_STDNT_LBL gsli

698: CURSOR c_gsli_upd_commencement (
699: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
700: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS
701: SELECT rowid,gsli.*
702: FROM IGS_ST_GVT_STDNT_LBL gsli
703: WHERE gsli.submission_yr = p_submission_yr AND
704: gsli.submission_number = p_submission_number AND
705: gsli.person_id = cp_person_id AND
706: gsli.course_cd = cp_course_cd

Line 718: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,

714: FROM IGS_ST_GOVT_STDNT_EN gse
715: WHERE gse.submission_yr = p_submission_yr AND
716: gse.submission_number = p_submission_number;
717: CURSOR c_gse_upd_commencement (
718: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
719: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS
720: SELECT rowid,gse.*
721: FROM IGS_ST_GOVT_STDNT_EN gse
722: WHERE gse.submission_yr = p_submission_yr AND

Line 719: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS

715: WHERE gse.submission_yr = p_submission_yr AND
716: gse.submission_number = p_submission_number;
717: CURSOR c_gse_upd_commencement (
718: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
719: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS
720: SELECT rowid,gse.*
721: FROM IGS_ST_GOVT_STDNT_EN gse
722: WHERE gse.submission_yr = p_submission_yr AND
723: gse.submission_number = p_submission_number AND

Line 1065: p_sub_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE,

1061: IGS_GE_MSG_STACK.ADD;
1062: App_Exception.Raise_Exception;
1063: END stapl_get_sca_data_for_liab;
1064: PROCEDURE stapl_ins_govt_sdnt_liab_rec (
1065: p_sub_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE,
1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,
1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,

Line 1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,

1062: App_Exception.Raise_Exception;
1063: END stapl_get_sca_data_for_liab;
1064: PROCEDURE stapl_ins_govt_sdnt_liab_rec (
1065: p_sub_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE,
1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,
1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,

Line 1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,

1063: END stapl_get_sca_data_for_liab;
1064: PROCEDURE stapl_ins_govt_sdnt_liab_rec (
1065: p_sub_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE,
1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,
1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,

Line 1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,

1064: PROCEDURE stapl_ins_govt_sdnt_liab_rec (
1065: p_sub_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE,
1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,
1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,

Line 1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,

1065: p_sub_yr IGS_ST_GVT_STDNT_LBL.submission_yr%TYPE,
1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,
1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,

Line 1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,

1066: p_sub_number IGS_ST_GVT_STDNT_LBL.submission_number%TYPE,
1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,

Line 1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,

1067: p_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,

Line 1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,

1068: p_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE,
1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,

Line 1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,

1069: p_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE,
1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,

Line 1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,

1070: p_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE,
1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,

Line 1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,

1071: p_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE,
1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,

Line 1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,

1072: p_govt_hpo IGS_ST_GVT_STDNT_LBL.govt_hecs_payment_option%TYPE,
1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,

Line 1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,

1073: p_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE,
1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,
1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,

Line 1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,

1074: p_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE,
1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,
1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,
1082: p_commencement_dt IGS_ST_GVT_STDNT_LBL.commencement_dt%TYPE,

Line 1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,

1075: p_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE,
1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,
1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,
1082: p_commencement_dt IGS_ST_GVT_STDNT_LBL.commencement_dt%TYPE,
1083: p_hecs_fee IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE)

Line 1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,

1076: p_birth_dt IGS_ST_GVT_STDNT_LBL.birth_dt%TYPE,
1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,
1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,
1082: p_commencement_dt IGS_ST_GVT_STDNT_LBL.commencement_dt%TYPE,
1083: p_hecs_fee IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE)
1084: AS

Line 1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,

1077: p_sex IGS_ST_GVT_STDNT_LBL.sex%TYPE,
1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,
1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,
1082: p_commencement_dt IGS_ST_GVT_STDNT_LBL.commencement_dt%TYPE,
1083: p_hecs_fee IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE)
1084: AS
1085: gv_other_detail VARCHAR2(255);

Line 1082: p_commencement_dt IGS_ST_GVT_STDNT_LBL.commencement_dt%TYPE,

1078: p_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE,
1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,
1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,
1082: p_commencement_dt IGS_ST_GVT_STDNT_LBL.commencement_dt%TYPE,
1083: p_hecs_fee IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE)
1084: AS
1085: gv_other_detail VARCHAR2(255);
1086: BEGIN

Line 1083: p_hecs_fee IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE)

1079: p_govt_citizenship_cd IGS_ST_GVT_STDNT_LBL.govt_citizenship_cd%TYPE,
1080: p_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE,
1081: p_govt_perm_resident_cd IGS_ST_GVT_STDNT_LBL.govt_perm_resident_cd%TYPE,
1082: p_commencement_dt IGS_ST_GVT_STDNT_LBL.commencement_dt%TYPE,
1083: p_hecs_fee IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE)
1084: AS
1085: gv_other_detail VARCHAR2(255);
1086: BEGIN
1087: DECLARE

Line 1101: IGS_ST_GVT_STDNT_LBL_PKG.INSERT_ROW(

1097: BEGIN
1098:
1099: -- to insert row using the insert row of the respective TBH package
1100:
1101: IGS_ST_GVT_STDNT_LBL_PKG.INSERT_ROW(
1102: X_ROWID => v_rowid,
1103: X_SUBMISSION_YR => p_sub_yr,
1104: X_SUBMISSION_NUMBER => p_sub_number,
1105: X_PERSON_ID => p_person_id,

Line 1290: IGS_ST_GVT_STDNT_LBL_PKG.DELETE_ROW(

1286: -- records
1287: BEGIN
1288: FOR v_gsli_upd_rec IN c_gsli_upd LOOP
1289:
1290: IGS_ST_GVT_STDNT_LBL_PKG.DELETE_ROW(
1291: X_ROWID => v_gsli_upd_rec.rowid);
1292:
1293: END LOOP;
1294: EXCEPTION

Line 2466: IGS_ST_GVT_STDNT_LBL_PKG.UPDATE_ROW(

2462: v_gsli_rec.course_cd) LOOP
2463: BEGIN
2464:
2465: v_gsli_upd_comm_rec.commencement_dt := v_derived_commencement_dt;
2466: IGS_ST_GVT_STDNT_LBL_PKG.UPDATE_ROW(
2467: X_ROWID => v_gsli_upd_comm_rec.rowid,
2468: X_SUBMISSION_YR => v_gsli_upd_comm_rec.submission_yr,
2469: X_SUBMISSION_NUMBER => v_gsli_upd_comm_rec.submission_number,
2470: X_PERSON_ID => v_gsli_upd_comm_rec.person_id,

Line 2597: IGS_ST_GVT_STDNT_LBL_PKG.UPDATE_ROW(

2593: v_update_total_eftsu.govt_semester) LOOP
2594:
2595: v_gsli_upd2_rec.total_eftsu := v_update_total_eftsu.v_upd_total_eftsu;
2596:
2597: IGS_ST_GVT_STDNT_LBL_PKG.UPDATE_ROW(
2598: X_ROWID => v_gsli_upd2_rec.rowid,
2599: X_SUBMISSION_YR => v_gsli_upd2_rec.submission_yr,
2600: X_SUBMISSION_NUMBER => v_gsli_upd2_rec.submission_number,
2601: X_PERSON_ID => v_gsli_upd2_rec.person_id,

Line 2660: IGS_ST_GVT_STDNT_LBL_PKG.UPDATE_ROW(

2656: v_update_indus_eftsu.govt_semester) LOOP
2657:
2658: v_gsli_upd2_rec.industrial_eftsu := v_update_indus_eftsu.v_upd_indus_eftsu;
2659:
2660: IGS_ST_GVT_STDNT_LBL_PKG.UPDATE_ROW(
2661: X_ROWID => v_gsli_upd2_rec.rowid,
2662: X_SUBMISSION_YR => v_gsli_upd2_rec.submission_yr,
2663: X_SUBMISSION_NUMBER => v_gsli_upd2_rec.submission_number,
2664: X_PERSON_ID => v_gsli_upd2_rec.person_id,

Line 2867: FROM IGS_ST_GVT_STDNT_LBL gsli,

2863: gsli.perm_resident_cd,
2864: gslc.cal_type,
2865: gslc.ci_sequence_number,
2866: ghpo.s_hecs_payment_type
2867: FROM IGS_ST_GVT_STDNT_LBL gsli,
2868: IGS_ST_GVTSEMLOAD_CA gslc,
2869: IGS_FI_HECS_PAY_OPTN hpo,
2870: IGS_FI_GOV_HEC_PA_OP ghpo
2871: WHERE gsli.submission_yr = p_submission_yr AND

Line 3159: v_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE;

3155: -- ps.end_dt > cp_effective_dt
3156: ORDER BY ps.end_dt DESC;
3157: cst_none CONSTANT VARCHAR2(4) := 'NONE';
3158: v_snapshot_dt_time IGS_EN_ST_SPSHT_CTL.snapshot_dt_time%TYPE;
3159: v_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE;
3160: v_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE;
3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;
3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;

Line 3160: v_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE;

3156: ORDER BY ps.end_dt DESC;
3157: cst_none CONSTANT VARCHAR2(4) := 'NONE';
3158: v_snapshot_dt_time IGS_EN_ST_SPSHT_CTL.snapshot_dt_time%TYPE;
3159: v_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE;
3160: v_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE;
3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;
3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;

Line 3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;

3157: cst_none CONSTANT VARCHAR2(4) := 'NONE';
3158: v_snapshot_dt_time IGS_EN_ST_SPSHT_CTL.snapshot_dt_time%TYPE;
3159: v_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE;
3160: v_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE;
3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;
3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;
3165: v_old_hecs_amount_paid IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;

Line 3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;

3158: v_snapshot_dt_time IGS_EN_ST_SPSHT_CTL.snapshot_dt_time%TYPE;
3159: v_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE;
3160: v_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE;
3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;
3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;
3165: v_old_hecs_amount_paid IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
3166: v_old_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;

Line 3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;

3159: v_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE;
3160: v_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE;
3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;
3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;
3165: v_old_hecs_amount_paid IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
3166: v_old_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
3167: v_load_cal_type IGS_ST_GVTSEMLOAD_CA.cal_type%TYPE;

Line 3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;

3160: v_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE;
3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;
3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;
3165: v_old_hecs_amount_paid IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
3166: v_old_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
3167: v_load_cal_type IGS_ST_GVTSEMLOAD_CA.cal_type%TYPE;
3168: v_load_ci_sequence_number IGS_ST_GVTSEMLOAD_CA.ci_sequence_number%TYPE;

Line 3165: v_old_hecs_amount_paid IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;

3161: v_govt_semester IGS_ST_GVT_STDNT_LBL.govt_semester%TYPE;
3162: v_old_hecs_payment_option IGS_ST_GVT_STDNT_LBL.hecs_payment_option%TYPE;
3163: v_old_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
3164: v_old_hecs_prexmt_exie IGS_ST_GVT_STDNT_LBL.hecs_prexmt_exie%TYPE;
3165: v_old_hecs_amount_paid IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
3166: v_old_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
3167: v_load_cal_type IGS_ST_GVTSEMLOAD_CA.cal_type%TYPE;
3168: v_load_ci_sequence_number IGS_ST_GVTSEMLOAD_CA.ci_sequence_number%TYPE;
3169: v_differential_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE;

Line 3197: v_old_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE;

3193: v_last_update_date IGS_EN_STDNTPSHECSOP.last_update_date%TYPE;
3194: v_old_units_rows NUMBER;
3195: v_new_units_rows NUMBER;
3196: v_record_found BOOLEAN DEFAULT FALSE;
3197: v_old_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE;
3198: v_old_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE;
3199: v_old_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
3200: v_effective_dt DATE;
3201: v_char_date VARCHAR2(10);

Line 3198: v_old_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE;

3194: v_old_units_rows NUMBER;
3195: v_new_units_rows NUMBER;
3196: v_record_found BOOLEAN DEFAULT FALSE;
3197: v_old_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE;
3198: v_old_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE;
3199: v_old_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
3200: v_effective_dt DATE;
3201: v_char_date VARCHAR2(10);
3202: v_crv_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE;

Line 3202: v_crv_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE;

3198: v_old_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE;
3199: v_old_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
3200: v_effective_dt DATE;
3201: v_char_date VARCHAR2(10);
3202: v_crv_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE;
3203: v_govt_reportable_ind VARCHAR2(1);
3204: v_govt_discipline_group_cd
3205: IGS_EN_ST_SNAPSHOT.govt_discipline_group_cd%TYPE;
3206: v_industrial_ind IGS_PS_UNIT_VER.industrial_ind%TYPE;