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_DEPOSITS_PRCSS dependencies on IGS_FI_CR_TYPES

Line 83: FROM igs_fi_cr_types

79: AND status = g_cleared;
80:
81: CURSOR cur_fi_cr_types (cp_credit_type_id NUMBER ) IS
82: SELECT *
83: FROM igs_fi_cr_types
84: WHERE credit_type_id = cp_credit_type_id;
85:
86: l_cur_fi_credits cur_fi_credits%ROWTYPE;
87: l_cur_fi_cr_types cur_fi_cr_types%ROWTYPE;

Line 90: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;

86: l_cur_fi_credits cur_fi_credits%ROWTYPE;
87: l_cur_fi_cr_types cur_fi_cr_types%ROWTYPE;
88: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
89: l_rowid ROWID := NULL;
90: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
91: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
92: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
93: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
94:

Line 91: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;

87: l_cur_fi_cr_types cur_fi_cr_types%ROWTYPE;
88: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
89: l_rowid ROWID := NULL;
90: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
91: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
92: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
93: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
94:
95: BEGIN

Line 92: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;

88: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
89: l_rowid ROWID := NULL;
90: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
91: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
92: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
93: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
94:
95: BEGIN
96:

Line 93: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;

89: l_rowid ROWID := NULL;
90: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
91: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
92: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
93: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
94:
95: BEGIN
96:
97: -- Check if mandatory parameters are specified

Line 276: CURSOR cur_fi_cr_types (cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE) IS

272: FROM igs_fi_credits
273: WHERE party_id = cp_party_id
274: AND credit_number = cp_receipt_number;
275:
276: CURSOR cur_fi_cr_types (cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE) IS
277: SELECT *
278: FROM igs_fi_cr_types
279: WHERE credit_type_id = cp_credit_type_id;
280:

Line 278: FROM igs_fi_cr_types

274: AND credit_number = cp_receipt_number;
275:
276: CURSOR cur_fi_cr_types (cp_credit_type_id IN igs_fi_cr_types.credit_type_id%TYPE) IS
277: SELECT *
278: FROM igs_fi_cr_types
279: WHERE credit_type_id = cp_credit_type_id;
280:
281: --Cursor for identifying the Payment Plan installment application records.
282: CURSOR cur_insts(cp_n_credit_id igs_fi_credits.credit_id%TYPE,

Line 798: FROM igs_fi_cr_types

794:
795: -- Cursor to obtain the debit account info for the new credit created
796: CURSOR cur_account_info (cp_credit_type_id IN NUMBER) IS
797: SELECT cr_account_cd, cr_gl_ccid
798: FROM igs_fi_cr_types
799: WHERE credit_type_id = cp_credit_type_id;
800:
801: l_cur_fi_credits cur_fi_credits%ROWTYPE;
802: l_cur_dr_account_info cur_account_info%ROWTYPE;

Line 808: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;

804: l_rowid VARCHAR2(25) := NULL;
805: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
806: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
807: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
808: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
809: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
810: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
811: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
812: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;

Line 809: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;

805: l_n_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE := NULL;
806: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
807: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
808: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
809: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
810: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
811: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
812: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
813: l_n_conv_prc_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;

Line 810: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;

806: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
807: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
808: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
809: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
810: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
811: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
812: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
813: l_n_conv_prc_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
814:

Line 811: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;

807: l_v_credit_number igs_fi_credits_all.credit_number%TYPE;
808: l_n_dr_gl_ccid igs_fi_cr_types.dr_gl_ccid%TYPE;
809: l_n_cr_gl_ccid igs_fi_cr_types.cr_gl_ccid%TYPE;
810: l_v_dr_account_cd igs_fi_cr_types.dr_account_cd%TYPE;
811: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
812: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
813: l_n_conv_prc_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
814:
815: l_n_pay_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;

Line 815: l_n_pay_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;

811: l_v_cr_account_cd igs_fi_cr_types.cr_account_cd%TYPE;
812: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
813: l_n_conv_prc_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
814:
815: l_n_pay_credit_type_id igs_fi_cr_types_all.credit_type_id%TYPE;
816: l_b_return_status BOOLEAN;
817:
818: BEGIN
819: