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.IGS_FI_CHARGES_API_PVT dependencies on IGS_CA_INST

Line 11: -- cur_alt_cd_desc is modified to select another column igs_ca_inst_all.description.

7: --Who When What
8: --skharida 26-Jun-2006 Bug 5208136 - Modified procedure create_charge, removed the obsoleted columns of the IGS_FI_INV_INT_PKG
9: --akandreg 20-Jun-2006 Bug 5116519 - The Message 'IGS_FI_INVALID_FTCI' is modified .The old token FEE_CAL_TYPE
10: -- is replaced by new token CI_DESC and passed fee CI description to that. Also the cursor
11: -- cur_alt_cd_desc is modified to select another column igs_ca_inst_all.description.
12: --pathipat 12-Jun-2006 Bug 5306868 - Modified create_charge - charge adjustment logic revamped
13: --sapanigr 29-May-2006 Bug 5251760 Modified create_charge. Added new local function chk_charge_adjusted.
14: --svuppala 05-May-2006 Bug 3924836 Precision Issue. Modified create_charge and validate_neg_amt
15: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Modified create_charge

Line 776: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;

772: l_msg_data VARCHAR2(2000);
773: l_application_id igs_fi_applications.application_id%TYPE;
774: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
775:
776: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
777: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
778: l_b_return_status BOOLEAN;
779: l_v_message_name fnd_new_messages.message_name%TYPE;
780:

Line 777: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

773: l_application_id igs_fi_applications.application_id%TYPE;
774: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
775:
776: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
777: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
778: l_b_return_status BOOLEAN;
779: l_v_message_name fnd_new_messages.message_name%TYPE;
780:
781:

Line 1083: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,

1079:
1080:
1081: CURSOR cur_val_chg(cp_person_id igs_pe_person.person_id%TYPE,
1082: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1083: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1084: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1085: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1086: cp_course_cd igs_ps_ver.course_cd%TYPE,
1087: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,

Line 1084: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

1080:
1081: CURSOR cur_val_chg(cp_person_id igs_pe_person.person_id%TYPE,
1082: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1083: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1084: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1085: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1086: cp_course_cd igs_ps_ver.course_cd%TYPE,
1087: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,
1088: cp_location_cd igs_fi_invln_int.location_cd%TYPE,

Line 1202: cur_alt_cd_desc is modified to select another column 'description' from igs_ca_inst_all.

1198: Who When What
1199: skharida 26-Jun-2006 Bug 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL
1200: akandreg 20-Jun-2006 Bug 5116519 - The Message 'IGS_FI_INVALID_FTCI' is modified .The old token FEE_CAL_TYPE
1201: is replaced by new token CI_DESC and passed fee CI description to that. Also the cursor
1202: cur_alt_cd_desc is modified to select another column 'description' from igs_ca_inst_all.
1203: pathipat 12-Jun-2006 Bug 5306868 - Modified cursor cur_chg: Added filter on invoice_amount_due
1204: and removed ORDER_BY on diff_amt
1205: Added cursors cur_chgadj, cur_charges, associated code and local variables.
1206: sapanigr 29-May-2006 Bug 5251760 Added cursor cur_chg_inv. Removed UNION in cur_chg. Modified related code appropriately

Line 1382: cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,

1378: -- used to select the charges. The charges are ordered by the Invoice Amount Due in
1379: -- descending order
1380: CURSOR cur_chg(cp_person_id igs_pe_person.person_id%TYPE,
1381: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1382: cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1384: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1385: cp_course_cd igs_ps_ver.course_cd%TYPE,
1386: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE,

Line 1383: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1379: -- descending order
1380: CURSOR cur_chg(cp_person_id igs_pe_person.person_id%TYPE,
1381: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1382: cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1384: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1385: cp_course_cd igs_ps_ver.course_cd%TYPE,
1386: cp_transaction_type igs_fi_inv_int_all.transaction_type%TYPE,
1387: cp_uoo_id igs_fi_invln_int_all.uoo_id%TYPE,

Line 1473: CURSOR cur_alt_cd_desc(cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,

1469: l_v_igs_fi_auto_calc_waivers VARCHAR2(1);
1470:
1471: --Cursor to get alternate code, description to pass as token for IGS_FI_WAV_PGM_NO_REC_FOUND,
1472: --IGS_FI_INVALID_FTCI respectively
1473: CURSOR cur_alt_cd_desc(cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1474: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
1475: SELECT alternate_code , description
1476: FROM igs_ca_inst_all
1477: WHERE cal_type = cp_fee_cal_type

Line 1474: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS

1470:
1471: --Cursor to get alternate code, description to pass as token for IGS_FI_WAV_PGM_NO_REC_FOUND,
1472: --IGS_FI_INVALID_FTCI respectively
1473: CURSOR cur_alt_cd_desc(cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1474: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
1475: SELECT alternate_code , description
1476: FROM igs_ca_inst_all
1477: WHERE cal_type = cp_fee_cal_type
1478: AND sequence_number = cp_fee_ci_sequence_number;

Line 1476: FROM igs_ca_inst_all

1472: --IGS_FI_INVALID_FTCI respectively
1473: CURSOR cur_alt_cd_desc(cp_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1474: cp_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
1475: SELECT alternate_code , description
1476: FROM igs_ca_inst_all
1477: WHERE cal_type = cp_fee_cal_type
1478: AND sequence_number = cp_fee_ci_sequence_number;
1479:
1480: l_v_fee_alt_cd igs_ca_inst_all.alternate_code%TYPE;

Line 1480: l_v_fee_alt_cd igs_ca_inst_all.alternate_code%TYPE;

1476: FROM igs_ca_inst_all
1477: WHERE cal_type = cp_fee_cal_type
1478: AND sequence_number = cp_fee_ci_sequence_number;
1479:
1480: l_v_fee_alt_cd igs_ca_inst_all.alternate_code%TYPE;
1481: l_v_fee_ci_desc igs_ca_inst_all.description%TYPE;
1482:
1483: -- Cursor to pick up all charges following the unique key (or) for a
1484: -- specific invoice_id (similar to cur_chg, except the ORDER BY clause and check on invoice_amount_due)

Line 1481: l_v_fee_ci_desc igs_ca_inst_all.description%TYPE;

1477: WHERE cal_type = cp_fee_cal_type
1478: AND sequence_number = cp_fee_ci_sequence_number;
1479:
1480: l_v_fee_alt_cd igs_ca_inst_all.alternate_code%TYPE;
1481: l_v_fee_ci_desc igs_ca_inst_all.description%TYPE;
1482:
1483: -- Cursor to pick up all charges following the unique key (or) for a
1484: -- specific invoice_id (similar to cur_chg, except the ORDER BY clause and check on invoice_amount_due)
1485: CURSOR cur_charges(cp_person_id igs_pe_person.person_id%TYPE,

Line 1487: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,

1483: -- Cursor to pick up all charges following the unique key (or) for a
1484: -- specific invoice_id (similar to cur_chg, except the ORDER BY clause and check on invoice_amount_due)
1485: CURSOR cur_charges(cp_person_id igs_pe_person.person_id%TYPE,
1486: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1487: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1488: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1489: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1490: cp_course_cd igs_ps_ver.course_cd%TYPE,
1491: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,

Line 1488: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

1484: -- specific invoice_id (similar to cur_chg, except the ORDER BY clause and check on invoice_amount_due)
1485: CURSOR cur_charges(cp_person_id igs_pe_person.person_id%TYPE,
1486: cp_fee_type igs_fi_fee_type.fee_type%TYPE,
1487: cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
1488: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1489: cp_fee_cat igs_fi_fee_cat.fee_cat%TYPE,
1490: cp_course_cd igs_ps_ver.course_cd%TYPE,
1491: cp_transaction_type igs_fi_inv_int.transaction_type%TYPE,
1492: cp_uoo_id igs_fi_invln_int.uoo_id%TYPE,