APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_LGY_SPAT_INT

Line 856: SELECT * FROM igs_en_lgy_spat_int

852: ------------------------------------------------------------------------------*/
853:
854: CURSOR c_lgy_spat_int IS
855: -- cursor to pick out all records with input batch_id and status = 'ready or unprocessed'
856: SELECT * FROM igs_en_lgy_spat_int
857: WHERE
858: batch_id = p_batch_id AND
859: import_status IN ('U', 'R')
860: ORDER BY

Line 958: DELETE FROM igs_en_lgy_spat_int

954: -- delete error messages and record from spat if flag set and the process, a success
955: delete_err_messages (
956: p_int_table_code => g_cst_en_spat,
957: p_int_table_id => lc_lgy_spat_int.legacy_en_spat_int_id );
958: DELETE FROM igs_en_lgy_spat_int
959: WHERE legacy_en_spat_int_id = lc_lgy_spat_int.legacy_en_spat_int_id;
960: ELSE
961: -- get values for WHO columns
962: l_last_updated_by := get_last_updated_by;

Line 969: UPDATE igs_en_lgy_spat_int

965: l_request_id := get_request_id;
966: l_program_id := get_program_id;
967: l_program_application_id:= get_program_application_id;
968: l_program_update_date := get_program_update_date;
969: UPDATE igs_en_lgy_spat_int
970: SET import_status =
971: DECODE (l_return_status, 'S', 'I',
972: 'U', 'E',
973: 'W', 'W',