APPS.IGS_EN_LGCY_PRC dependencies on IGS_PR_LGY_CLSR_INT

Line 3103: FROM igs_pr_lgy_clsr_int

3099: p_deletion_flag IN BOOLEAN
3100: ) AS
3101: CURSOR c_pr_cr IS
3102: SELECT *
3103: FROM igs_pr_lgy_clsr_int
3104: WHERE batch_id = p_batch_id
3105: AND import_status IN ('U','R')
3106: FOR UPDATE NOWAIT;
3107:

Line 3188: DELETE FROM igs_pr_lgy_clsr_int

3184: p_int_table_code => g_cst_pr_cr,
3185: p_int_table_id => l_pr_cr_cur_rec.legacy_cls_rank_int_id
3186: );
3187: -- delete the interface record
3188: DELETE FROM igs_pr_lgy_clsr_int
3189: WHERE legacy_cls_rank_int_id = l_pr_cr_cur_rec.legacy_cls_rank_int_id;
3190: ELSE
3191: l_last_updated_by := get_last_updated_by;
3192: l_last_update_date := get_last_update_date;

Line 3198: UPDATE igs_pr_lgy_clsr_int

3194: l_request_id := get_request_id;
3195: l_program_application_id := get_program_application_id;
3196: l_program_id := get_program_id;
3197: l_program_update_date := get_program_update_date;
3198: UPDATE igs_pr_lgy_clsr_int
3199: SET import_status = DECODE(l_return_status,
3200: 'S','I',
3201: 'U','E',
3202: 'W','W',