APPS.IGF_AW_LI_IMPORT dependencies on IGF_AW_DB_CHG_DTLS

Line 1104: FROM igf_aw_db_chg_dtls

1100: WHERE auth_id = cp_auth_id;
1101:
1102: CURSOR c_get_disb_chg_dtls_row (p_award_id igf_aw_award_all.award_id%TYPE) IS
1103: SELECT ROWID row_id
1104: FROM igf_aw_db_chg_dtls
1105: WHERE award_id = p_award_id;
1106:
1107: CURSOR c_get_cod_dtl_row (p_award_id igf_aw_award_all.award_id%TYPE) IS
1108: SELECT ROWID row_id

Line 1156: -- while deleting the record in IGF_AW_AWD_DISB_ALL delete also from IGF_AW_DB_CHG_DTLS

1152: END LOOP;
1153: CLOSE c_get_awd_hist_details;
1154: -- bvisvana - Bug # 4635941 - END
1155:
1156: -- while deleting the record in IGF_AW_AWD_DISB_ALL delete also from IGF_AW_DB_CHG_DTLS
1157:
1158: FOR c_get_disb_dtl_row_rec IN c_get_disb_dtl_row LOOP
1159: igf_db_awd_disb_dtl_pkg.delete_row(c_get_disb_dtl_row_rec.row_id);
1160: END LOOP;

Line 1167: igf_aw_db_chg_dtls_pkg.delete_row(c_get_disb_chg_dtls_row_rec.row_id);

1163: igf_aw_db_cod_dtls_pkg.delete_row(c_get_cod_dtl_row_rec.row_id);
1164: END LOOP;
1165:
1166: FOR c_get_disb_chg_dtls_row_rec IN c_get_disb_chg_dtls_row(p_award_id) LOOP
1167: igf_aw_db_chg_dtls_pkg.delete_row(c_get_disb_chg_dtls_row_rec.row_id);
1168: END LOOP;
1169:
1170: FOR c_get_disb_holds_row_rec IN c_get_disb_holds_row LOOP
1171: igf_db_disb_holds_pkg.delete_row(c_get_disb_holds_row_rec.row_id);

Line 2506: are taken into account and data is inseted into IGF_AW_DB_CHG_DTLS table also

2502: Change History :
2503: Who When What
2504: pssahni 10/20/2004 The newly added fields in the table IGF_AW_LI_DACT_INTS and table IGF_DB_AWD_DISB_DTL.
2505: (ORIG_FEE_AMT, GUARNT_FEE_AMT, ORIG_FEE_PAID_AMT, GUARNT_FEE_PAID_AMT, INT_REBATE_AMT)
2506: are taken into account and data is inseted into IGF_AW_DB_CHG_DTLS table also
2507: Validation is done to check that the last activity always reflect the current disbursement information.
2508:
2509: ***************************************************************/
2510: CURSOR cur_li_disb_act_int IS

Line 2623: FROM igf_aw_db_chg_dtls

2619:
2620: CURSOR cur_rowid ( p_award_id NUMBER, p_disb_num NUMBER, p_disb_seq_num NUMBER)
2621: IS
2622: SELECT ROWID row_id
2623: FROM igf_aw_db_chg_dtls
2624: WHERE award_id = p_award_id
2625: AND disb_num = p_disb_num
2626: AND disb_seq_num = p_disb_seq_num;
2627: lv_rowid cur_rowid%ROWTYPE;

Line 3057: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_aw_db_chg_dtls table');

3053: RETURN;
3054: END IF;
3055:
3056: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3057: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_aw_db_chg_dtls table');
3058: END IF;
3059: -- insert into IGF_AW_DB_CHG_DTLS table also
3060:
3061: -- First delete the record in the table if present

Line 3059: -- insert into IGF_AW_DB_CHG_DTLS table also

3055:
3056: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3057: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_aw_db_chg_dtls table');
3058: END IF;
3059: -- insert into IGF_AW_DB_CHG_DTLS table also
3060:
3061: -- First delete the record in the table if present
3062: OPEN cur_rowid (g_award_id, li_awd_disb_rec.disbursement_num, cur_li_disb_act_int_rec.disb_activity_num);
3063: FETCH cur_rowid INTO lv_rowid;

Line 3067: igf_aw_db_chg_dtls_pkg.delete_row(lv_rowid.row_id);

3063: FETCH cur_rowid INTO lv_rowid;
3064:
3065: IF cur_rowid%FOUND THEN
3066: CLOSE cur_rowid;
3067: igf_aw_db_chg_dtls_pkg.delete_row(lv_rowid.row_id);
3068: ELSE
3069: CLOSE cur_rowid;
3070: END IF;
3071:

Line 3074: igf_aw_db_chg_dtls_pkg.insert_row (

3070: END IF;
3071:
3072:
3073: l_rowid := NULL;
3074: igf_aw_db_chg_dtls_pkg.insert_row (
3075: x_rowid => l_rowid,
3076: x_award_id => g_award_id,
3077: x_disb_num => li_awd_disb_rec.disbursement_num,
3078: x_disb_seq_num => cur_li_disb_act_int_rec.disb_activity_num,