[Home] [Help]
144: AND ftci.fee_type_ci_status = fst.fee_structure_status
145: AND fst.s_fee_structure_status = g_v_active;
146:
147: l_v_manage_acc igs_fi_control.manage_accounts%TYPE := NULL;
148: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
149: l_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE := NULL;
150: l_n_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE := NULL;
151: l_d_due_dt igs_fi_pp_instlmnts.due_date%TYPE;
152:
574: TYPE temp_tbl_type IS TABLE OF temp_rec_type INDEX BY BINARY_INTEGER;
575: l_temp_plsql_tbl temp_tbl_type;
576:
577: l_v_manage_acc igs_fi_control.manage_accounts%TYPE := NULL;
578: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
579: l_v_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE := NULL;
580: l_n_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE := NULL;
581: l_b_valid_param BOOLEAN := TRUE;
582: l_b_planned_plan BOOLEAN := FALSE;
593: l_n_person_id igs_fi_parties_v.person_id%TYPE;
594: l_v_sql VARCHAR2(32767);
595: l_v_status VARCHAR2(1);
596: l_v_pers_status igs_lookup_values.meaning%TYPE;
597: l_v_pers_message fnd_new_messages.message_text%TYPE;
598:
599: l_n_count PLS_INTEGER;
600: l_n_cnt PLS_INTEGER;
601: l_n_months PLS_INTEGER;
1204: l_v_status VARCHAR2(1);
1205: l_v_var VARCHAR2(1);
1206: l_b_valid_param BOOLEAN := TRUE;
1207: l_v_manage_acc igs_fi_control.manage_accounts%TYPE := NULL;
1208: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
1209: l_n_person_id igs_fi_parties_v.person_id%TYPE;
1210:
1211: l_v_tol_thr CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TOLERANCE_THRESHOLD');
1212: l_v_test_mode CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE');