218: rec_no number;
219: l_cnt number:= 0;
220: l_outputs ff_exec.outputs_t;
221: l_param_tab ff_exec.outputs_t;
222: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
223: --
224: -- Declare local procedure
225: --
226: Procedure populate_param_tab
530: p_rate OUT nocopy number)
531: is
532: --
533: l_elig_rates ben_evaluate_rate_matrix.rate_tab;
534: l_pref_rate pqh_rate_matrix_rates_f.rate_value%type;
535: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type;
536: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type;
537: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type;
538: --
531: is
532: --
533: l_elig_rates ben_evaluate_rate_matrix.rate_tab;
534: l_pref_rate pqh_rate_matrix_rates_f.rate_value%type;
535: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type;
536: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type;
537: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type;
538: --
539: l_rate_factors g_rbc_factor_tbl;
532: --
533: l_elig_rates ben_evaluate_rate_matrix.rate_tab;
534: l_pref_rate pqh_rate_matrix_rates_f.rate_value%type;
535: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type;
536: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type;
537: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type;
538: --
539: l_rate_factors g_rbc_factor_tbl;
540: l_rate_factor_cnt number := 0;
533: l_elig_rates ben_evaluate_rate_matrix.rate_tab;
534: l_pref_rate pqh_rate_matrix_rates_f.rate_value%type;
535: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type;
536: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type;
537: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type;
538: --
539: l_rate_factors g_rbc_factor_tbl;
540: l_rate_factor_cnt number := 0;
541:
786: l_uom pqh_criteria_rate_defn.uom%type;
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
789: --
790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
792: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
793: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
794: --
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
789: --
790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
792: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
793: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
794: --
795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
789: --
790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
792: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
793: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
794: --
795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
789: --
790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
792: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
793: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
794: --
795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
792: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
793: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
794: --
795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
792: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
793: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
794: --
795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
793: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
794: --
795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
794: --
795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
1770: p_business_group_id IN number,
1771: p_effective_date IN date)
1772: return number is
1773: --
1774: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1775: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1776: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1777: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1778: --
1771: p_effective_date IN date)
1772: return number is
1773: --
1774: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1775: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1776: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1777: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1778: --
1779: l_rate_factors g_rbc_factor_tbl;
1772: return number is
1773: --
1774: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1775: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1776: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1777: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1778: --
1779: l_rate_factors g_rbc_factor_tbl;
1780: l_rate_factor_cnt number := 0;
1773: --
1774: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1775: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1776: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1777: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1778: --
1779: l_rate_factors g_rbc_factor_tbl;
1780: l_rate_factor_cnt number := 0;
1781: --
1815: p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl,
1816: p_effective_date IN date)
1817: return number is
1818: --
1819: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1820: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1821: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1822: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1823: --
1816: p_effective_date IN date)
1817: return number is
1818: --
1819: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1820: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1821: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1822: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1823: --
1824: l_rate_factors g_rbc_factor_tbl;
1817: return number is
1818: --
1819: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1820: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1821: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1822: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1823: --
1824: l_rate_factors g_rbc_factor_tbl;
1825: l_rate_factor_cnt number := 0;
1818: --
1819: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1820: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1821: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1822: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1823: --
1824: l_rate_factors g_rbc_factor_tbl;
1825: l_rate_factor_cnt number := 0;
1826: --
1858: p_business_group_id IN number,
1859: p_effective_date IN date)
1860: return number is
1861: --
1862: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1863: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1864: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1865: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1866: --
1859: p_effective_date IN date)
1860: return number is
1861: --
1862: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1863: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1864: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1865: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1866: --
1867: l_rate_factors g_rbc_factor_tbl;
1860: return number is
1861: --
1862: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1863: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1864: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1865: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1866: --
1867: l_rate_factors g_rbc_factor_tbl;
1868: l_rate_factor_cnt number := 0;
1861: --
1862: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1863: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1864: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1865: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1866: --
1867: l_rate_factors g_rbc_factor_tbl;
1868: l_rate_factor_cnt number := 0;
1869: --
1899: p_effective_date IN date,
1900: p_element_type_id IN number)
1901: return number is
1902: --
1903: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1904: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1905: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1906: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1907: --
1900: p_element_type_id IN number)
1901: return number is
1902: --
1903: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1904: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1905: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1906: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1907: --
1908: l_rate_factors g_rbc_factor_tbl;
1901: return number is
1902: --
1903: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1904: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1905: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1906: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1907: --
1908: l_rate_factors g_rbc_factor_tbl;
1909: l_rate_factor_cnt number := 0;
1902: --
1903: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
1904: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
1905: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
1906: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
1907: --
1908: l_rate_factors g_rbc_factor_tbl;
1909: l_rate_factor_cnt number := 0;
1910: --