APPS.IGS_FI_PRC_FIN_LT_CHG dependencies on IGS_FI_CREDITS

Line 423: FROM igs_fi_credits cdt,

419: -- (reverse chronological order - newest change first)
420: -------------------------------------------------------------------------------
421: CURSOR c_credits IS
422: SELECT credit_id, amount, effective_date
423: FROM igs_fi_credits cdt,
424: igs_fi_cr_types cty
425: WHERE TRUNC(effective_date)
426: BETWEEN TRUNC(p_bal_start_dt) AND TRUNC(p_bal_end_dt)
427: AND party_id = p_person_id

Line 445: l_n_planned_credit igs_fi_credits.amount%TYPE := 0;

441: -- Changes due to SFCR018
442: -- Call the local function to get the value of planned_credits_ind
443: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
444: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;
445: l_n_planned_credit igs_fi_credits.amount%TYPE := 0;
446: -- Changes due to SFCR018
447:
448: l_b_success_flag BOOLEAN; -- For bug 2690024
449:

Line 569: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,

565: p_charge_amount IN igs_fi_balances.standard_balance%TYPE,
566: p_chg_crtn_dt IN DATE,
567: p_cal_type IN igs_fi_f_typ_ca_inst_v.fee_cal_type%TYPE,
568: p_sequence_number IN igs_fi_f_typ_ca_inst_v.fee_ci_sequence_number%TYPE,
569: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
570: p_n_std_plan_id IN igs_fi_pp_std_attrs.student_plan_id%TYPE,
571: p_d_inst_due_date IN igs_fi_pp_instlmnts.due_date%TYPE,
572: p_b_chrg_flag OUT NOCOPY BOOLEAN
573: )AS

Line 1266: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,

1262: p_test_flag IN VARCHAR2,
1263: p_cur_plan IN cur_plan%ROWTYPE,
1264: p_cal_type IN igs_fi_f_typ_ca_inst_v.fee_cal_type%TYPE,
1265: p_sequence_number IN igs_fi_f_typ_ca_inst_v.fee_ci_sequence_number%TYPE,
1266: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
1267: p_n_std_plan_id IN PLS_INTEGER
1268: ) AS
1269: /***********************************************************************************************
1270:

Line 1298: l_n_planned_credit igs_fi_credits.amount%TYPE := 0;

1294: -- Changes due to SFCR018
1295: -- Call the local function to get the value of planned_credits_ind
1296: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
1297: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;
1298: l_n_planned_credit igs_fi_credits.amount%TYPE := 0;
1299: --changes due to Enh#2562745.
1300: l_message_name fnd_new_messages.message_name%TYPE;
1301: l_balance_amount igs_fi_balances.standard_balance%TYPE; --This variable ignored in the following call.
1302: l_d_eff_date DATE;

Line 1523: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;

1519: l_conv_process_run_ind igs_fi_control.conv_process_run_ind%TYPE;
1520: l_message_name fnd_new_messages.message_name%TYPE;
1521:
1522: l_v_closing_status gl_period_statuses.closing_status%TYPE;
1523: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;
1524: l_v_message_name fnd_new_messages.message_name%TYPE;
1525: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
1526:
1527: l_n_person_id igs_fi_parties_v.person_id%TYPE;