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_DB_CL_ROSTER dependencies on IGF_AW_AWD_DISB_ALL

Line 32: -- in IGF_AW_AWD_DISB_ALL table.The call to

28: -- records based on award year
29: -- Corrected typos in messages and lookup codes
30: -----------------------------------------------------------------------------------
31: -- mesriniv 13-07-2001 W.r.to Awards Build,9 new columns have been added
32: -- in IGF_AW_AWD_DISB_ALL table.The call to
33: -- igf_aw_awd_disb_pkg.update_row has been modified
34: -- to reflect the changes.
35: -----------------------------------------------------------------------------------
36: -- ssawhney 2nd Jan Stud Emp build IGF_AW_AWD_DISB TBH call changed.

Line 946: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

942: ***************************************************************/
943:
944: l_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
945: l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE;
946: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
947:
948: l_disb_gross_amt igf_db_cl_disb_resp_all.gross_disb_amt%TYPE;
949: l_fee_1 igf_db_cl_disb_resp_all.fee_1%TYPE;
950: l_fee_2 igf_db_cl_disb_resp_all.fee_2%TYPE;

Line 972: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

968: FOR UPDATE OF status NOWAIT;
969:
970:
971: PROCEDURE log_start(p_loan_number igf_sl_loans_all.loan_number%TYPE,
972: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
973: AS
974: l_msg_str_0 VARCHAR2(1000);
975: BEGIN
976: loan_number_desc := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');

Line 1035: l_fund_status igf_aw_awd_disb_all.fund_status%TYPE;

1031: l_direct_to_borr_ind := cbth_rec.direct_to_borr_flag;
1032:
1033: DECLARE
1034:
1035: l_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
1036: l_awd_disb_accep_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;
1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;

Line 1036: l_awd_disb_accep_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;

1032:
1033: DECLARE
1034:
1035: l_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
1036: l_awd_disb_accep_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;
1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;

Line 1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;

1033: DECLARE
1034:
1035: l_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
1036: l_awd_disb_accep_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;
1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;
1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;

Line 1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;

1034:
1035: l_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
1036: l_awd_disb_accep_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;
1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;
1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;
1042: l_award_id igf_aw_awd_disb_all.award_id%TYPE;

Line 1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;

1035: l_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
1036: l_awd_disb_accep_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;
1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;
1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;
1042: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
1043: l_auto_late_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;

Line 1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;

1036: l_awd_disb_accep_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;
1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;
1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;
1042: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
1043: l_auto_late_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;
1044: l_awd_direct_to_borr_ind igf_aw_awd_disb_all.direct_to_borr_flag%TYPE;

Line 1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;

1037: l_awd_fee_1 igf_aw_awd_disb_all.fee_1%TYPE;
1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;
1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;
1042: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
1043: l_auto_late_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;
1044: l_awd_direct_to_borr_ind igf_aw_awd_disb_all.direct_to_borr_flag%TYPE;
1045:

Line 1042: l_award_id igf_aw_awd_disb_all.award_id%TYPE;

1038: l_awd_fee_2 igf_aw_awd_disb_all.fee_2%TYPE;
1039: l_awd_net_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;
1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;
1042: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
1043: l_auto_late_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;
1044: l_awd_direct_to_borr_ind igf_aw_awd_disb_all.direct_to_borr_flag%TYPE;
1045:
1046: l_msg_str1 VARCHAR2(1000);

Line 1044: l_awd_direct_to_borr_ind igf_aw_awd_disb_all.direct_to_borr_flag%TYPE;

1040: l_awd_fee_paid_2 igf_aw_awd_disb_all.fee_paid_2%TYPE;
1041: l_awd_fee_paid_1 igf_aw_awd_disb_all.fee_paid_1%TYPE;
1042: l_award_id igf_aw_awd_disb_all.award_id%TYPE;
1043: l_auto_late_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;
1044: l_awd_direct_to_borr_ind igf_aw_awd_disb_all.direct_to_borr_flag%TYPE;
1045:
1046: l_msg_str1 VARCHAR2(1000);
1047: l_msg_str2 VARCHAR2(4000);
1048: l_msg_str3 VARCHAR2(1000);

Line 1051: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

1047: l_msg_str2 VARCHAR2(4000);
1048: l_msg_str3 VARCHAR2(1000);
1049:
1050: CURSOR cur_awdisb(l_loan_number igf_db_cl_disb_resp_all.loan_number%TYPE,
1051: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
1052: IS
1053: SELECT
1054: disb.*
1055: FROM igf_aw_awd_disb disb,igf_sl_loans_all loans