APPS.IGS_EN_LGCY_PRC dependencies on IGS_PR_LGCY_SPO_INT

Line 2939: FROM igs_pr_lgcy_spo_int

2935: p_deletion_flag IN BOOLEAN
2936: ) AS
2937: CURSOR c_pr_out IS
2938: SELECT *
2939: FROM igs_pr_lgcy_spo_int
2940: WHERE batch_id = p_batch_id
2941: AND import_status IN ('U','R')
2942: FOR UPDATE NOWAIT;
2943:

Line 3047: DELETE FROM igs_pr_lgcy_spo_int

3043: p_int_table_code => g_cst_pr_out,
3044: p_int_table_id => l_pr_out_cur_rec.legacy_pr_spo_int_id
3045: );
3046: -- delete the interface record
3047: DELETE FROM igs_pr_lgcy_spo_int
3048: WHERE legacy_pr_spo_int_id = l_pr_out_cur_rec.legacy_pr_spo_int_id;
3049: ELSE
3050: l_last_updated_by := get_last_updated_by;
3051: l_last_update_date := get_last_update_date;

Line 3057: UPDATE igs_pr_lgcy_spo_int

3053: l_request_id := get_request_id;
3054: l_program_application_id := get_program_application_id;
3055: l_program_id := get_program_id;
3056: l_program_update_date := get_program_update_date;
3057: UPDATE igs_pr_lgcy_spo_int
3058: SET import_status = DECODE(l_return_status,
3059: 'S','I',
3060: 'U','E',
3061: 'W','W',