APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_BALANCE_RULES

Line 86: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;

82: --cursor variable
83: l_person_rec c_person%ROWTYPE;
84:
85: -- package variables - OUT NOCOPY variables from finp_get_balance_rule()
86: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
87:
88: -- Flag to indicate that a hold for a person has been skipped due to
89: -- some validation failure to continue with the next hold
90: -- g_b_hold_skipped = TRUE even if one hold for a person is skipped

Line 817: process_start_dt cannot be before the last_conversion_date from igs_fi_balance_rules

813: pathipat 04-OCT-2002 Enh Bug:2562745
814: 1. Added check to see if balance rule is defined for 'HOLDS', else
815: stop further processing.
816: 2. Also, when the hold plan is determined at 'ACcount' level, then the
817: process_start_dt cannot be before the last_conversion_date from igs_fi_balance_rules
818: 3. In check between process_start_date and process_end_date, it was made > in place of
819: >= .
820: sykrishn 30/APR/2002 c_fee_type cursor changed to compare with fee structure system status
821: bug 2348883

Line 858: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;

854: l_person_group_id_rec c_person_group_id%ROWTYPE;
855: l_hold_plan_name_rec c_hold_plan_name%ROWTYPE;
856: l_fee_type_rec c_fee_type%ROWTYPE;
857:
858: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
859: l_version_number igs_fi_balance_rules.version_number%TYPE;
860:
861: BEGIN
862: --Check for mandatory parameters

Line 859: l_version_number igs_fi_balance_rules.version_number%TYPE;

855: l_hold_plan_name_rec c_hold_plan_name%ROWTYPE;
856: l_fee_type_rec c_fee_type%ROWTYPE;
857:
858: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
859: l_version_number igs_fi_balance_rules.version_number%TYPE;
860:
861: BEGIN
862: --Check for mandatory parameters
863: IF p_process_start_date IS NULL THEN

Line 2282: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;

2278: l_msg_str_1 VARCHAR2(1000);
2279: l_count PLS_INTEGER :=0;
2280:
2281: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
2282: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
2283: l_version_number igs_fi_balance_rules.version_number%TYPE;
2284:
2285: l_n_total_count PLS_INTEGER := 0;
2286:

Line 2283: l_version_number igs_fi_balance_rules.version_number%TYPE;

2279: l_count PLS_INTEGER :=0;
2280:
2281: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
2282: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
2283: l_version_number igs_fi_balance_rules.version_number%TYPE;
2284:
2285: l_n_total_count PLS_INTEGER := 0;
2286:
2287: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;

Line 2683: l_d_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE := NULL;

2679: WHERE credit_id = cp_release_credit_id;
2680:
2681: l_rec_active_holds cur_active_holds%ROWTYPE;
2682: l_v_credit_number igs_fi_credits_all.credit_number%TYPE := NULL;
2683: l_d_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE := NULL;
2684: l_n_version_number igs_fi_balance_rules.version_number%TYPE := NULL;
2685: l_n_release PLS_INTEGER := 0;
2686: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
2687:

Line 2684: l_n_version_number igs_fi_balance_rules.version_number%TYPE := NULL;

2680:
2681: l_rec_active_holds cur_active_holds%ROWTYPE;
2682: l_v_credit_number igs_fi_credits_all.credit_number%TYPE := NULL;
2683: l_d_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE := NULL;
2684: l_n_version_number igs_fi_balance_rules.version_number%TYPE := NULL;
2685: l_n_release PLS_INTEGER := 0;
2686: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
2687:
2688: BEGIN