APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_HE_EN_SUSA_PKG

Line 593: igs_he_en_susa_pkg.insert_row (

589: AND v_load_record_flag = 'Y'
590: AND (v_spoi_rec.yop_grade IS NOT NULL OR v_spoi_rec.yop_mark IS NOT NULL)
591: ) THEN
592: BEGIN
593: igs_he_en_susa_pkg.insert_row (
594: x_mode => 'S',
595: x_rowid => v_he_rowid,
596: x_hesa_en_susa_id => v_hesa_en_susa_id,
597: x_person_id => v_person_id,

Line 677: igs_he_en_susa_pkg.update_row (

673: IF v_load_record_flag = 'W' THEN
674: OPEN c_susa (v_person_id, v_spoi_rec.course_cd, v_unit_set_cd, v_sequence_number, v_us_version_number);
675: FETCH c_susa INTO v_susa;
676: BEGIN
677: igs_he_en_susa_pkg.update_row (
678: x_mode => 'S',
679: x_rowid => v_susa.ROWID,
680: x_hesa_en_susa_id => v_susa.hesa_en_susa_id,
681: x_person_id => v_susa.person_id,

Line 1233: IF igs_he_en_susa_pkg.get_uk_for_validation (

1229: --
1230: -- Determine action if record already exists
1231: --
1232: BEGIN
1233: IF igs_he_en_susa_pkg.get_uk_for_validation (
1234: x_person_id => p_person_id,
1235: x_course_cd => p_course_cd,
1236: x_unit_set_cd => p_unit_set_cd,
1237: x_sequence_number => p_sequence_number