APPS.IGF_AP_LI_BASE_REC_IMPORT dependencies on IGF_AP_LI_FAB_INTS

Line 101: CURSOR c_get_records(cp_alternate_code igf_ap_li_fab_ints.ci_alternate_code%TYPE,

97: AND sequence_number = cp_seq_number;
98:
99: l_get_alternate_code c_get_alternate_code%ROWTYPE;
100:
101: CURSOR c_get_records(cp_alternate_code igf_ap_li_fab_ints.ci_alternate_code%TYPE,
102: cp_batch_id igf_ap_li_fab_ints.batch_num%TYPE)
103: IS
104: SELECT batch_num,
105: award_process_status_code,

Line 102: cp_batch_id igf_ap_li_fab_ints.batch_num%TYPE)

98:
99: l_get_alternate_code c_get_alternate_code%ROWTYPE;
100:
101: CURSOR c_get_records(cp_alternate_code igf_ap_li_fab_ints.ci_alternate_code%TYPE,
102: cp_batch_id igf_ap_li_fab_ints.batch_num%TYPE)
103: IS
104: SELECT batch_num,
105: award_process_status_code,
106: ci_alternate_code,

Line 116: FROM igf_ap_li_fab_ints

112: professional_judgment_flag,
113: disburse_verification_hold,
114: import_status_type,
115: ROWID ROW_ID
116: FROM igf_ap_li_fab_ints
117: WHERE ci_alternate_code = cp_alternate_code
118: AND batch_num = cp_batch_id
119: AND import_status_type IN ('U','R')
120: ORDER BY person_number;

Line 796: UPDATE igf_ap_li_fab_ints

792: IF l_error_flag = TRUE THEN
793: l_error_flag := FALSE;
794: l_error_record_cnt := l_error_record_cnt + 1;
795: --update the legacy interface table column import_status to 'E'
796: UPDATE igf_ap_li_fab_ints
797: SET import_status_type = 'E',
798: last_updated_by = fnd_global.user_id,
799: last_update_date = SYSDATE,
800: last_update_login = fnd_global.login_id,

Line 811: DELETE FROM igf_ap_li_fab_ints

807: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','updating igf_ap_li_fa_ints(E) with rowid:'||l_get_records.ROW_ID);
808: END IF;
809: ELSE
810: IF p_del_ind = 'Y' THEN
811: DELETE FROM igf_ap_li_fab_ints
812: WHERE ROWID = l_get_records.ROW_ID;
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','deleting igf_ap_li_fa_ints with rowid:'||l_get_records.ROW_ID);
815: END IF;

Line 818: UPDATE igf_ap_li_fab_ints

814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_base_rec_import.main.debug','deleting igf_ap_li_fa_ints with rowid:'||l_get_records.ROW_ID);
815: END IF;
816: ELSE
817: --update the legacy interface table column import_status to 'I'
818: UPDATE igf_ap_li_fab_ints
819: SET import_status_type = 'I',
820: last_updated_by = fnd_global.user_id,
821: last_update_date = SYSDATE,
822: last_update_login = fnd_global.login_id,