APPS.IGF_AW_AWD_DISB_PKG dependencies on IGF_AW_DB_CHG_DTLS_PKG

Line 36: || in procedure igf_aw_db_chg_dtls_pkg.insert_row

32: || museshad 05-Jan-2006 Bug 4930323. Fixed issue in DRI validation.
33: || Did code clean up by introducing new flag variable
34: || l_change_value.
35: || ridas 10-Jan-2005 Bug #3701698. NVL is added in parameter new_references.disb_accepted_amt
36: || in procedure igf_aw_db_chg_dtls_pkg.insert_row
37: --------------------------------------------------------------*/
38:
39: CURSOR award_year_cal_cur (cp_award_id IGF_AW_AWD_DISB_ALL.award_id%TYPE) IS
40: SELECT fmast.ci_cal_type,fmast.ci_sequence_number, awd.award_status

Line 309: igf_aw_db_chg_dtls_pkg.insert_row(

305: END IF;
306:
307: -- Insert the new Disbursement change details record
308: l_row_id := NULL;
309: igf_aw_db_chg_dtls_pkg.insert_row(
310: x_rowid => l_row_id,
311: x_award_id => new_references.award_id,
312: x_disb_num => new_references.disb_num,
313: x_disb_seq_num => 1,

Line 435: igf_aw_db_chg_dtls_pkg.update_row (

431:
432: -- Update IGF_AW_DB_CHG_DTLS record with disb_Seq_no = 1 with disb_status = G and other details from the record in igf_aw_awd_disb_all
433:
434: -- Update the record, IGF_AW_DB_CHG_DTLS
435: igf_aw_db_chg_dtls_pkg.update_row (
436: x_rowid => upd_db_chg_dtls_rec.ROWID,
437: x_award_id => upd_db_chg_dtls_rec.award_id,
438: x_disb_num => upd_db_chg_dtls_rec.disb_num,
439: x_disb_seq_num => upd_db_chg_dtls_rec.disb_seq_num,

Line 500: igf_aw_db_chg_dtls_pkg.update_row (

496: 'Updating disb sequence ' ||latest_update_rec.disb_seq_num|| ' with the new disb amount');
497: END IF;
498:
499: -- Update the record
500: igf_aw_db_chg_dtls_pkg.update_row (
501: x_rowid => latest_update_rec.ROWID,
502: x_award_id => latest_update_rec.award_id,
503: x_disb_num => latest_update_rec.disb_num,
504: x_disb_seq_num => latest_update_rec.disb_seq_num,

Line 540: igf_aw_db_chg_dtls_pkg.insert_row(

536: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
537: 'Inserting new disb sequence ' ||NVL(l_max_disb_seq_num,1)|| ' with the new disb amount');
538: END IF;
539:
540: igf_aw_db_chg_dtls_pkg.insert_row(
541: x_rowid => l_row_id,
542: x_award_id => new_references.award_id,
543: x_disb_num => new_references.disb_num,
544: x_disb_seq_num => NVL(l_max_disb_seq_num,1),

Line 596: igf_aw_db_chg_dtls_pkg.update_row (

592: 'Updating disb sequence ' ||latest_update_rec.disb_seq_num|| ' with the new disb date');
593: END IF;
594:
595: -- Update the record
596: igf_aw_db_chg_dtls_pkg.update_row (
597: x_rowid => latest_update_rec.ROWID,
598: x_award_id => latest_update_rec.award_id,
599: x_disb_num => latest_update_rec.disb_num,
600: x_disb_seq_num => latest_update_rec.disb_seq_num,

Line 636: igf_aw_db_chg_dtls_pkg.insert_row(

632: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
633: 'Inserting new disb sequence ' ||NVL(l_max_disb_seq_num,1)|| ' with the new disb date');
634: END IF;
635:
636: igf_aw_db_chg_dtls_pkg.insert_row(
637: x_rowid => l_row_id,
638: x_award_id => new_references.award_id,
639: x_disb_num => new_references.disb_num,
640: x_disb_seq_num => NVL(l_max_disb_seq_num,1),

Line 1643: igf_aw_db_chg_dtls_pkg.get_fk_igf_aw_awd_disb(

1639: igs_fi_bill_pln_crd_pkg.get_fk_igf_aw_awd_disb (
1640: old_references.award_id,
1641: old_references.disb_num );
1642:
1643: igf_aw_db_chg_dtls_pkg.get_fk_igf_aw_awd_disb(
1644: old_references.award_id,
1645: old_references.disb_num);
1646:
1647: END check_child_existance;