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

Line 46: Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler

42: numbers and names.
43: smadathi 28-Feb-2002 Bug. 2238413. modified mass _application procedure.
44: sarakshi 27-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
45: masehgal 17-Jan-2002 ENH # 2170429
46: Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
47: msrinivi 13 aug,2001 bug 1882122: Take only ch_lns with err_acc ='N'
48: sykrishn 28-JAN changes to mass application - sfcr020 - 2191470
49: ******************************************************************/
50:

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 161: CURSOR cur_invoice_number(cp_invoice_id igs_fi_inv_int.invoice_number%TYPE) IS

157: names in the log file instead of ids. bug#2326163.
158: ****************************************************************/
159:
160: --added by vvutukur for bug 2326163
161: CURSOR cur_invoice_number(cp_invoice_id igs_fi_inv_int.invoice_number%TYPE) IS
162: SELECT invoice_number
163: FROM igs_fi_inv_int
164: WHERE invoice_id = cp_invoice_id;
165:

Line 163: FROM igs_fi_inv_int

159:
160: --added by vvutukur for bug 2326163
161: CURSOR cur_invoice_number(cp_invoice_id igs_fi_inv_int.invoice_number%TYPE) IS
162: SELECT invoice_number
163: FROM igs_fi_inv_int
164: WHERE invoice_id = cp_invoice_id;
165:
166: CURSOR c_igs_fi_invln_int(cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
167: SELECT gl_date

Line 166: CURSOR c_igs_fi_invln_int(cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

162: SELECT invoice_number
163: FROM igs_fi_inv_int
164: WHERE invoice_id = cp_invoice_id;
165:
166: CURSOR c_igs_fi_invln_int(cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
167: SELECT gl_date
168: FROM igs_fi_invln_int
169: WHERE invoice_id = cp_n_invoice_id;
170:

Line 179: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;

175:
176: rec_c_igs_fi_invln_int c_igs_fi_invln_int%ROWTYPE;
177: rec_c_igs_fi_credits c_igs_fi_credits%ROWTYPE;
178:
179: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
180: l_dr_ccid_str VARCHAR2(230);
181: l_cr_ccid_str VARCHAR2(230);
182:
183: l_msg_str_2 VARCHAR2(2000);

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 582: FROM igs_fi_inv_int inv

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
584: fee_type = cp_fee_type AND
585: fee_cal_type = cp_fee_cal_type AND
586: fee_ci_sequence_number = cp_fee_ci_sequence_number 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 604: FROM igs_fi_inv_int inv

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
606: fee_type = cp_fee_type AND
607: (fee_cal_type <> cp_fee_cal_type OR
608: fee_ci_sequence_number <> cp_fee_ci_sequence_number) 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 625: FROM igs_fi_inv_int inv

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
627: fee_type = cp_fee_type AND
628: invoice_amount_due > 0
629: AND NOT EXISTS (SELECT 'X'

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