eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_AWD_DISB_PKG dependencies on IGF_AW_DB_CHG_DTLS

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 47: CURSOR upd_db_chg_dtls_cur( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,

43: WHERE awd.award_id = cp_award_id
44: AND awd.fund_id = fmast.fund_id;
45: award_year_cal_rec award_year_cal_cur%ROWTYPE;
46:
47: CURSOR upd_db_chg_dtls_cur( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
48: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
49: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE) IS
50: SELECT dbchgdtls.ROWID,dbchgdtls.*
51: FROM igf_aw_db_chg_dtls dbchgdtls

Line 48: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,

44: AND awd.fund_id = fmast.fund_id;
45: award_year_cal_rec award_year_cal_cur%ROWTYPE;
46:
47: CURSOR upd_db_chg_dtls_cur( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
48: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
49: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE) IS
50: SELECT dbchgdtls.ROWID,dbchgdtls.*
51: FROM igf_aw_db_chg_dtls dbchgdtls
52: WHERE dbchgdtls.award_id = cp_award_id

Line 49: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE) IS

45: award_year_cal_rec award_year_cal_cur%ROWTYPE;
46:
47: CURSOR upd_db_chg_dtls_cur( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
48: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
49: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE) IS
50: SELECT dbchgdtls.ROWID,dbchgdtls.*
51: FROM igf_aw_db_chg_dtls dbchgdtls
52: WHERE dbchgdtls.award_id = cp_award_id
53: AND dbchgdtls.disb_num = cp_disb_num

Line 51: FROM igf_aw_db_chg_dtls dbchgdtls

47: CURSOR upd_db_chg_dtls_cur( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
48: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
49: cp_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE) IS
50: SELECT dbchgdtls.ROWID,dbchgdtls.*
51: FROM igf_aw_db_chg_dtls dbchgdtls
52: WHERE dbchgdtls.award_id = cp_award_id
53: AND dbchgdtls.disb_num = cp_disb_num
54: AND dbchgdtls.disb_seq_num = cp_disb_seq_num;
55: upd_db_chg_dtls_rec upd_db_chg_dtls_cur%ROWTYPE;

Line 57: CURSOR max_disb_seq_num_cur(cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,

53: AND dbchgdtls.disb_num = cp_disb_num
54: AND dbchgdtls.disb_seq_num = cp_disb_seq_num;
55: upd_db_chg_dtls_rec upd_db_chg_dtls_cur%ROWTYPE;
56:
57: CURSOR max_disb_seq_num_cur(cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
58: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE) IS
59: SELECT max(dbchgdtls.disb_seq_num)+1
60: FROM igf_aw_db_chg_dtls dbchgdtls
61: WHERE dbchgdtls.award_id = cp_award_id

Line 58: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE) IS

54: AND dbchgdtls.disb_seq_num = cp_disb_seq_num;
55: upd_db_chg_dtls_rec upd_db_chg_dtls_cur%ROWTYPE;
56:
57: CURSOR max_disb_seq_num_cur(cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
58: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE) IS
59: SELECT max(dbchgdtls.disb_seq_num)+1
60: FROM igf_aw_db_chg_dtls dbchgdtls
61: WHERE dbchgdtls.award_id = cp_award_id
62: AND dbchgdtls.disb_num = cp_disb_num;

Line 60: FROM igf_aw_db_chg_dtls dbchgdtls

56:
57: CURSOR max_disb_seq_num_cur(cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
58: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE) IS
59: SELECT max(dbchgdtls.disb_seq_num)+1
60: FROM igf_aw_db_chg_dtls dbchgdtls
61: WHERE dbchgdtls.award_id = cp_award_id
62: AND dbchgdtls.disb_num = cp_disb_num;
63: l_max_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE;
64:

Line 63: l_max_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE;

59: SELECT max(dbchgdtls.disb_seq_num)+1
60: FROM igf_aw_db_chg_dtls dbchgdtls
61: WHERE dbchgdtls.award_id = cp_award_id
62: AND dbchgdtls.disb_num = cp_disb_num;
63: l_max_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE;
64:
65: CURSOR loans_cur (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
66: SELECT sl.ROWID, sl.*
67: FROM IGF_SL_LOANS_ALL sl

Line 65: CURSOR loans_cur (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

61: WHERE dbchgdtls.award_id = cp_award_id
62: AND dbchgdtls.disb_num = cp_disb_num;
63: l_max_disb_seq_num igf_aw_db_chg_dtls.disb_seq_num%TYPE;
64:
65: CURSOR loans_cur (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
66: SELECT sl.ROWID, sl.*
67: FROM IGF_SL_LOANS_ALL sl
68: WHERE sl.award_id = cp_award_id;
69: loans_rec loans_cur%ROWTYPE;

Line 71: CURSOR pell_cur (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

67: FROM IGF_SL_LOANS_ALL sl
68: WHERE sl.award_id = cp_award_id;
69: loans_rec loans_cur%ROWTYPE;
70:
71: CURSOR pell_cur (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
72: SELECT pell.*, pell.ROWID
73: FROM igf_gr_rfms_all pell
74: WHERE pell.award_id = cp_award_id;
75:

Line 83: CURSOR cur_latest_accepted_DateAmt ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,

79: SELECT min(disb_date)
80: FROM igf_aw_awd_disb_all
81: WHERE award_id = cp_award_id;
82:
83: CURSOR cur_latest_accepted_DateAmt ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
84: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
85: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
86: SELECT chgdtls.*
87: FROM IGF_AW_DB_CHG_DTLS chgdtls

Line 84: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,

80: FROM igf_aw_awd_disb_all
81: WHERE award_id = cp_award_id;
82:
83: CURSOR cur_latest_accepted_DateAmt ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
84: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
85: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
86: SELECT chgdtls.*
87: FROM IGF_AW_DB_CHG_DTLS chgdtls
88: WHERE chgdtls.award_id = cp_award_id

Line 85: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS

81: WHERE award_id = cp_award_id;
82:
83: CURSOR cur_latest_accepted_DateAmt ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
84: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
85: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
86: SELECT chgdtls.*
87: FROM IGF_AW_DB_CHG_DTLS chgdtls
88: WHERE chgdtls.award_id = cp_award_id
89: AND chgdtls.disb_num = cp_disb_num

Line 87: FROM IGF_AW_DB_CHG_DTLS chgdtls

83: CURSOR cur_latest_accepted_DateAmt ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
84: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
85: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
86: SELECT chgdtls.*
87: FROM IGF_AW_DB_CHG_DTLS chgdtls
88: WHERE chgdtls.award_id = cp_award_id
89: AND chgdtls.disb_num = cp_disb_num
90: AND chgdtls.disb_status = 'A'
91: AND (chgdtls.disb_activity = 'P' OR chgdtls.disb_activity = cp_disb_activity)

Line 95: CURSOR cur_latest_DateAmt_for_update ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,

91: AND (chgdtls.disb_activity = 'P' OR chgdtls.disb_activity = cp_disb_activity)
92: ORDER BY chgdtls.disb_seq_num DESC;
93: latest_accepted_DateAmount_rec cur_latest_accepted_DateAmt%ROWTYPE;
94:
95: CURSOR cur_latest_DateAmt_for_update ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
96: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
97: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
98: SELECT chgdtls.ROWID, chgdtls.*
99: FROM IGF_AW_DB_CHG_DTLS chgdtls

Line 96: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,

92: ORDER BY chgdtls.disb_seq_num DESC;
93: latest_accepted_DateAmount_rec cur_latest_accepted_DateAmt%ROWTYPE;
94:
95: CURSOR cur_latest_DateAmt_for_update ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
96: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
97: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
98: SELECT chgdtls.ROWID, chgdtls.*
99: FROM IGF_AW_DB_CHG_DTLS chgdtls
100: WHERE chgdtls.award_id = cp_award_id

Line 97: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS

93: latest_accepted_DateAmount_rec cur_latest_accepted_DateAmt%ROWTYPE;
94:
95: CURSOR cur_latest_DateAmt_for_update ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
96: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
97: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
98: SELECT chgdtls.ROWID, chgdtls.*
99: FROM IGF_AW_DB_CHG_DTLS chgdtls
100: WHERE chgdtls.award_id = cp_award_id
101: AND chgdtls.disb_num = cp_disb_num

Line 99: FROM IGF_AW_DB_CHG_DTLS chgdtls

95: CURSOR cur_latest_DateAmt_for_update ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE,
96: cp_disb_num igf_aw_db_chg_dtls.disb_num%TYPE,
97: cp_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE) IS
98: SELECT chgdtls.ROWID, chgdtls.*
99: FROM IGF_AW_DB_CHG_DTLS chgdtls
100: WHERE chgdtls.award_id = cp_award_id
101: AND chgdtls.disb_num = cp_disb_num
102: AND chgdtls.disb_status <> 'A'
103: AND chgdtls.disb_activity = cp_disb_activity

Line 107: CURSOR cur_updated_award_amount (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

103: AND chgdtls.disb_activity = cp_disb_activity
104: ORDER BY chgdtls.disb_seq_num DESC;
105: latest_update_rec cur_latest_DateAmt_for_update%ROWTYPE;
106:
107: CURSOR cur_updated_award_amount (cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
108: SELECT SUM(awddisb.DISB_NET_AMT) total_amt
109: FROM IGF_AW_AWD_DISB_ALL awddisb
110: WHERE awddisb.award_id = cp_award_id;
111: updated_award_amount cur_updated_award_amount%ROWTYPE;

Line 121: l_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE;

117: lv_first_disb_seq_accepted BOOLEAN;
118: l_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
119: l_loan_type VARCHAR2(10);
120: l_min_disb_date DATE;
121: l_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE;
122: l_first_disb_flag igf_aw_db_chg_dtls.first_disb_flag%TYPE;
123: l_change_value NUMBER := 0;
124:
125: BEGIN

Line 122: l_first_disb_flag igf_aw_db_chg_dtls.first_disb_flag%TYPE;

118: l_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
119: l_loan_type VARCHAR2(10);
120: l_min_disb_date DATE;
121: l_disb_activity igf_aw_db_chg_dtls.disb_activity%TYPE;
122: l_first_disb_flag igf_aw_db_chg_dtls.first_disb_flag%TYPE;
123: l_change_value NUMBER := 0;
124:
125: BEGIN
126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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 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

428: -- museshad (Bug 4930323)
429:
430: IF (l_change_value = 1) THEN
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,

Line 434: -- Update the record, IGF_AW_DB_CHG_DTLS

430: IF (l_change_value = 1) THEN
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,

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;