APPS.IGS_EN_LGCY_PRC dependencies on IGS_AS_LGCY_SUO_INT

Line 2764: FROM igs_as_lgcy_suo_int

2760: p_deletion_flag IN BOOLEAN
2761: ) AS
2762: CURSOR c_as_uotcm IS
2763: SELECT *
2764: FROM igs_as_lgcy_suo_int
2765: WHERE batch_id = p_batch_id
2766: AND import_status IN ('U','R')
2767: FOR UPDATE NOWAIT;
2768:

Line 2881: DELETE FROM igs_as_lgcy_suo_int

2877: p_int_table_code => g_cst_as_uotcm,
2878: p_int_table_id => l_as_uotcm_cur_rec.legacy_suao_int_id
2879: );
2880: -- delete the interface record
2881: DELETE FROM igs_as_lgcy_suo_int
2882: WHERE legacy_suao_int_id = l_as_uotcm_cur_rec.legacy_suao_int_id;
2883: ELSE
2884: l_last_updated_by := get_last_updated_by;
2885: l_last_update_date := get_last_update_date;

Line 2891: UPDATE igs_as_lgcy_suo_int

2887: l_request_id := get_request_id;
2888: l_program_application_id := get_program_application_id;
2889: l_program_id := get_program_id;
2890: l_program_update_date := get_program_update_date;
2891: UPDATE igs_as_lgcy_suo_int
2892: SET import_status = DECODE(l_return_status,
2893: 'S','I',
2894: 'U','E',
2895: 'W','W',