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.

APPS.PQH_RBC_RATE_RETRIEVAL dependencies on PQH_RATE_MATRIX_RATES_F

Line 222: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;

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

Line 534: l_pref_rate pqh_rate_matrix_rates_f.rate_value%type;

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: --

Line 535: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type;

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;

Line 536: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type;

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;

Line 537: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type;

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:

Line 790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;

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: --

Line 791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;

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;

Line 792: l_mid_rate pqh_rate_matrix_rates_f.mid_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;

Line 793: l_max_rate pqh_rate_matrix_rates_f.max_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;

Line 795: l_t_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;
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;

Line 796: l_t_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;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;

Line 797: l_t_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;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;

Line 798: l_t_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;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;

Line 1774: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;

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: --

Line 1775: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;

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;

Line 1776: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;

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;

Line 1777: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 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: --

Line 1819: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;

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: --

Line 1820: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;

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;

Line 1821: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;

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;

Line 1822: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 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: --

Line 1862: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;

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: --

Line 1863: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;

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;

Line 1864: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;

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;

Line 1865: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 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: --

Line 1903: l_rate pqh_rate_matrix_rates_f.rate_value%type := 0;

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: --

Line 1904: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;

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;

Line 1905: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;

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;

Line 1906: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 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: --