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_REFUNDS dependencies on IGS_FI_CREDITS

Line 62: TYPE crdrec IS RECORD(credit_id IGS_FI_CREDITS.Credit_Id%TYPE,

58: e_resource_busy EXCEPTION;
59: PRAGMA EXCEPTION_INIT(e_resource_busy,-0054);
60:
61: -- PL/SQL record for the Credit Information
62: TYPE crdrec IS RECORD(credit_id IGS_FI_CREDITS.Credit_Id%TYPE,
63: credit_class IGS_FI_CR_TYPES.Credit_Class%TYPE,
64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,
65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
66: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,

Line 64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,

60:
61: -- PL/SQL record for the Credit Information
62: TYPE crdrec IS RECORD(credit_id IGS_FI_CREDITS.Credit_Id%TYPE,
63: credit_class IGS_FI_CR_TYPES.Credit_Class%TYPE,
64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,
65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
66: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
67: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE,
68: credit_number IGS_FI_CREDITS.Credit_Number%TYPE);

Line 68: credit_number IGS_FI_CREDITS.Credit_Number%TYPE);

64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,
65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
66: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
67: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE,
68: credit_number IGS_FI_CREDITS.Credit_Number%TYPE);
69:
70: -- PL/SQL table for storing the credit records which are to be processed for
71: -- refunds
72: TYPE crdtab IS TABLE OF crdrec

Line 252: FROM igs_fi_credits crd,

248: cp_status IN VARCHAR2) IS
249: SELECT crd.party_id,
250: crd.credit_type_id,
251: crd.effective_date
252: FROM igs_fi_credits crd,
253: igs_fi_cr_types crt
254: WHERE crd.credit_id = cp_credit_id
255: AND crd.credit_type_id = crt.credit_type_id
256: AND crd.status = cp_status

Line 267: FROM igs_fi_credits crd

263: SELECT CRD.PARTY_ID,
264: CRD.UNAPPLIED_AMOUNT,
265: CRD.FEE_CAL_TYPE,
266: CRD.FEE_CI_SEQUENCE_NUMBER
267: FROM igs_fi_credits crd
268: WHERE crd.credit_id = p_credit_id
269: AND crd.status = cp_status
270: FOR UPDATE NOWAIT;
271:

Line 274: cp_effective_date igs_fi_credits.effective_date%TYPE) IS

270: FOR UPDATE NOWAIT;
271:
272: -- Cursor for fetching the Application Hierarchy for the Credit Type
273: CURSOR cur_appl_hier(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
274: cp_effective_date igs_fi_credits.effective_date%TYPE) IS
275: SELECT 'x'
276: FROM igs_fi_a_hierarchies
277: WHERE credit_type_id = cp_credit_type_id
278: AND cp_effective_date BETWEEN effective_start_date AND NVL(effective_end_date,cp_effective_date);

Line 296: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
296: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
297: l_application_id igs_fi_applications.application_id%TYPE;
298: l_payee_id igs_fi_parties_v.person_id%TYPE;
299: l_reason fnd_new_messages.message_text%TYPE;
300: l_party_id igs_fi_parties_v.person_id%TYPE;

Line 303: l_effective_date igs_fi_credits.effective_date%TYPE;

299: l_reason fnd_new_messages.message_text%TYPE;
300: l_party_id igs_fi_parties_v.person_id%TYPE;
301: l_determination igs_lookups_view.lookup_code%TYPE;
302: l_credit_type_id igs_fi_cr_types.credit_type_id%TYPE;
303: l_effective_date igs_fi_credits.effective_date%TYPE;
304:
305: -- Varchar2 variables
306: l_err_msg VARCHAR2(2000);
307: l_var VARCHAR2(1);

Line 703: FROM igs_fi_credits crd,

699: -- Cursor for getting the Person Ids for which the Refunds have to be
700: -- processed if no person id given
701: CURSOR cur_party_all IS
702: SELECT DISTINCT crd.party_id person_id
703: FROM igs_fi_credits crd,
704: igs_fi_cr_types crt
705: WHERE crd.credit_type_id = crt.credit_type_id
706: AND crd.status = g_cleared
707: AND NVL(crt.refund_allowed,g_ind_no) = g_ind_yes

Line 721: cp_status igs_fi_credits.status%TYPE

717: AND fund.party_id = cp_person_id;
718:
719: -- Cursor for getting the credit records for the Person Id
720: CURSOR cur_crd(cp_person_id igs_fi_parties_v.person_id%TYPE,
721: cp_status igs_fi_credits.status%TYPE
722: ) IS
723: SELECT crd.*, crt.credit_class
724: FROM igs_fi_credits crd,
725: igs_fi_cr_types crt,

Line 724: FROM igs_fi_credits crd,

720: CURSOR cur_crd(cp_person_id igs_fi_parties_v.person_id%TYPE,
721: cp_status igs_fi_credits.status%TYPE
722: ) IS
723: SELECT crd.*, crt.credit_class
724: FROM igs_fi_credits crd,
725: igs_fi_cr_types crt,
726: igs_fi_cr_activities cra
727: WHERE crd.credit_type_id = crt.credit_type_id
728: AND crd.status = cp_status

Line 788: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
788: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
789: l_application_id igs_fi_applications.application_id%TYPE;
790: l_payee_id igs_fi_parties_v.person_id%TYPE;
791: l_reason fnd_new_messages.message_text%TYPE;
792: l_err_msg fnd_new_messages.message_name%TYPE;

Line 803: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;

799: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;
801: l_v_message_name fnd_new_messages.message_name%TYPE;
802: l_v_closing_status gl_period_statuses.closing_status%TYPE;
803: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;
804: l_n_party_id hz_parties.party_id%TYPE;
805: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
806:
807: -- Variables holding number type data