APPS.IGS_EN_LGCY_PRC dependencies on IGS_AV_LGCY_UNT_INT

Line 2588: FROM igs_av_lgcy_unt_int

2584: p_deletion_flag IN BOOLEAN
2585: ) AS
2586: CURSOR c_av_untstd IS
2587: SELECT *
2588: FROM igs_av_lgcy_unt_int
2589: WHERE batch_id = p_batch_id
2590: AND import_status IN ('U','R')
2591: FOR UPDATE NOWAIT;
2592:

Line 2706: DELETE FROM igs_av_lgcy_unt_int

2702: p_int_table_code => g_cst_av_untstd,
2703: p_int_table_id => l_av_untstd_cur_rec.legacy_unt_int_id
2704: );
2705: -- delete the interface record
2706: DELETE FROM igs_av_lgcy_unt_int
2707: WHERE legacy_unt_int_id = l_av_untstd_cur_rec.legacy_unt_int_id;
2708: ELSE
2709: l_last_updated_by := get_last_updated_by;
2710: l_last_update_date := get_last_update_date;

Line 2716: UPDATE igs_av_lgcy_unt_int

2712: l_request_id := get_request_id;
2713: l_program_application_id := get_program_application_id;
2714: l_program_id := get_program_id;
2715: l_program_update_date := get_program_update_date;
2716: UPDATE igs_av_lgcy_unt_int
2717: SET import_status = DECODE(l_return_status,
2718: 'S','I',
2719: 'U','E',
2720: 'W','W',