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.

[Home] [Help]

APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_INVLN_INT_ALL

Line 469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,

465: -- enh bug#2584986, removed proc get_local_amount
466:
467: PROCEDURE call_build_process ( p_header_rec IN igs_fi_charges_api_pvt.header_rec_type,
468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,

Line 470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,

466:
467: PROCEDURE call_build_process ( p_header_rec IN igs_fi_charges_api_pvt.header_rec_type,
468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,
474: p_flag OUT NOCOPY NUMBER

Line 471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,

467: PROCEDURE call_build_process ( p_header_rec IN igs_fi_charges_api_pvt.header_rec_type,
468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,
474: p_flag OUT NOCOPY NUMBER
475: ) AS

Line 472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,

468: p_line_rec IN igs_fi_charges_api_pvt.line_rec_type,
469: p_dr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
470: p_cr_gl_ccid IN OUT NOCOPY igs_fi_invln_int_all.rec_gl_ccid%TYPE,
471: p_dr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rec_account_cd%TYPE,
472: p_cr_account_cd IN OUT NOCOPY igs_fi_invln_int_all.rev_account_cd%TYPE,
473: p_error_string OUT NOCOPY igs_fi_invln_int.error_string%TYPE,
474: p_flag OUT NOCOPY NUMBER
475: ) AS
476: /**********************************************************************************************************************

Line 513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;

509: The call to the procedure igs_fi_prc_acct_pkg.build_accounts was modified.
510: **********************************************************************************************************************/
511:
512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;

Line 514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;

510: **********************************************************************************************************************/
511:
512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;

Line 515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;

511:
512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;

Line 516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;

512:
513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;
520: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 517: l_err_string igs_fi_invln_int_all.error_string%TYPE;

513: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
514: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
515: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
516: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;
520: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;
521: l_st_date igs_or_unit.start_dt%TYPE;

Line 1221: gurprsin 02-Jun-2005 Enh# 3442712 Modified TBH call of table IGS_fi_invln_int_all

1217: Removed invocation of validate_atd_mode and validate_atd_type
1218: svuppala 07-JUL-2005 Enh 3392095 - Tution Waivers build
1219: Modified HEADER_REC_TYPE -- included waiver_name.
1220: Modified l_api_version
1221: gurprsin 02-Jun-2005 Enh# 3442712 Modified TBH call of table IGS_fi_invln_int_all
1222: i.e. igs_fi_inv_int_pkg.insert_row to include unit_type_id and unti_level
1223: pmarada 26-May-2005 Enh#3020586- added tax year code column as per 1098-t reporting build
1224: uudayapr 08-Mar-2004 Bug#3478599.Added the code to prevent charge creation with
1225: error account as Y for Transaction Type as

Line 1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;

1331: -- these variable are added w.r.t finance accounting bug no : 1882122
1332: l_error_string igs_fi_invln_int.error_string%TYPE;
1333: l_flag NUMBER;
1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
1337: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
1339:

Line 1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;

1332: l_error_string igs_fi_invln_int.error_string%TYPE;
1333: l_flag NUMBER;
1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
1337: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
1339:
1340: l_message_name fnd_new_messages.message_name%TYPE := NULL;

Line 1337: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;

1333: l_flag NUMBER;
1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
1337: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
1339:
1340: l_message_name fnd_new_messages.message_name%TYPE := NULL;
1341: l_n_invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE;

Line 1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;

1334: l_error_account VARCHAR2(1) := 'N';
1335: l_dr_gl_ccid igs_fi_invln_int_all.rec_gl_ccid%TYPE;
1336: l_cr_gl_ccid igs_fi_invln_int_all.rev_gl_ccid%TYPE;
1337: l_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
1339:
1340: l_message_name fnd_new_messages.message_name%TYPE := NULL;
1341: l_n_invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE;
1342: l_n_amount igs_fi_invln_int_all.amount%TYPE;

Line 1342: l_n_amount igs_fi_invln_int_all.amount%TYPE;

1338: l_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
1339:
1340: l_message_name fnd_new_messages.message_name%TYPE := NULL;
1341: l_n_invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE;
1342: l_n_amount igs_fi_invln_int_all.amount%TYPE;
1343:
1344: -- Cursor for getting the record from the Charges table based on the invoice id
1345: -- passed to the cursor
1346: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.Invoice_Id%TYPE) IS

Line 1387: cp_uoo_id igs_fi_invln_int_all.uoo_id%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,
1388: cp_location_cd igs_fi_invln_int_all.location_cd%TYPE,
1389: cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
1390: SELECT inv.rowid row_id,
1391: inv.invoice_id invoice_id,

Line 1388: cp_location_cd igs_fi_invln_int_all.location_cd%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,
1388: cp_location_cd igs_fi_invln_int_all.location_cd%TYPE,
1389: cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
1390: SELECT inv.rowid row_id,
1391: inv.invoice_id invoice_id,
1392: inv.invoice_amount_due invoice_amount_due,

Line 1395: igs_fi_invln_int_all iln

1391: inv.invoice_id invoice_id,
1392: inv.invoice_amount_due invoice_amount_due,
1393: inv.invoice_amount invoice_amount
1394: FROM igs_fi_inv_int_all inv,
1395: igs_fi_invln_int_all iln
1396: WHERE inv.invoice_id = iln.invoice_id
1397: AND inv.person_id = cp_person_id
1398: AND inv.fee_type = cp_fee_type
1399: AND inv.fee_cal_type = cp_fee_cal_type