APPS.IGS_EN_GEN_012 dependencies on IGS_EN_STDNTPSHECSOP

Line 3756: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE) IS

3752: RETURN BOOLEAN AS
3753: BEGIN
3754: DECLARE
3755: CURSOR c_scho(
3756: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE) IS
3757: SELECT scho.tax_file_number
3758: FROM IGS_EN_STDNTPSHECSOP scho
3759: WHERE scho.person_id = cp_person_id AND
3760: scho.tax_file_number IS NOT NULL AND

Line 3758: FROM IGS_EN_STDNTPSHECSOP scho

3754: DECLARE
3755: CURSOR c_scho(
3756: cp_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE) IS
3757: SELECT scho.tax_file_number
3758: FROM IGS_EN_STDNTPSHECSOP scho
3759: WHERE scho.person_id = cp_person_id AND
3760: scho.tax_file_number IS NOT NULL AND
3761: scho.tax_file_invalid_dt IS NULL
3762: ORDER BY scho.start_dt DESC;

Line 3763: v_tax_file_number IGS_EN_STDNTPSHECSOP.tax_file_number%TYPE;

3759: WHERE scho.person_id = cp_person_id AND
3760: scho.tax_file_number IS NOT NULL AND
3761: scho.tax_file_invalid_dt IS NULL
3762: ORDER BY scho.start_dt DESC;
3763: v_tax_file_number IGS_EN_STDNTPSHECSOP.tax_file_number%TYPE;
3764: v_scho_rec_found BOOLEAN;
3765: v_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE;
3766:
3767: BEGIN

Line 3765: v_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE;

3761: scho.tax_file_invalid_dt IS NULL
3762: ORDER BY scho.start_dt DESC;
3763: v_tax_file_number IGS_EN_STDNTPSHECSOP.tax_file_number%TYPE;
3764: v_scho_rec_found BOOLEAN;
3765: v_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE;
3766:
3767: BEGIN
3768: -- Update IGS_EN_STDNTPSHECSOP.tax_file_number.
3769: p_message_name := NULL;

Line 3768: -- Update IGS_EN_STDNTPSHECSOP.tax_file_number.

3764: v_scho_rec_found BOOLEAN;
3765: v_person_id IGS_EN_STDNTPSHECSOP.person_id%TYPE;
3766:
3767: BEGIN
3768: -- Update IGS_EN_STDNTPSHECSOP.tax_file_number.
3769: p_message_name := NULL;
3770: v_scho_rec_found := FALSE;
3771: -- If the Tax File Number is set to 999999999 then a default value
3772: -- must be determined

Line 3795: FROM IGS_EN_STDNTPSHECSOP scho

3791:
3792: CURSOR c_hecs_opt IS
3793: SELECT scho.ROWID,
3794: scho.*
3795: FROM IGS_EN_STDNTPSHECSOP scho
3796: WHERE scho.person_id = p_person_id AND
3797: scho.course_cd = p_course_cd AND
3798: scho.start_dt = p_start_dt
3799: FOR UPDATE NOWAIT;

Line 3808: Igs_En_Stdntpshecsop_Pkg.UPDATE_ROW(

3804: FOR c_hecs_opt_rec IN c_hecs_opt LOOP
3805:
3806: -- update IGS_PE_PERSON's tax file number
3807:
3808: Igs_En_Stdntpshecsop_Pkg.UPDATE_ROW(
3809: X_ROWID => c_hecs_opt_rec.ROWID,
3810: X_PERSON_ID => c_hecs_opt_rec.PERSON_ID,
3811: X_COURSE_CD => c_hecs_opt_rec.COURSE_CD,
3812: X_START_DT => c_hecs_opt_rec.START_DT,