APPS.IGS_DA_TRNS_IMP dependencies on IGS_AD_TERM_UNITDTLS_PKG

Line 517: igs_ad_term_unitdtls_pkg.delete_row (l_term_unit.ROWID);

513: -- delete advanced standing information
514: igs_av_stnd_unit_pkg.delete_row (l_adv_stnd_unt.ROWID);
515: END LOOP;
516:
517: igs_ad_term_unitdtls_pkg.delete_row (l_term_unit.ROWID);
518: END LOOP;
519:
520: igs_ad_term_details_pkg.delete_row (l_trans_term.ROWID);
521: END LOOP;

Line 842: igs_ad_term_unitdtls_pkg.update_row (x_rowid => dup_cur_rec.ROWID,

838: SAVEPOINT before_update_unit;
839:
840: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
841: THEN
842: igs_ad_term_unitdtls_pkg.update_row (x_rowid => dup_cur_rec.ROWID,
843: x_unit_details_id => dup_cur_rec.unit_details_id,
844: x_term_details_id => dup_cur_rec.term_details_id,
845: x_unit => p_term_unitdtls_record.unit,
846: x_unit_difficulty => dup_cur_rec.unit_difficulty,

Line 856: write_log ( 'igs_ad_term_unitdtls_pkg.update_row unit_details_id='

852: );
853: END IF;
854:
855: p_term_unitdtls_record.unit_details_id := dup_cur_rec.unit_details_id;
856: write_log ( 'igs_ad_term_unitdtls_pkg.update_row unit_details_id='
857: || p_term_unitdtls_record.unit_details_id,
858: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
859: );
860: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');

Line 935: write_log ('Before igs_ad_term_unitdtls_pkg.insert_row',

931: SAVEPOINT before_create_unit;
932:
933: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
934: THEN
935: write_log ('Before igs_ad_term_unitdtls_pkg.insert_row',
936: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
937: );
938: OPEN c_unit_difficulty;
939: FETCH c_unit_difficulty INTO l_unit_difficulty;

Line 941: write_message ('***** IGS_AD_TERM_UNITDTLS_PKG.INSERT_ROW *****');

937: );
938: OPEN c_unit_difficulty;
939: FETCH c_unit_difficulty INTO l_unit_difficulty;
940: CLOSE c_unit_difficulty;
941: write_message ('***** IGS_AD_TERM_UNITDTLS_PKG.INSERT_ROW *****');
942: igs_ad_term_unitdtls_pkg.insert_row (l_rowid,
943: l_unit_details_id,
944: p_term_unitdtls_record.term_details_id,
945: p_term_unitdtls_record.unit,

Line 942: igs_ad_term_unitdtls_pkg.insert_row (l_rowid,

938: OPEN c_unit_difficulty;
939: FETCH c_unit_difficulty INTO l_unit_difficulty;
940: CLOSE c_unit_difficulty;
941: write_message ('***** IGS_AD_TERM_UNITDTLS_PKG.INSERT_ROW *****');
942: igs_ad_term_unitdtls_pkg.insert_row (l_rowid,
943: l_unit_details_id,
944: p_term_unitdtls_record.term_details_id,
945: p_term_unitdtls_record.unit,
946: l_unit_difficulty,

Line 955: write_log ( 'After igs_ad_term_unitdtls_pkg.insert_row l_unit_details_id='

951: p_term_unitdtls_record.unit_grade_points
952: );
953: END IF;
954:
955: write_log ( 'After igs_ad_term_unitdtls_pkg.insert_row l_unit_details_id='
956: || l_unit_details_id,
957: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
958: );
959: p_term_unitdtls_record.unit_details_id := l_unit_details_id;