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

Line 15: -- Changed the TBH call of the package: IGF_AW_AWD_DISB_PKG

11: -- svuppala 27-OCT-04 FA 134 CommonLine4 Change Origination
12: -- # 3416936 Modifications to disbursement roster process
13: ----------------------------------------------------------------------------------------
14: --ayedubat 14-OCT-04 FA 149 COD-XML Standards build bug # 3416863
15: -- Changed the TBH call of the package: IGF_AW_AWD_DISB_PKG
16: -----------------------------------------------------------------------------------
17: -- veramach July 2004 FA 151 HR integration (bug # 3709292)
18: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg
19: -----------------------------------------------------------------------------------

Line 18: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg

14: --ayedubat 14-OCT-04 FA 149 COD-XML Standards build bug # 3416863
15: -- Changed the TBH call of the package: IGF_AW_AWD_DISB_PKG
16: -----------------------------------------------------------------------------------
17: -- veramach July 2004 FA 151 HR integration (bug # 3709292)
18: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg
19: -----------------------------------------------------------------------------------
20: -- Who When What
21: -- veramach 3-NOV-2003 FA 125 Multiple Distr Methods
22: -- Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code

Line 22: -- Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code

18: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg
19: -----------------------------------------------------------------------------------
20: -- Who When What
21: -- veramach 3-NOV-2003 FA 125 Multiple Distr Methods
22: -- Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
23: -----------------------------------------------------------------------------------
24: -- sjadhav 26-Mar-2003 Bug 2863960
25: -- Changed Disb Gross Amt to Disb Accepted Amt
26: -- As net amount is based on accepted amount

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 33: -- igf_aw_awd_disb_pkg.update_row has been modified

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.
37: -----------------------------------------------------------------------------------

Line 36: -- ssawhney 2nd Jan Stud Emp build IGF_AW_AWD_DISB TBH call changed.

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.
37: -----------------------------------------------------------------------------------
38:
39: FILE_NOT_LOADED EXCEPTION;
40: CLSETUP_NOT_FOUND EXCEPTION;

Line 927: This procedure updates igf_aw_awd_disb table based on

923: Created By : sjadhav
924: Date Created On : 2000/12/18
925:
926: Purpose :This is the procedeure called by con prog.
927: This procedure updates igf_aw_awd_disb table based on
928: certain conditions.
929: This process will set the status of all the records
930: processed as 'Processed' in the igf_db_cl_disb_resp
931: table.

Line 941: Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code

937: ridas 07-Aug-2006 Build FA163. Added condition to check the Direct_to_borr_ind difference between
938: the roster information and the disbursement table information.
939: tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
940: veramach 3-NOV-2003 FA 125 Multiple Distr Methods
941: Changed the call of igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
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;

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

Line 1055: FROM igf_aw_awd_disb disb,igf_sl_loans_all loans

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
1056: WHERE
1057: NVL(loans.external_loan_id_txt, loans.loan_number) = l_loan_number AND
1058: disb.award_id = loans.award_id AND
1059: disb.disb_num = l_disb_num

Line 1164: -- No updates for igf_aw_awd_disb table

1160:
1161: -- Condition 2 : Check if the Disbursement was already FUNDED.
1162: IF l_fund_status = 'Y' THEN
1163: -- If the fund status is already funded then skip this record
1164: -- No updates for igf_aw_awd_disb table
1165: IF l_rec_type = 'N' THEN
1166: fnd_message.set_name('IGF','IGF_DB_ROST_ALFND_NOUPD');
1167: fnd_file.put_line(fnd_file.log,fnd_message.get);
1168: fnd_file.new_line(fnd_file.log,1);

Line 1181: -- with those of in igf_aw_awd_disb

1177:
1178: -- Condition 3 : Check if the Amounts are Different.
1179: -- If the fund staus is not funded then
1180: -- 1.Compare the amounts in the Roster File Records
1181: -- with those of in igf_aw_awd_disb
1182: -- records for this particular disb_num
1183:
1184: IF NVL(l_disb_gross_amt,0)<> NVL(l_awd_disb_accep_amt,0) OR
1185: NVL(l_fee_1,0) <> NVL(l_awd_fee_1,0) OR

Line 1269: -- 2.b.Update igf_aw_awd_disb

1265: RAISE SKIP_THIS_RECORD;
1266: END IF;
1267:
1268:
1269: -- 2.b.Update igf_aw_awd_disb
1270: -- set the fund status = FUNDED
1271: IF lv_rec_status = 'N' THEN
1272: lv_rec_status := 'U';
1273: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');

Line 1283: igf_aw_awd_disb_pkg.update_row(

1279: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug',
1280: 'Updating aw disb , award_id, disb_num, RESP_status ' || disb_rec.award_id || ' : ' || disb_rec.disb_num || ' : ' || lv_rec_status);
1281: END IF;
1282:
1283: igf_aw_awd_disb_pkg.update_row(
1284: x_mode => 'R',
1285: x_rowid => disb_rec.row_id,
1286: x_award_id => disb_rec.award_id,
1287: x_disb_num => disb_rec.disb_num,