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_AWD_DISB_ALL

Line 5: old_references igf_aw_awd_disb_all%ROWTYPE;

1: PACKAGE BODY igf_aw_awd_disb_pkg AS
2: /* $Header: IGFWI24B.pls 120.5 2006/08/07 08:11:27 veramach ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_disb_all%ROWTYPE;
6: new_references igf_aw_awd_disb_all%ROWTYPE;
7: g_v_called_from VARCHAR2(30);
8:
9: PROCEDURE AfterRowInsertUpdateDelete1(

Line 6: new_references igf_aw_awd_disb_all%ROWTYPE;

2: /* $Header: IGFWI24B.pls 120.5 2006/08/07 08:11:27 veramach ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_awd_disb_all%ROWTYPE;
6: new_references igf_aw_awd_disb_all%ROWTYPE;
7: g_v_called_from VARCHAR2(30);
8:
9: PROCEDURE AfterRowInsertUpdateDelete1(
10: p_inserting IN BOOLEAN ,

Line 39: CURSOR award_year_cal_cur (cp_award_id IGF_AW_AWD_DISB_ALL.award_id%TYPE) IS

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
41: FROM IGF_AW_AWARD_ALL awd,
42: IGF_AW_FUND_MAST fmast
43: WHERE awd.award_id = cp_award_id

Line 78: CURSOR min_disb_date_cur(cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS

74: WHERE pell.award_id = cp_award_id;
75:
76: pell_rec pell_cur%ROWTYPE;
77:
78: CURSOR min_disb_date_cur(cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS
79: SELECT min(disb_date)
80: FROM igf_aw_awd_disb_all
81: WHERE award_id = cp_award_id;
82:

Line 80: FROM igf_aw_awd_disb_all

76: pell_rec pell_cur%ROWTYPE;
77:
78: CURSOR min_disb_date_cur(cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS
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,

Line 109: FROM IGF_AW_AWD_DISB_ALL awddisb

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;
112:
113: l_row_id ROWID;

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 795: FROM IGF_AW_AWD_DISB_ALL

791: */
792:
793: CURSOR cur_old_ref_values IS
794: SELECT *
795: FROM IGF_AW_AWD_DISB_ALL
796: WHERE rowid = x_rowid;
797:
798: BEGIN
799:

Line 910: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE

906: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;
907:
908: CURSOR c_sl_clchsn_dtls (
909: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
910: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE
911: ) IS
912: SELECT chdt.ROWID row_id,chdt.*
913: FROM igf_sl_clchsn_dtls chdt
914: WHERE chdt.loan_number_txt = cp_v_loan_number

Line 927: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

923: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
924: l_v_message_name fnd_new_messages.message_name%TYPE;
925: l_b_return_status BOOLEAN;
926: l_n_award_id igf_aw_award_all.award_id%TYPE;
927: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
928: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
929: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
930: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
931: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;

Line 1048: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE

1044: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1045:
1046: CURSOR c_sl_clchsn_dtls (
1047: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
1048: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1049: ) IS
1050: SELECT chdt.ROWID row_id,chdt.*
1051: FROM igf_sl_clchsn_dtls chdt
1052: WHERE chdt.loan_number_txt = cp_v_loan_number

Line 1665: FROM igf_aw_awd_disb_all

1661: || (reverse chronological order - newest change first)
1662: */
1663: CURSOR cur_rowid IS
1664: SELECT rowid
1665: FROM igf_aw_awd_disb_all
1666: WHERE award_id = x_award_id
1667: AND disb_num = x_disb_num
1668: FOR UPDATE NOWAIT;
1669:

Line 1701: FROM igf_aw_awd_disb_all

1697: || (reverse chronological order - newest change first)
1698: */
1699: CURSOR cur_rowid IS
1700: SELECT rowid
1701: FROM igf_aw_awd_disb_all
1702: WHERE ((award_id = x_award_id));
1703:
1704: lv_rowid cur_rowid%RowType;
1705:

Line 1735: FROM igf_aw_awd_disb_all

1731: || (reverse chronological order - newest change first)
1732: */
1733: CURSOR cur_rowid IS
1734: SELECT rowid
1735: FROM igf_aw_awd_disb_all
1736: WHERE ((rvsn_id = x_rvsn_id));
1737:
1738: lv_rowid cur_rowid%RowType;
1739:

Line 1771: FROM igf_aw_awd_disb_all

1767: || (reverse chronological order - newest change first)
1768: */
1769: CURSOR cur_rowid IS
1770: SELECT rowid
1771: FROM igf_aw_awd_disb_all
1772: WHERE ((tp_cal_type = x_cal_type) AND
1773: (tp_sequence_number = x_sequence_number))
1774: OR ((ld_cal_type = x_cal_type) AND
1775: (ld_sequence_number = x_sequence_number));

Line 1808: FROM igf_aw_awd_disb_all

1804: || (reverse chronological order - newest change first)
1805: */
1806: CURSOR cur_rowid IS
1807: SELECT rowid
1808: FROM igf_aw_awd_disb_all
1809: WHERE fee_class = x_fee_class;
1810:
1811: lv_rowid cur_rowid%RowType;
1812:

Line 2063: FROM igf_aw_awd_disb_all

2059: || (reverse chronological order - newest change first)
2060: */
2061: CURSOR c IS
2062: SELECT rowid
2063: FROM igf_aw_awd_disb_all
2064: WHERE award_id = x_award_id
2065: AND disb_num = x_disb_num;
2066:
2067: x_last_update_date DATE;

Line 2074: l_org_id igf_aw_awd_disb_all.org_id%TYPE;

2070: x_request_id NUMBER;
2071: x_program_id NUMBER;
2072: x_program_application_id NUMBER;
2073: x_program_update_date DATE;
2074: l_org_id igf_aw_awd_disb_all.org_id%TYPE;
2075:
2076: BEGIN
2077: l_org_id := igf_aw_gen.get_org_id;
2078:

Line 2165: INSERT INTO igf_aw_awd_disb_all(

2161: x_direct_to_borr_flag => x_direct_to_borr_flag
2162: );
2163:
2164:
2165: INSERT INTO igf_aw_awd_disb_all(
2166: award_id,
2167: disb_num,
2168: tp_cal_type,
2169: tp_sequence_number,

Line 2419: FROM igf_aw_awd_disb_all

2415: change_type_code,
2416: fund_return_mthd_code,
2417: direct_to_borr_flag
2418:
2419: FROM igf_aw_awd_disb_all
2420: WHERE rowid = x_rowid
2421: FOR UPDATE NOWAIT;
2422:
2423: tlinfo c1%ROWTYPE;

Line 2661: UPDATE igf_aw_awd_disb_all

2657: --
2658:
2659: igf_aw_gen.update_disb( old_references,new_references );
2660:
2661: UPDATE igf_aw_awd_disb_all
2662: SET
2663: tp_cal_type = new_references.tp_cal_type,
2664: tp_sequence_number = new_references.tp_sequence_number,
2665: disb_gross_amt = new_references.disb_gross_amt,

Line 2810: FROM igf_aw_awd_disb_all

2806: || Added attendance_type_code to the signature
2807: */
2808: CURSOR c1 IS
2809: SELECT rowid
2810: FROM igf_aw_awd_disb_all
2811: WHERE award_id = x_award_id
2812: AND disb_num = x_disb_num;
2813:
2814: BEGIN

Line 2985: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' deleting the record from igf_aw_awd_disb_all table for rowid '||x_rowid);

2981: p_deleting => TRUE
2982: );
2983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2984: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' after invoking BeforeRowInsertUpdateDelete1 ');
2985: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' deleting the record from igf_aw_awd_disb_all table for rowid '||x_rowid);
2986: END IF;
2987: DELETE FROM igf_aw_awd_disb_all
2988: WHERE rowid = x_rowid;
2989:

Line 2987: DELETE FROM igf_aw_awd_disb_all

2983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2984: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' after invoking BeforeRowInsertUpdateDelete1 ');
2985: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' deleting the record from igf_aw_awd_disb_all table for rowid '||x_rowid);
2986: END IF;
2987: DELETE FROM igf_aw_awd_disb_all
2988: WHERE rowid = x_rowid;
2989:
2990: IF (SQL%NOTFOUND) THEN
2991: RAISE NO_DATA_FOUND;