APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_LGCY_SPA_INT

Line 629: FROM igs_en_lgcy_spa_int

625: || which bybass the rollback if return status is 'W', w.r.t. bug no :2717455
626: ------------------------------------------------------------------------------*/
627: CURSOR c_en_spa IS
628: SELECT *
629: FROM igs_en_lgcy_spa_int
630: WHERE batch_id = p_batch_id
631: AND import_status IN ('U','R')
632: ORDER BY person_number ASC,
633: NVL(key_program,'N') DESC,

Line 790: DELETE FROM igs_en_lgcy_spa_int

786: p_int_table_code => g_cst_en_spa,
787: p_int_table_id => l_en_spa_cur_rec.legacy_en_spa_int_id
788: );
789: -- delete the interface record
790: DELETE FROM igs_en_lgcy_spa_int
791: WHERE legacy_en_spa_int_id = l_en_spa_cur_rec.legacy_en_spa_int_id;
792: ELSE
793: l_last_updated_by := get_last_updated_by;
794: l_last_update_date := get_last_update_date;

Line 800: UPDATE igs_en_lgcy_spa_int

796: l_request_id := get_request_id;
797: l_program_application_id := get_program_application_id;
798: l_program_id := get_program_id;
799: l_program_update_date := get_program_update_date;
800: UPDATE igs_en_lgcy_spa_int
801: SET import_status = DECODE(l_return_status,
802: 'S','I',
803: 'U','E',
804: 'W','W',