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_SL_DL_PNOTE_ACK dependencies on IGF_AW_AWD_DISB

Line 69: -- IGF_AW_AWD_DISB table to 'Y'.

65: -- insert records into IGF_DB_DISB_HOLDS
66: -- table with hold 'EXTERNAL' and
67: -- hold type 'SYSTEM' and also
68: -- update manual_hold_ind flag in
69: -- IGF_AW_AWD_DISB table to 'Y'.
70: -- enh bug no-2154941.
71: ---------------------------------------------------------------------------------
72: -- ssawhney 2nd jan TBH call of IGF_AW_AWD_DISB table
73: -- changed in Stud Emp build

Line 72: -- ssawhney 2nd jan TBH call of IGF_AW_AWD_DISB table

68: -- update manual_hold_ind flag in
69: -- IGF_AW_AWD_DISB table to 'Y'.
70: -- enh bug no-2154941.
71: ---------------------------------------------------------------------------------
72: -- ssawhney 2nd jan TBH call of IGF_AW_AWD_DISB table
73: -- changed in Stud Emp build
74: -- en bug no 2161847
75: ---------------------------------------------------------------------------------
76: -- mesriniv 13/07/2001 Modified the call to

Line 77: -- igf_aw_awd_disb_pkg.update_row

73: -- changed in Stud Emp build
74: -- en bug no 2161847
75: ---------------------------------------------------------------------------------
76: -- mesriniv 13/07/2001 Modified the call to
77: -- igf_aw_awd_disb_pkg.update_row
78: -- since 9 columns were added to the
79: -- table igf_aw_awd_disb_all.
80: ---------------------------------------------------------------------------------
81: --

Line 79: -- table igf_aw_awd_disb_all.

75: ---------------------------------------------------------------------------------
76: -- mesriniv 13/07/2001 Modified the call to
77: -- igf_aw_awd_disb_pkg.update_row
78: -- since 9 columns were added to the
79: -- table igf_aw_awd_disb_all.
80: ---------------------------------------------------------------------------------
81: --
82:
83: g_lor_loc_rec igf_sl_lor_loc%ROWTYPE;

Line 926: FILE WITH THAT in the IGF_AW_AWD_DISB table

922: /***************************************************************
923: Created By : prchandr
924: Date Created By : 2000/12/07
925: Purpose : To Compare the Disbursement Amounts specified in the
926: FILE WITH THAT in the IGF_AW_AWD_DISB table
927: Known Limitations,Enhancements or Remarks
928: Change History :
929: Who When What
930: ***************************************************************/

Line 934: l_award_id igf_aw_awd_disb.award_id%TYPE;

930: ***************************************************************/
931:
932: l_old_count NUMBER;
933: l_new_count NUMBER;
934: l_award_id igf_aw_awd_disb.award_id%TYPE;
935: l_disb_num igf_aw_awd_disb.disb_num%TYPE;
936: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
937:
938:

Line 935: l_disb_num igf_aw_awd_disb.disb_num%TYPE;

931:
932: l_old_count NUMBER;
933: l_new_count NUMBER;
934: l_award_id igf_aw_awd_disb.award_id%TYPE;
935: l_disb_num igf_aw_awd_disb.disb_num%TYPE;
936: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
937:
938:
939: --Count the No.of Disbursements for the award id in Awards Disbursements Table

Line 936: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;

932: l_old_count NUMBER;
933: l_new_count NUMBER;
934: l_award_id igf_aw_awd_disb.award_id%TYPE;
935: l_disb_num igf_aw_awd_disb.disb_num%TYPE;
936: l_disb_gross_amt igf_aw_awd_disb.disb_gross_amt%TYPE;
937:
938:
939: --Count the No.of Disbursements for the award id in Awards Disbursements Table
940: CURSOR cur_count_old_disb

Line 942: SELECT award_id, NVL(COUNT(disb_num),0) FROM igf_aw_awd_disb

938:
939: --Count the No.of Disbursements for the award id in Awards Disbursements Table
940: CURSOR cur_count_old_disb
941: IS
942: SELECT award_id, NVL(COUNT(disb_num),0) FROM igf_aw_awd_disb
943: WHERE award_id = (SELECT award_id FROM igf_sl_loans
944: WHERE loan_number = p_loan_number)
945: GROUP BY award_id;
946:

Line 958: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb

954: -- currently in our system.
955: CURSOR cur_disb_same_data IS
956: SELECT disb_num, disb_gross_amt FROM
957: ((
958: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
959: WHERE award_id = l_award_id
960: MINUS
961: SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp
962: WHERE dlpnr_id = loaded_1rec.dlpnr_id

Line 968: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb

964: UNION
965: (SELECT dlpdr_id, disb_gross_amt FROM igf_sl_dl_pdet_resp resp
966: WHERE dlpnr_id = loaded_1rec.dlpnr_id
967: MINUS
968: SELECT disb_num, NVL(disb_accepted_amt,0) disb_gross_amt FROM igf_aw_awd_disb adisb
969: WHERE award_id = l_award_id
970: )
971: );
972:

Line 983: SELECT * FROM igf_aw_awd_disb

979:
980: --Select the old Disbursements for the award id in Awards Disbursements Table
981: CURSOR cur_old_disbursements
982: IS
983: SELECT * FROM igf_aw_awd_disb
984: WHERE award_id = l_award_id
985: ORDER BY disb_num;
986:
987:

Line 1042: PROCEDURE place_disb_holds(p_award_id igf_aw_awd_disb.award_id%TYPE)

1038:
1039: END show_disb_details;
1040:
1041:
1042: PROCEDURE place_disb_holds(p_award_id igf_aw_awd_disb.award_id%TYPE)
1043: AS
1044: CURSOR c_tbh_cur IS
1045: SELECT adisb.* FROM igf_aw_awd_disb adisb
1046: WHERE award_id = p_award_id and

Line 1045: SELECT adisb.* FROM igf_aw_awd_disb adisb

1041:
1042: PROCEDURE place_disb_holds(p_award_id igf_aw_awd_disb.award_id%TYPE)
1043: AS
1044: CURSOR c_tbh_cur IS
1045: SELECT adisb.* FROM igf_aw_awd_disb adisb
1046: WHERE award_id = p_award_id and
1047: trans_type = 'P';
1048:
1049: CURSOR cur_disb_hold_exists(cp_award_id igf_db_disb_holds.award_id%TYPE,