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_PAYMENT_PLANS dependencies on IGS_FI_PP_TEMPLATES

Line 33: g_v_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'MONTHLY';

29: g_v_ind_yes CONSTANT VARCHAR2(1) := 'Y';
30: g_v_ind_no CONSTANT VARCHAR2(1) := 'N';
31: g_v_planned CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'PLANNED';
32: g_v_active CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'ACTIVE';
33: g_v_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'MONTHLY';
34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';
35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:

Line 34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';

30: g_v_ind_no CONSTANT VARCHAR2(1) := 'N';
31: g_v_planned CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'PLANNED';
32: g_v_active CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'ACTIVE';
33: g_v_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'MONTHLY';
34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';
35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');

Line 35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';

31: g_v_planned CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'PLANNED';
32: g_v_active CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'ACTIVE';
33: g_v_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'MONTHLY';
34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';
35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');

Line 512: p_v_payment_plan_name IN igs_fi_pp_templates.payment_plan_name%TYPE,

508: END activate_plan;
509:
510: PROCEDURE assign_students(errbuf OUT NOCOPY VARCHAR2,
511: retcode OUT NOCOPY NUMBER,
512: p_v_payment_plan_name IN igs_fi_pp_templates.payment_plan_name%TYPE,
513: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
514: p_v_start_date IN VARCHAR2,
515: p_v_fee_period IN VARCHAR2
516: ) AS

Line 538: CURSOR cur_pmt_plan(cp_v_pmt_plan igs_fi_pp_templates.payment_plan_name%TYPE) IS

534: --Ref cursor variable.
535: l_cur_ref cur_ref;
536:
537: --Cursor for fetching the payment plan details.
538: CURSOR cur_pmt_plan(cp_v_pmt_plan igs_fi_pp_templates.payment_plan_name%TYPE) IS
539: SELECT *
540: FROM igs_fi_pp_templates
541: WHERE payment_plan_name = cp_v_pmt_plan
542: AND NVL(closed_flag,g_v_ind_no) = g_v_ind_no;

Line 540: FROM igs_fi_pp_templates

536:
537: --Cursor for fetching the payment plan details.
538: CURSOR cur_pmt_plan(cp_v_pmt_plan igs_fi_pp_templates.payment_plan_name%TYPE) IS
539: SELECT *
540: FROM igs_fi_pp_templates
541: WHERE payment_plan_name = cp_v_pmt_plan
542: AND NVL(closed_flag,g_v_ind_no) = g_v_ind_no;
543:
544: rec_cur_pmt_plan cur_pmt_plan%ROWTYPE;

Line 547: CURSOR cur_pp_lines(cp_v_pmt_plan igs_fi_pp_templates.payment_plan_name%TYPE) IS

543:
544: rec_cur_pmt_plan cur_pmt_plan%ROWTYPE;
545:
546: --Cursor for fetching all the installment lines for the payment plan passed as input.
547: CURSOR cur_pp_lines(cp_v_pmt_plan igs_fi_pp_templates.payment_plan_name%TYPE) IS
548: SELECT *
549: FROM igs_fi_pp_tmpl_lns
550: WHERE payment_plan_name = cp_v_pmt_plan;
551: