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_PRC_APPL dependencies on IGS_FI_INV_INT_ALL

Line 129: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

125: RETURN(l_max_date.max_date);
126: END eff_max_date;
127:
128: PROCEDURE apply_and_log_messages (
129: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
130: p_credit_id IN igs_fi_credits.credit_id%TYPE,
131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,

Line 131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

127:
128: PROCEDURE apply_and_log_messages (
129: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
130: p_credit_id IN igs_fi_credits.credit_id%TYPE,
131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,
134: p_orig_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,
135: p_invoice_amount_due IN OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,

Line 132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,

128: PROCEDURE apply_and_log_messages (
129: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
130: p_credit_id IN igs_fi_credits.credit_id%TYPE,
131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,
134: p_orig_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,
135: p_invoice_amount_due IN OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
136: p_amount_applied IN igs_fi_applications.amount_applied%TYPE,

Line 134: p_orig_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,

130: p_credit_id IN igs_fi_credits.credit_id%TYPE,
131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,
134: p_orig_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,
135: p_invoice_amount_due IN OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
136: p_amount_applied IN igs_fi_applications.amount_applied%TYPE,
137: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,
138: P_counter IN OUT NOCOPY NUMBER ,

Line 135: p_invoice_amount_due IN OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,

131: p_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
132: p_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
133: p_unapplied_amount IN OUT NOCOPY igs_fi_credits.unapplied_amount%TYPE,
134: p_orig_invoice_amount_due IN igs_fi_inv_int_all.invoice_amount_due%TYPE,
135: p_invoice_amount_due IN OUT NOCOPY igs_fi_inv_int_all.invoice_amount_due%TYPE,
136: p_amount_applied IN igs_fi_applications.amount_applied%TYPE,
137: p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_id%TYPE,
138: P_counter IN OUT NOCOPY NUMBER ,
139: p_d_gl_date IN DATE

Line 193: l_dummy_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;

189: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
190: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
191: l_b_status BOOLEAN := FALSE ;
192: l_dummy_unapplied_amount igs_fi_credits.unapplied_amount%TYPE;
193: l_dummy_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
194:
195: BEGIN
196:
197: --added by vvutukur for bug#2326163

Line 349: p_person_id igs_fi_inv_int_all.person_id%TYPE,

345:
346: PROCEDURE mass_application ( errbuf OUT NOCOPY VARCHAR2,
347: retcode OUT NOCOPY NUMBER,
348: p_org_id NUMBER,
349: p_person_id igs_fi_inv_int_all.person_id%TYPE,
350: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
351: p_credit_number igs_fi_credits_all.credit_number%TYPE,
352: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
353: p_credit_date_low VARCHAR2,

Line 445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,

441: fnd_file.put_line(fnd_file.log,sqlerrm);
442: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
443: END mass_application;
444:
445: PROCEDURE mass_apply(p_person_id igs_fi_inv_int_all.person_id%TYPE,
446: p_person_id_grp igs_pe_prsid_grp_mem_all.group_id%TYPE,
447: p_credit_number igs_fi_credits_all.credit_number%TYPE,
448: p_credit_type_id igs_fi_credits_all.credit_type_id%TYPE,
449: p_credit_date_low VARCHAR2,

Line 528: CURSOR cur_credits( cp_person_id igs_fi_inv_int_all.person_id%TYPE,

524:
525: -- cursor for getting all the positive unapplied amount depending on the
526: -- parameters passed by the user --
527: -- Those credits that have CHGADJ as credit type with credit class
528: CURSOR cur_credits( cp_person_id igs_fi_inv_int_all.person_id%TYPE,
529: cp_credit_date_low DATE,
530: cp_credit_date_high DATE)
531: IS
532: SELECT cr.rowid, cr.*,crt.credit_type_name,crt.appl_hierarchy_id

Line 576: CURSOR cur_charges(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

572: ORDER BY rule_sequence;
573:
574: -- cursor for getting all the charge records that can be applied for the
575: -- various enabled fee types for a person for the fee period (which do not have error account)
576: CURSOR cur_charges(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
577: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
578: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
579: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
580: IS

Line 577: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,

573:
574: -- cursor for getting all the charge records that can be applied for the
575: -- various enabled fee types for a person for the fee period (which do not have error account)
576: CURSOR cur_charges(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
577: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
578: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
579: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
580: IS
581: SELECT rowid, inv.*

Line 578: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,

574: -- cursor for getting all the charge records that can be applied for the
575: -- various enabled fee types for a person for the fee period (which do not have error account)
576: CURSOR cur_charges(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
577: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
578: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
579: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
580: IS
581: SELECT rowid, inv.*
582: FROM igs_fi_inv_int inv

Line 579: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)

575: -- various enabled fee types for a person for the fee period (which do not have error account)
576: CURSOR cur_charges(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
577: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
578: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
579: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
580: IS
581: SELECT rowid, inv.*
582: FROM igs_fi_inv_int inv
583: WHERE person_id = cp_person_id AND

Line 598: CURSOR cur_charges_not_fp(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

594:
595: -- cursor for getting all the charges records that can be applied for
596: -- various enabled fee types for a person NOT In the fee period (which do not have error account)
597:
598: CURSOR cur_charges_not_fp(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
599: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
600: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
601: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
602: IS

Line 599: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,

595: -- cursor for getting all the charges records that can be applied for
596: -- various enabled fee types for a person NOT In the fee period (which do not have error account)
597:
598: CURSOR cur_charges_not_fp(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
599: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
600: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
601: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
602: IS
603: SELECT rowid, inv.*

Line 600: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,

596: -- various enabled fee types for a person NOT In the fee period (which do not have error account)
597:
598: CURSOR cur_charges_not_fp(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
599: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
600: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
601: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
602: IS
603: SELECT rowid, inv.*
604: FROM igs_fi_inv_int inv

Line 601: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)

597:
598: CURSOR cur_charges_not_fp(cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
599: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE,
600: cp_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
601: cp_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE)
602: IS
603: SELECT rowid, inv.*
604: FROM igs_fi_inv_int inv
605: WHERE person_id = cp_person_id AND

Line 621: CURSOR cur_charges_normal (cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

617:
618: -- cursor for getting all the charges records that can be applied
619: -- for various enabled fee types for a person across all the fee periods (which do not have error account)
620:
621: CURSOR cur_charges_normal (cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
622: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE )
623: IS
624: SELECT rowid, inv.*
625: FROM igs_fi_inv_int inv

Line 622: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE )

618: -- cursor for getting all the charges records that can be applied
619: -- for various enabled fee types for a person across all the fee periods (which do not have error account)
620:
621: CURSOR cur_charges_normal (cp_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
622: cp_person_id IN igs_fi_inv_int_all.person_id%TYPE )
623: IS
624: SELECT rowid, inv.*
625: FROM igs_fi_inv_int inv
626: WHERE person_id = cp_person_id AND

Line 679: l_charges_amount igs_fi_inv_int_all.invoice_amount_due%TYPE;

675: l_adl_app_rules cur_adl_app_rules%ROWTYPE;
676: l_charges_not_fp cur_charges_not_fp%ROWTYPE;
677: l_charges_normal cur_charges_normal%ROWTYPE;
678: -- table type variables
679: l_charges_amount igs_fi_inv_int_all.invoice_amount_due%TYPE;
680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;
681: l_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;
683: l_applications_rowid VARCHAR2(25); -- OUT NOCOPY parameter from the applications table Insert TBH

Line 681: l_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;

677: l_charges_normal cur_charges_normal%ROWTYPE;
678: -- table type variables
679: l_charges_amount igs_fi_inv_int_all.invoice_amount_due%TYPE;
680: l_credits_amount igs_fi_credits_all.unapplied_amount%TYPE;
681: l_invoice_amount_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
682: l_credits_unapplied_amount igs_fi_credits_all.unapplied_amount%TYPE;
683: l_applications_rowid VARCHAR2(25); -- OUT NOCOPY parameter from the applications table Insert TBH
684: l_rec_installed VARCHAR2(1); -- variable captures the value returned from the
685: -- function which checks AR is installed or not