APPS.IGF_GR_LI_IMPORT dependencies on IGF_AW_LI_PDB_INTS

Line 112: cp_ci_alternate_code igf_aw_li_pdb_ints.ci_alternate_code%TYPE,

108: ORDER BY ci_alternate_code, person_number, award_number_txt;
109:
110: -- Get the details of Pell Origination Interface records
111: CURSOR c_pell_disb_int(
112: cp_ci_alternate_code igf_aw_li_pdb_ints.ci_alternate_code%TYPE,
113: cp_person_number igf_aw_li_pdb_ints.person_number%TYPE,
114: cp_award_number_txt igf_aw_li_pdb_ints.award_number_txt%TYPE,
115: cp_origination_id_txt igf_aw_li_pdb_ints.origination_id_txt%TYPE
116: ) IS

Line 113: cp_person_number igf_aw_li_pdb_ints.person_number%TYPE,

109:
110: -- Get the details of Pell Origination Interface records
111: CURSOR c_pell_disb_int(
112: cp_ci_alternate_code igf_aw_li_pdb_ints.ci_alternate_code%TYPE,
113: cp_person_number igf_aw_li_pdb_ints.person_number%TYPE,
114: cp_award_number_txt igf_aw_li_pdb_ints.award_number_txt%TYPE,
115: cp_origination_id_txt igf_aw_li_pdb_ints.origination_id_txt%TYPE
116: ) IS
117: SELECT ROWID row_id,

Line 114: cp_award_number_txt igf_aw_li_pdb_ints.award_number_txt%TYPE,

110: -- Get the details of Pell Origination Interface records
111: CURSOR c_pell_disb_int(
112: cp_ci_alternate_code igf_aw_li_pdb_ints.ci_alternate_code%TYPE,
113: cp_person_number igf_aw_li_pdb_ints.person_number%TYPE,
114: cp_award_number_txt igf_aw_li_pdb_ints.award_number_txt%TYPE,
115: cp_origination_id_txt igf_aw_li_pdb_ints.origination_id_txt%TYPE
116: ) IS
117: SELECT ROWID row_id,
118: TRIM(ci_alternate_code) ci_alternate_code,

Line 115: cp_origination_id_txt igf_aw_li_pdb_ints.origination_id_txt%TYPE

111: CURSOR c_pell_disb_int(
112: cp_ci_alternate_code igf_aw_li_pdb_ints.ci_alternate_code%TYPE,
113: cp_person_number igf_aw_li_pdb_ints.person_number%TYPE,
114: cp_award_number_txt igf_aw_li_pdb_ints.award_number_txt%TYPE,
115: cp_origination_id_txt igf_aw_li_pdb_ints.origination_id_txt%TYPE
116: ) IS
117: SELECT ROWID row_id,
118: TRIM(ci_alternate_code) ci_alternate_code,
119: TRIM(person_number) person_number,

Line 136: FROM igf_aw_li_pdb_ints

132: TRIM(disburse_batch_id_txt) disburse_batch_id_txt,
133: disburse_batch_process_date disburse_batch_process_date,
134: disburse_batch_ack_date disburse_batch_ack_date,
135: TRIM(ed_use_flags) ed_use_flags
136: FROM igf_aw_li_pdb_ints
137: WHERE TRIM(ci_alternate_code) = cp_ci_alternate_code
138: AND TRIM(person_number) = cp_person_number
139: AND TRIM(award_number_txt) = cp_award_number_txt
140: AND TRIM(origination_id_txt) = cp_origination_id_txt

Line 803: UPDATE igf_aw_li_pdb_ints

799: x_rfmb_id => p_rfmb_id,
800: x_ed_use_flags => p_pell_disb_int.ed_use_flags
801: );
802:
803: UPDATE igf_aw_li_pdb_ints
804: SET last_updated_by = fnd_global.user_id,
805: last_update_date = SYSDATE,
806: last_update_login = fnd_global.login_id
807: WHERE ci_alternate_code = p_pell_disb_int.ci_alternate_code

Line 2983: DELETE igf_aw_li_pdb_ints

2979: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2980: l_debug_str := l_debug_str || ', Deleting Interface Pell Disb recs';
2981: END IF;
2982:
2983: DELETE igf_aw_li_pdb_ints
2984: WHERE ci_alternate_code = lc_pell_orig_int.ci_alternate_code
2985: AND person_number = lc_pell_orig_int.person_number
2986: AND award_number_txt = lc_pell_orig_int.award_number_txt
2987: AND origination_id_txt = lc_pell_orig_int.origination_id_txt;