APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_EN_SPA_TERMS_PKG

Line 507: IGS_EN_SPA_TERMS_PKG.insert_row(

503: -- call table handler to insert new term record details
504: l_term_record_id := NULL;
505: l_rowid := NULL;
506:
507: IGS_EN_SPA_TERMS_PKG.insert_row(
508: x_rowid => l_rowid,
509: x_term_record_id => l_term_record_id,
510: x_person_id => p_term_rec.person_id,
511: x_program_cd => p_term_rec.program_cd,

Line 591: IGS_EN_SPA_TERMS_PKG.update_row(

587: -- term record details exist and will be updated
588: -- call table handler to update term record details
589:
590:
591: IGS_EN_SPA_TERMS_PKG.update_row(
592: x_rowid => vc_cur_spat_rec.rowid,
593: x_term_record_id => p_term_rec.term_record_id,
594: x_person_id => p_term_rec.person_id,
595: x_program_cd => p_term_rec.program_cd,

Line 1377: IGS_EN_SPA_TERMS_PKG.update_row(

1373: l_term_rec := p_term_rec;
1374: -- Reset all future key term records as Non-Key
1375: FOR rec_future_key_terms IN c_future_key_terms LOOP
1376:
1377: IGS_EN_SPA_TERMS_PKG.update_row(
1378: x_rowid => rec_future_key_terms.rowid,
1379: x_term_record_id => rec_future_key_terms.term_record_id,
1380: x_person_id => rec_future_key_terms.person_id,
1381: x_program_cd => rec_future_key_terms.program_cd,

Line 1422: IGS_EN_SPA_TERMS_PKG.update_row(

1418: OPEN c_dest_term;
1419: FETCH c_dest_term INTO l_rowid, l_term_id;
1420: CLOSE c_dest_term;
1421: -- Update the destination term record as Key
1422: IGS_EN_SPA_TERMS_PKG.update_row(
1423: x_rowid => l_rowid,
1424: x_term_record_id => l_term_id,
1425: x_person_id => l_term_rec.person_id,
1426: x_program_cd => l_term_rec.program_cd,

Line 1466: IGS_EN_SPA_TERMS_PKG.update_row(

1462: FOR rec_dest_fut_terms IN c_dest_fut_terms LOOP
1463:
1464: -- Set all destination future terms as Key terms.
1465:
1466: IGS_EN_SPA_TERMS_PKG.update_row(
1467: x_rowid => rec_dest_fut_terms.rowid,
1468: x_term_record_id => rec_dest_fut_terms.term_record_id,
1469: x_person_id => rec_dest_fut_terms.person_id,
1470: x_program_cd => rec_dest_fut_terms.program_cd,

Line 2110: igs_en_spa_terms_pkg.delete_row(rec_future_terms.rowid);

2106: p_v_status => l_fee_assessed,
2107: p_v_message => l_message);
2108: IF l_fee_assessed = 'N' THEN
2109: --
2110: igs_en_spa_terms_pkg.delete_row(rec_future_terms.rowid);
2111: END IF;
2112:
2113:
2114: END LOOP;