DBA Data[Home] [Help]

APPS.IGS_EN_GEN_009 dependencies on IGS_EN_SPA_AWD_AIM_PKG

Line 500: igs_en_spa_awd_aim_pkg.insert_row (

496: ELSE
497: l_end_date := NULL;
498: END IF;
499: FOR v_cur_caw IN cur_caw LOOP
500: igs_en_spa_awd_aim_pkg.insert_row (
501: x_rowid => lv_rowid,
502: x_person_id => p_person_id,
503: x_course_cd => p_course_cd,
504: x_award_cd => v_cur_caw.award_cd,

Line 520: igs_en_spa_awd_aim_pkg.update_row (

516: ELSE -- l_spaa_awd_cnt > 0
517: FOR l_spaa_awd_rec IN cur_spaa_awd LOOP
518: IF p_start_dt IS NOT NULL AND
519: p_start_dt <> l_spaa_awd_rec.start_dt THEN
520: igs_en_spa_awd_aim_pkg.update_row (
521: x_rowid => l_spaa_awd_rec.rowid,
522: x_person_id => l_spaa_awd_rec.person_id,
523: x_course_cd => l_spaa_awd_rec.course_cd,
524: x_award_cd => l_spaa_awd_rec.award_cd,