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_SPSHT_CHG

Line 2911: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,

2907: daiv.ci_sequence_number = cp_sua_ci_sequence_number AND
2908: daiv.dt_alias = sgcc.census_dt_alias
2909: ORDER BY daiv.alias_val;
2910: CURSOR c_gsc1 (
2911: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
2912: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,
2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,

Line 2912: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,

2908: daiv.dt_alias = sgcc.census_dt_alias
2909: ORDER BY daiv.alias_val;
2910: CURSOR c_gsc1 (
2911: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
2912: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,
2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,
2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,

Line 2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,

2909: ORDER BY daiv.alias_val;
2910: CURSOR c_gsc1 (
2911: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
2912: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,
2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,
2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,
2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,

Line 2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,

2910: CURSOR c_gsc1 (
2911: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
2912: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,
2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,
2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,
2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,
2918: cp_old_differential_hecs_ind

Line 2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,

2911: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
2912: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,
2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,
2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,
2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,
2918: cp_old_differential_hecs_ind
2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,

Line 2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,

2912: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,
2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,
2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,
2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,
2918: cp_old_differential_hecs_ind
2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,
2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,

Line 2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,

2913: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
2914: cp_govt_semester IGS_ST_GVT_SPSHT_CHG.govt_semester%TYPE,
2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,
2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,
2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,
2918: cp_old_differential_hecs_ind
2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,
2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,
2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,

Line 2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,

2915: cp_old_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.old_hecs_prexmt_exie%TYPE,
2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,
2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,
2918: cp_old_differential_hecs_ind
2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,
2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,
2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,
2922: cp_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.hecs_payment_option%TYPE,
2923: cp_differential_hecs_ind IGS_ST_GVT_SPSHT_CHG.differential_hecs_ind%TYPE) IS

Line 2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,

2916: cp_old_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.old_hecs_amount_paid%TYPE,
2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,
2918: cp_old_differential_hecs_ind
2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,
2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,
2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,
2922: cp_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.hecs_payment_option%TYPE,
2923: cp_differential_hecs_ind IGS_ST_GVT_SPSHT_CHG.differential_hecs_ind%TYPE) IS
2924: SELECT 'x'

Line 2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,

2917: cp_old_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.old_hecs_payment_option%TYPE,
2918: cp_old_differential_hecs_ind
2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,
2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,
2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,
2922: cp_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.hecs_payment_option%TYPE,
2923: cp_differential_hecs_ind IGS_ST_GVT_SPSHT_CHG.differential_hecs_ind%TYPE) IS
2924: SELECT 'x'
2925: FROM IGS_ST_GVT_SPSHT_CHG gsc

Line 2922: cp_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.hecs_payment_option%TYPE,

2918: cp_old_differential_hecs_ind
2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,
2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,
2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,
2922: cp_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.hecs_payment_option%TYPE,
2923: cp_differential_hecs_ind IGS_ST_GVT_SPSHT_CHG.differential_hecs_ind%TYPE) IS
2924: SELECT 'x'
2925: FROM IGS_ST_GVT_SPSHT_CHG gsc
2926: WHERE gsc.submission_yr = p_submission_yr AND

Line 2923: cp_differential_hecs_ind IGS_ST_GVT_SPSHT_CHG.differential_hecs_ind%TYPE) IS

2919: IGS_ST_GVT_SPSHT_CHG.old_differential_hecs_ind%TYPE,
2920: cp_hecs_amount_paid IGS_ST_GVT_SPSHT_CHG.hecs_amount_paid%TYPE,
2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,
2922: cp_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.hecs_payment_option%TYPE,
2923: cp_differential_hecs_ind IGS_ST_GVT_SPSHT_CHG.differential_hecs_ind%TYPE) IS
2924: SELECT 'x'
2925: FROM IGS_ST_GVT_SPSHT_CHG gsc
2926: WHERE gsc.submission_yr = p_submission_yr AND
2927: gsc.submission_number = p_submission_number AND

Line 2925: FROM IGS_ST_GVT_SPSHT_CHG gsc

2921: cp_hecs_prexmt_exie IGS_ST_GVT_SPSHT_CHG.hecs_prexmt_exie%TYPE,
2922: cp_hecs_payment_option IGS_ST_GVT_SPSHT_CHG.hecs_payment_option%TYPE,
2923: cp_differential_hecs_ind IGS_ST_GVT_SPSHT_CHG.differential_hecs_ind%TYPE) IS
2924: SELECT 'x'
2925: FROM IGS_ST_GVT_SPSHT_CHG gsc
2926: WHERE gsc.submission_yr = p_submission_yr AND
2927: gsc.submission_number = p_submission_number AND
2928: gsc.person_id = cp_person_id AND
2929: gsc.course_cd = cp_course_cd AND

Line 3112: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,

3108: (ps.end_dt IS NULL OR
3109: ps.end_dt >= cp_effective_dt)
3110: ORDER BY ps.end_dt;
3111: CURSOR c_gsc2 (
3112: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
3113: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,

Line 3113: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,

3109: ps.end_dt >= cp_effective_dt)
3110: ORDER BY ps.end_dt;
3111: CURSOR c_gsc2 (
3112: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
3113: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,

Line 3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,

3110: ORDER BY ps.end_dt;
3111: CURSOR c_gsc2 (
3112: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
3113: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,

Line 3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,

3111: CURSOR c_gsc2 (
3112: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
3113: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,

Line 3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,

3112: cp_person_id IGS_ST_GVT_SPSHT_CHG.person_id%TYPE,
3113: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,
3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,

Line 3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,

3113: cp_course_cd IGS_ST_GVT_SPSHT_CHG.course_cd%TYPE,
3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,
3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,
3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,

Line 3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,

3114: cp_crv_version_number IGS_ST_GVT_SPSHT_CHG.version_number%TYPE,
3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,
3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,
3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,
3122: cp_prior_post_grad IGS_ST_GVT_SPSHT_CHG.prior_post_grad%TYPE) IS

Line 3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,

3115: cp_old_citizenship_cd IGS_ST_GVT_SPSHT_CHG.old_citizenship_cd%TYPE,
3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,
3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,
3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,
3122: cp_prior_post_grad IGS_ST_GVT_SPSHT_CHG.prior_post_grad%TYPE) IS
3123: SELECT 'x'

Line 3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,

3116: cp_old_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.old_perm_resident_cd%TYPE,
3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,
3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,
3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,
3122: cp_prior_post_grad IGS_ST_GVT_SPSHT_CHG.prior_post_grad%TYPE) IS
3123: SELECT 'x'
3124: FROM IGS_ST_GVT_SPSHT_CHG gsc

Line 3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,

3117: cp_old_prior_degree IGS_ST_GVT_SPSHT_CHG.old_prior_degree%TYPE,
3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,
3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,
3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,
3122: cp_prior_post_grad IGS_ST_GVT_SPSHT_CHG.prior_post_grad%TYPE) IS
3123: SELECT 'x'
3124: FROM IGS_ST_GVT_SPSHT_CHG gsc
3125: WHERE gsc.submission_yr = p_submission_yr AND

Line 3122: cp_prior_post_grad IGS_ST_GVT_SPSHT_CHG.prior_post_grad%TYPE) IS

3118: cp_old_prior_post_grad IGS_ST_GVT_SPSHT_CHG.old_prior_post_grad%TYPE,
3119: cp_perm_resident_cd IGS_ST_GVT_SPSHT_CHG.perm_resident_cd%TYPE,
3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,
3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,
3122: cp_prior_post_grad IGS_ST_GVT_SPSHT_CHG.prior_post_grad%TYPE) IS
3123: SELECT 'x'
3124: FROM IGS_ST_GVT_SPSHT_CHG gsc
3125: WHERE gsc.submission_yr = p_submission_yr AND
3126: gsc.submission_number = p_submission_number AND

Line 3124: FROM IGS_ST_GVT_SPSHT_CHG gsc

3120: cp_citizenship_cd IGS_ST_GVT_SPSHT_CHG.citizenship_cd%TYPE,
3121: cp_prior_degree IGS_ST_GVT_SPSHT_CHG.prior_degree%TYPE,
3122: cp_prior_post_grad IGS_ST_GVT_SPSHT_CHG.prior_post_grad%TYPE) IS
3123: SELECT 'x'
3124: FROM IGS_ST_GVT_SPSHT_CHG gsc
3125: WHERE gsc.submission_yr = p_submission_yr AND
3126: gsc.submission_number = p_submission_number AND
3127: gsc.person_id = cp_person_id AND
3128: gsc.course_cd = cp_course_cd AND

Line 3217: v_seqnum IGS_ST_GVT_SPSHT_CHG.sequence_number%type;

3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3214: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3215: -- declaration for rowid and the sequence number variable
3216: v_rowid VARCHAR2(25);
3217: v_seqnum IGS_ST_GVT_SPSHT_CHG.sequence_number%type;
3218: BEGIN
3219: -- find the most recent run of the enrolment statistics snapshot
3220: OPEN c_ess;
3221: FETCH c_ess INTO v_snapshot_dt_time;

Line 3533: IGS_ST_GVT_SPSHT_CHG_PKG.INSERT_ROW(

3529: -- Insert changed details in table
3530:
3531: -- to insert row using the insertrow of respective TBH package
3532:
3533: IGS_ST_GVT_SPSHT_CHG_PKG.INSERT_ROW(
3534: X_ROWID => v_rowid,
3535: X_SUBMISSION_YR => p_submission_yr,
3536: X_SUBMISSION_NUMBER => p_submission_number,
3537: X_PERSON_ID => v_person_id,

Line 3663: IGS_ST_GVT_SPSHT_CHG_PKG.INSERT_ROW(

3659: -- Insert changed details in table
3660:
3661: -- to insert row using the insertrow of respective TBH package
3662:
3663: IGS_ST_GVT_SPSHT_CHG_PKG.INSERT_ROW(
3664: X_ROWID => v_rowid,
3665: X_SUBMISSION_YR => p_submission_yr,
3666: X_SUBMISSION_NUMBER => p_submission_number,
3667: X_PERSON_ID => v_person_id,