APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_EN_SPA_TERMS

Line 3362: FROM igs_en_spa_terms

3358:
3359:
3360: CURSOR c_plan_status IS
3361: SELECT plan_sht_status
3362: FROM igs_en_spa_terms
3363: WHERE person_id = p_person_id
3364: AND program_cd = p_course_cd
3365: AND term_cal_type = p_load_cal_type
3366: AND term_sequence_number = p_load_ci_seq_num

Line 3369: l_plan_sht_status igs_en_spa_terms.plan_sht_status%TYPE;

3365: AND term_cal_type = p_load_cal_type
3366: AND term_sequence_number = p_load_ci_seq_num
3367: AND plan_sht_status NOT IN ('SKIP' ,'SUB_CART' , 'NONE');
3368:
3369: l_plan_sht_status igs_en_spa_terms.plan_sht_status%TYPE;
3370:
3371: PROCEDURE L_UPD_DEL_SUA(
3372: p_person_id IN NUMBER,
3373: p_course_cd IN VARCHAR2,

Line 3727: FROM igs_en_spa_terms spa

3723: cp_c_program_cd IN VARCHAR2,
3724: cp_c_cal_type IN VARCHAR2,
3725: cp_n_seq_num IN NUMBER) IS
3726: SELECT spa.ROWID ROW_ID, spa.*
3727: FROM igs_en_spa_terms spa
3728: WHERE person_id = cp_n_person_id
3729: AND program_cd = cp_c_program_cd
3730: AND term_cal_type = cp_c_cal_type
3731: AND term_sequence_number = cp_n_seq_num;

Line 3736: igs_en_spa_terms_pkg.update_row(

3732:
3733: BEGIN
3734: FOR rec_spa_terms IN c_spa_terms(p_n_person_id, p_c_program_cd, p_c_cal_type, p_n_seq_num)
3735: LOOP
3736: igs_en_spa_terms_pkg.update_row(
3737: x_rowid =>rec_spa_terms.row_id,
3738: x_term_record_id =>rec_spa_terms.term_record_id,
3739: x_person_id =>rec_spa_terms.person_id,
3740: x_program_cd =>rec_spa_terms.program_cd,