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.QP_QP_FORM_PRICING_ATTR dependencies on QP_LIST_LINES

Line 1632: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type

1628: FUNCTION Get_Charge_name
1629: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
1630: , p_Charge_Type_code IN QP_CHARGE_LOOKUP.lookup_code%type
1631: , p_Charge_Subtype_code IN QP_LOOKUPS.lookup_code%type
1632: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1633: )
1634: RETURN QP_LOOKUPS.Meaning%Type IS
1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;
1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');

Line 1735: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

1731:
1732: END Get_Formula;
1733:
1734: FUNCTION Get_Expiration_Date
1735: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1736: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1737: )
1738: RETURN QP_LIST_LINES.Expiration_Date%Type IS
1739: l_Expiration_Date QP_LIST_LINES.Expiration_Date%Type;

Line 1736: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1732: END Get_Formula;
1733:
1734: FUNCTION Get_Expiration_Date
1735: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1736: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1737: )
1738: RETURN QP_LIST_LINES.Expiration_Date%Type IS
1739: l_Expiration_Date QP_LIST_LINES.Expiration_Date%Type;
1740: BEGIN

Line 1738: RETURN QP_LIST_LINES.Expiration_Date%Type IS

1734: FUNCTION Get_Expiration_Date
1735: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1736: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1737: )
1738: RETURN QP_LIST_LINES.Expiration_Date%Type IS
1739: l_Expiration_Date QP_LIST_LINES.Expiration_Date%Type;
1740: BEGIN
1741:
1742: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Date,

Line 1739: l_Expiration_Date QP_LIST_LINES.Expiration_Date%Type;

1735: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1736: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1737: )
1738: RETURN QP_LIST_LINES.Expiration_Date%Type IS
1739: l_Expiration_Date QP_LIST_LINES.Expiration_Date%Type;
1740: BEGIN
1741:
1742: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Date,
1743: Null) into l_Expiration_Date from QP_LIST_LINES ql where

Line 1743: Null) into l_Expiration_Date from QP_LIST_LINES ql where

1739: l_Expiration_Date QP_LIST_LINES.Expiration_Date%Type;
1740: BEGIN
1741:
1742: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Date,
1743: Null) into l_Expiration_Date from QP_LIST_LINES ql where
1744: ql.list_line_id = p_list_line_id;
1745:
1746: RETURN l_Expiration_Date;
1747:

Line 1761: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

1757:
1758: END Get_Expiration_Date;
1759:
1760: FUNCTION Get_Exp_Period_Start_Date
1761: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1762: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1763: )
1764: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type IS
1765: l_Exp_Period_Start_Date QP_LIST_LINES.Expiration_Period_Start_Date%Type;

Line 1762: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1758: END Get_Expiration_Date;
1759:
1760: FUNCTION Get_Exp_Period_Start_Date
1761: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1762: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1763: )
1764: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type IS
1765: l_Exp_Period_Start_Date QP_LIST_LINES.Expiration_Period_Start_Date%Type;
1766: BEGIN

Line 1764: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type IS

1760: FUNCTION Get_Exp_Period_Start_Date
1761: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1762: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1763: )
1764: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type IS
1765: l_Exp_Period_Start_Date QP_LIST_LINES.Expiration_Period_Start_Date%Type;
1766: BEGIN
1767:
1768: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_Start_Date,

Line 1765: l_Exp_Period_Start_Date QP_LIST_LINES.Expiration_Period_Start_Date%Type;

1761: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1762: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1763: )
1764: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type IS
1765: l_Exp_Period_Start_Date QP_LIST_LINES.Expiration_Period_Start_Date%Type;
1766: BEGIN
1767:
1768: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_Start_Date,
1769: Null) into l_Exp_Period_Start_Date from QP_LIST_LINES ql where

Line 1769: Null) into l_Exp_Period_Start_Date from QP_LIST_LINES ql where

1765: l_Exp_Period_Start_Date QP_LIST_LINES.Expiration_Period_Start_Date%Type;
1766: BEGIN
1767:
1768: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_Start_Date,
1769: Null) into l_Exp_Period_Start_Date from QP_LIST_LINES ql where
1770: ql.list_line_id = p_list_line_id;
1771:
1772: RETURN l_Exp_Period_Start_Date;
1773:

Line 1787: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

1783:
1784: END Get_Exp_Period_Start_Date;
1785:
1786: FUNCTION Get_Number_Expiration_Periods
1787: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1788: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1789: )
1790: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type IS
1791: l_Number_Expiration_Periods QP_LIST_LINES.Number_Expiration_Periods%Type;

Line 1788: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1784: END Get_Exp_Period_Start_Date;
1785:
1786: FUNCTION Get_Number_Expiration_Periods
1787: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1788: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1789: )
1790: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type IS
1791: l_Number_Expiration_Periods QP_LIST_LINES.Number_Expiration_Periods%Type;
1792: BEGIN

Line 1790: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type IS

1786: FUNCTION Get_Number_Expiration_Periods
1787: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1788: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1789: )
1790: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type IS
1791: l_Number_Expiration_Periods QP_LIST_LINES.Number_Expiration_Periods%Type;
1792: BEGIN
1793:
1794: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Number_Expiration_Periods,

Line 1791: l_Number_Expiration_Periods QP_LIST_LINES.Number_Expiration_Periods%Type;

1787: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1788: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1789: )
1790: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type IS
1791: l_Number_Expiration_Periods QP_LIST_LINES.Number_Expiration_Periods%Type;
1792: BEGIN
1793:
1794: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Number_Expiration_Periods,
1795: Null) into l_Number_Expiration_Periods from QP_LIST_LINES ql where

Line 1795: Null) into l_Number_Expiration_Periods from QP_LIST_LINES ql where

1791: l_Number_Expiration_Periods QP_LIST_LINES.Number_Expiration_Periods%Type;
1792: BEGIN
1793:
1794: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Number_Expiration_Periods,
1795: Null) into l_Number_Expiration_Periods from QP_LIST_LINES ql where
1796: ql.list_line_id = p_list_line_id;
1797:
1798: RETURN l_Number_Expiration_Periods;
1799:

Line 1813: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

1809:
1810: END Get_Number_Expiration_Periods;
1811:
1812: FUNCTION Get_Expiration_Period_UOM
1813: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1814: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1815: )
1816: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type IS
1817: l_Expiration_Period_UOM QP_LIST_LINES.Expiration_Period_UOM%Type;

Line 1814: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1810: END Get_Number_Expiration_Periods;
1811:
1812: FUNCTION Get_Expiration_Period_UOM
1813: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1814: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1815: )
1816: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type IS
1817: l_Expiration_Period_UOM QP_LIST_LINES.Expiration_Period_UOM%Type;
1818: BEGIN

Line 1816: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type IS

1812: FUNCTION Get_Expiration_Period_UOM
1813: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1814: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1815: )
1816: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type IS
1817: l_Expiration_Period_UOM QP_LIST_LINES.Expiration_Period_UOM%Type;
1818: BEGIN
1819:
1820: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_UOM,

Line 1817: l_Expiration_Period_UOM QP_LIST_LINES.Expiration_Period_UOM%Type;

1813: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1814: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1815: )
1816: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type IS
1817: l_Expiration_Period_UOM QP_LIST_LINES.Expiration_Period_UOM%Type;
1818: BEGIN
1819:
1820: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_UOM,
1821: Null) into l_Expiration_Period_UOM from QP_LIST_LINES ql where

Line 1821: Null) into l_Expiration_Period_UOM from QP_LIST_LINES ql where

1817: l_Expiration_Period_UOM QP_LIST_LINES.Expiration_Period_UOM%Type;
1818: BEGIN
1819:
1820: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Expiration_Period_UOM,
1821: Null) into l_Expiration_Period_UOM from QP_LIST_LINES ql where
1822: ql.list_line_id = p_list_line_id;
1823:
1824: RETURN l_Expiration_Period_UOM;
1825:

Line 1840: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

1836: END Get_Expiration_Period_UOM;
1837:
1838: --changes for bug 1496839 to improve performance
1839: FUNCTION Get_Rebate_Txn_Type
1840: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1841: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1842: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1843: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
1844: )

Line 1841: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1837:
1838: --changes for bug 1496839 to improve performance
1839: FUNCTION Get_Rebate_Txn_Type
1840: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1841: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1842: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1843: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
1844: )
1845: RETURN QP_LOOKUPS.Meaning%Type IS

Line 1842: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type

1838: --changes for bug 1496839 to improve performance
1839: FUNCTION Get_Rebate_Txn_Type
1840: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1841: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1842: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1843: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
1844: )
1845: RETURN QP_LOOKUPS.Meaning%Type IS
1846: l_Rebate_Txn_Type QP_LOOKUPS.Meaning%Type;

Line 1843: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type

1839: FUNCTION Get_Rebate_Txn_Type
1840: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1841: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1842: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1843: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
1844: )
1845: RETURN QP_LOOKUPS.Meaning%Type IS
1846: l_Rebate_Txn_Type QP_LOOKUPS.Meaning%Type;
1847: BEGIN

Line 1858: l_Rebate_Txn_Type from QP_LIST_LINES ql, QP_LOOKUPS qlook where

1854:
1855: /*
1856: select decode(p_modifier_type_code, ql.list_line_type_code,
1857: qlook.meaning, Null) into
1858: l_Rebate_Txn_Type from QP_LIST_LINES ql, QP_LOOKUPS qlook where
1859: ql.list_line_id = p_list_line_id and
1860: qlook.lookup_code = ql.rebate_transaction_type_code;
1861: */
1862:

Line 1878: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

1874:
1875: END Get_Rebate_Txn_Type;
1876:
1877: FUNCTION Get_Benefit_Qty
1878: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1879: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1880: )
1881: RETURN QP_LIST_LINES.Benefit_Qty%Type IS
1882: l_Benefit_Qty QP_LIST_LINES.Benefit_Qty%Type;

Line 1879: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1875: END Get_Rebate_Txn_Type;
1876:
1877: FUNCTION Get_Benefit_Qty
1878: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1879: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1880: )
1881: RETURN QP_LIST_LINES.Benefit_Qty%Type IS
1882: l_Benefit_Qty QP_LIST_LINES.Benefit_Qty%Type;
1883: BEGIN

Line 1881: RETURN QP_LIST_LINES.Benefit_Qty%Type IS

1877: FUNCTION Get_Benefit_Qty
1878: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1879: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1880: )
1881: RETURN QP_LIST_LINES.Benefit_Qty%Type IS
1882: l_Benefit_Qty QP_LIST_LINES.Benefit_Qty%Type;
1883: BEGIN
1884:
1885: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_Qty,

Line 1882: l_Benefit_Qty QP_LIST_LINES.Benefit_Qty%Type;

1878: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1879: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1880: )
1881: RETURN QP_LIST_LINES.Benefit_Qty%Type IS
1882: l_Benefit_Qty QP_LIST_LINES.Benefit_Qty%Type;
1883: BEGIN
1884:
1885: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_Qty,
1886: Null) into l_Benefit_Qty from QP_LIST_LINES ql where

Line 1886: Null) into l_Benefit_Qty from QP_LIST_LINES ql where

1882: l_Benefit_Qty QP_LIST_LINES.Benefit_Qty%Type;
1883: BEGIN
1884:
1885: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_Qty,
1886: Null) into l_Benefit_Qty from QP_LIST_LINES ql where
1887: ql.list_line_id = p_list_line_id;
1888:
1889: RETURN l_Benefit_Qty;
1890:

Line 1904: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

1900:
1901: END Get_Benefit_Qty;
1902:
1903: FUNCTION Get_Benefit_UOM_Code
1904: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1905: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1906: )
1907: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type IS
1908: l_Benefit_UOM_Code QP_LIST_LINES.Benefit_UOM_Code%Type;

Line 1905: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1901: END Get_Benefit_Qty;
1902:
1903: FUNCTION Get_Benefit_UOM_Code
1904: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1905: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1906: )
1907: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type IS
1908: l_Benefit_UOM_Code QP_LIST_LINES.Benefit_UOM_Code%Type;
1909: BEGIN

Line 1907: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type IS

1903: FUNCTION Get_Benefit_UOM_Code
1904: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1905: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1906: )
1907: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type IS
1908: l_Benefit_UOM_Code QP_LIST_LINES.Benefit_UOM_Code%Type;
1909: BEGIN
1910:
1911: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_UOM_Code,

Line 1908: l_Benefit_UOM_Code QP_LIST_LINES.Benefit_UOM_Code%Type;

1904: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
1905: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1906: )
1907: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type IS
1908: l_Benefit_UOM_Code QP_LIST_LINES.Benefit_UOM_Code%Type;
1909: BEGIN
1910:
1911: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_UOM_Code,
1912: Null) into l_Benefit_UOM_Code from QP_LIST_LINES ql where

Line 1912: Null) into l_Benefit_UOM_Code from QP_LIST_LINES ql where

1908: l_Benefit_UOM_Code QP_LIST_LINES.Benefit_UOM_Code%Type;
1909: BEGIN
1910:
1911: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Benefit_UOM_Code,
1912: Null) into l_Benefit_UOM_Code from QP_LIST_LINES ql where
1913: ql.list_line_id = p_list_line_id;
1914:
1915: RETURN l_Benefit_UOM_Code;
1916:

Line 1930: (p_List_Line_Id IN QP_LIST_LINES.List_Line_ID%Type

1926:
1927: END Get_Benefit_UOM_Code;
1928:
1929: PROCEDURE Get_Rltd_Modifier_Flds
1930: (p_List_Line_Id IN QP_LIST_LINES.List_Line_ID%Type
1931: ,x_To_Rltd_Modifier_ID OUT NOCOPY /* file.sql.39 change */ NUMBER
1932: ,x_Rltd_Modifier_Grp_Type OUT NOCOPY /* file.sql.39 change */ NUMBER
1933: ,x_Rltd_Modifier_Grp_No OUT NOCOPY /* file.sql.39 change */ NUMBER
1934: ,x_Rltd_Modifier_ID OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1938: (p_List_Line_Id IN QP_LIST_LINES.List_Line_ID%Type

1934: ,x_Rltd_Modifier_ID OUT NOCOPY /* file.sql.39 change */ NUMBER
1935: );
1936:
1937: PROCEDURE Get_Rltd_Modifier_Flds
1938: (p_List_Line_Id IN QP_LIST_LINES.List_Line_ID%Type
1939: ,x_To_Rltd_Modifier_ID OUT NOCOPY /* file.sql.39 change */ NUMBER
1940: ,x_Rltd_Modifier_Grp_Type OUT NOCOPY /* file.sql.39 change */ NUMBER
1941: ,x_Rltd_Modifier_Grp_No OUT NOCOPY /* file.sql.39 change */ NUMBER
1942: ,x_Rltd_Modifier_ID OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1945: l_List_Line_Id QP_LIST_LINES.List_Line_ID%Type;

1941: ,x_Rltd_Modifier_Grp_No OUT NOCOPY /* file.sql.39 change */ NUMBER
1942: ,x_Rltd_Modifier_ID OUT NOCOPY /* file.sql.39 change */ NUMBER
1943: ) IS
1944:
1945: l_List_Line_Id QP_LIST_LINES.List_Line_ID%Type;
1946: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
1947: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
1948: l_Rltd_Modifier_Grp_No QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type;
1949: l_Rltd_Modifier_ID QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;

Line 1974: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type

1970:
1971: END Get_Rltd_Modifier_Flds;
1972:
1973: FUNCTION Get_To_Rltd_Modifier_ID
1974: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
1975: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1976: )
1977: RETURN QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type IS
1978: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;

Line 1975: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

1971: END Get_Rltd_Modifier_Flds;
1972:
1973: FUNCTION Get_To_Rltd_Modifier_ID
1974: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
1975: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1976: )
1977: RETURN QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type IS
1978: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
1979: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;

Line 2008: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type

2004:
2005: END Get_To_Rltd_Modifier_ID;
2006:
2007: FUNCTION Get_Rltd_Modifier_ID
2008: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2009: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2010: )
2011: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type IS
2012: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;

Line 2009: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2005: END Get_To_Rltd_Modifier_ID;
2006:
2007: FUNCTION Get_Rltd_Modifier_ID
2008: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2009: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2010: )
2011: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type IS
2012: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
2013: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;

Line 2042: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type

2038:
2039: END Get_Rltd_Modifier_ID;
2040:
2041: FUNCTION Get_Rltd_Modifier_Grp_Type
2042: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2043: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2044: )
2045: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type IS
2046: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;

Line 2043: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2039: END Get_Rltd_Modifier_ID;
2040:
2041: FUNCTION Get_Rltd_Modifier_Grp_Type
2042: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2043: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2044: )
2045: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type IS
2046: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
2047: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;

Line 2076: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type

2072:
2073: END Get_Rltd_Modifier_Grp_Type;
2074:
2075: FUNCTION Get_Rltd_Modifier_Grp_No
2076: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2077: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2078: )
2079: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type IS
2080: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;

Line 2077: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2073: END Get_Rltd_Modifier_Grp_Type;
2074:
2075: FUNCTION Get_Rltd_Modifier_Grp_No
2076: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2077: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2078: )
2079: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type IS
2080: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
2081: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;

Line 2111: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type

2107: END Get_Rltd_Modifier_Grp_No;
2108:
2109:
2110: FUNCTION Get_Benefit_list_Line_No
2111: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2112: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2113: )
2114: RETURN QP_LIST_LINES.List_Line_No%Type IS
2115: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;

Line 2112: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2108:
2109:
2110: FUNCTION Get_Benefit_list_Line_No
2111: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2112: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2113: )
2114: RETURN QP_LIST_LINES.List_Line_No%Type IS
2115: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
2116: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;

Line 2114: RETURN QP_LIST_LINES.List_Line_No%Type IS

2110: FUNCTION Get_Benefit_list_Line_No
2111: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
2112: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2113: )
2114: RETURN QP_LIST_LINES.List_Line_No%Type IS
2115: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
2116: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
2117: l_Rltd_Modifier_Grp_No QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type;
2118: l_Rltd_Modifier_ID QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;

Line 2119: l_Benefit_List_Line_No QP_LIST_LINES.List_Line_No%Type;

2115: l_To_Rltd_Modifier_ID QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
2116: l_Rltd_Modifier_Grp_Type QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
2117: l_Rltd_Modifier_Grp_No QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type;
2118: l_Rltd_Modifier_ID QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;
2119: l_Benefit_List_Line_No QP_LIST_LINES.List_Line_No%Type;
2120: BEGIN
2121:
2122: IF p_modifier_type_code = 'CIE' THEN
2123: --only for coupon issue

Line 2131: qp_list_lines where list_line_id = l_to_rltd_modifier_id;

2127: , l_Rltd_Modifier_Grp_No
2128: , l_Rltd_Modifier_ID);
2129:
2130: select list_line_no into l_benefit_list_line_no from
2131: qp_list_lines where list_line_id = l_to_rltd_modifier_id;
2132:
2133: END IF;
2134:
2135: RETURN l_benefit_list_line_no;

Line 2154: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2150:
2151: /*
2152: FUNCTION Get_Benefit_List_Line_No
2153: ( p_to_rltd_modifier_id IN QP_RLTD_MODIFIERS.to_rltd_modifier_id%type
2154: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2155: )
2156: RETURN QP_LIST_LINES.List_Line_No%Type IS
2157: l_Benefit_List_Line_No QP_LIST_LINES.List_Line_No%Type;
2158: BEGIN

Line 2156: RETURN QP_LIST_LINES.List_Line_No%Type IS

2152: FUNCTION Get_Benefit_List_Line_No
2153: ( p_to_rltd_modifier_id IN QP_RLTD_MODIFIERS.to_rltd_modifier_id%type
2154: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2155: )
2156: RETURN QP_LIST_LINES.List_Line_No%Type IS
2157: l_Benefit_List_Line_No QP_LIST_LINES.List_Line_No%Type;
2158: BEGIN
2159:
2160: select decode(p_modifier_type_code, ql.list_line_type_code, ql.List_Line_No,

Line 2157: l_Benefit_List_Line_No QP_LIST_LINES.List_Line_No%Type;

2153: ( p_to_rltd_modifier_id IN QP_RLTD_MODIFIERS.to_rltd_modifier_id%type
2154: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2155: )
2156: RETURN QP_LIST_LINES.List_Line_No%Type IS
2157: l_Benefit_List_Line_No QP_LIST_LINES.List_Line_No%Type;
2158: BEGIN
2159:
2160: select decode(p_modifier_type_code, ql.list_line_type_code, ql.List_Line_No,
2161: Null) into l_Benefit_List_Line_No from QP_LIST_LINES ql where

Line 2161: Null) into l_Benefit_List_Line_No from QP_LIST_LINES ql where

2157: l_Benefit_List_Line_No QP_LIST_LINES.List_Line_No%Type;
2158: BEGIN
2159:
2160: select decode(p_modifier_type_code, ql.list_line_type_code, ql.List_Line_No,
2161: Null) into l_Benefit_List_Line_No from QP_LIST_LINES ql where
2162: ql.list_line_id = p_to_rltd_modifier_id;
2163:
2164: RETURN l_Benefit_List_Line_No;
2165:

Line 2180: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

2176: END Get_Benefit_List_Line_No;
2177: */
2178:
2179: FUNCTION Get_Accrual_Flag
2180: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2181: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2182: )
2183: RETURN QP_LIST_LINES.Accrual_Flag%Type IS
2184: l_Accrual_Flag QP_LIST_LINES.Accrual_Flag%Type;

Line 2181: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2177: */
2178:
2179: FUNCTION Get_Accrual_Flag
2180: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2181: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2182: )
2183: RETURN QP_LIST_LINES.Accrual_Flag%Type IS
2184: l_Accrual_Flag QP_LIST_LINES.Accrual_Flag%Type;
2185: BEGIN

Line 2183: RETURN QP_LIST_LINES.Accrual_Flag%Type IS

2179: FUNCTION Get_Accrual_Flag
2180: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2181: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2182: )
2183: RETURN QP_LIST_LINES.Accrual_Flag%Type IS
2184: l_Accrual_Flag QP_LIST_LINES.Accrual_Flag%Type;
2185: BEGIN
2186:
2187: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Accrual_Flag,

Line 2184: l_Accrual_Flag QP_LIST_LINES.Accrual_Flag%Type;

2180: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2181: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2182: )
2183: RETURN QP_LIST_LINES.Accrual_Flag%Type IS
2184: l_Accrual_Flag QP_LIST_LINES.Accrual_Flag%Type;
2185: BEGIN
2186:
2187: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Accrual_Flag,
2188: Null) into l_Accrual_Flag from QP_LIST_LINES ql where

Line 2188: Null) into l_Accrual_Flag from QP_LIST_LINES ql where

2184: l_Accrual_Flag QP_LIST_LINES.Accrual_Flag%Type;
2185: BEGIN
2186:
2187: select decode(p_modifier_type_code, ql.list_line_type_code, ql.Accrual_Flag,
2188: Null) into l_Accrual_Flag from QP_LIST_LINES ql where
2189: ql.list_line_id = p_list_line_id;
2190:
2191: RETURN l_Accrual_Flag;
2192:

Line 2206: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

2202:
2203: END Get_Accrual_Flag;
2204:
2205: FUNCTION Get_Accrual_Conversion_Rate
2206: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2207: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2208: )
2209: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type IS
2210: l_Accrual_Conversion_Rate QP_LIST_LINES.Accrual_Conversion_Rate%Type;

Line 2207: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2203: END Get_Accrual_Flag;
2204:
2205: FUNCTION Get_Accrual_Conversion_Rate
2206: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2207: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2208: )
2209: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type IS
2210: l_Accrual_Conversion_Rate QP_LIST_LINES.Accrual_Conversion_Rate%Type;
2211: BEGIN

Line 2209: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type IS

2205: FUNCTION Get_Accrual_Conversion_Rate
2206: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2207: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2208: )
2209: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type IS
2210: l_Accrual_Conversion_Rate QP_LIST_LINES.Accrual_Conversion_Rate%Type;
2211: BEGIN
2212:
2213: select decode(p_modifier_type_code, ql.list_line_type_code,

Line 2210: l_Accrual_Conversion_Rate QP_LIST_LINES.Accrual_Conversion_Rate%Type;

2206: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2207: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2208: )
2209: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type IS
2210: l_Accrual_Conversion_Rate QP_LIST_LINES.Accrual_Conversion_Rate%Type;
2211: BEGIN
2212:
2213: select decode(p_modifier_type_code, ql.list_line_type_code,
2214: ql.Accrual_Conversion_Rate, Null) into l_Accrual_Conversion_Rate

Line 2215: from QP_LIST_LINES ql where ql.list_line_id = p_list_line_id;

2211: BEGIN
2212:
2213: select decode(p_modifier_type_code, ql.list_line_type_code,
2214: ql.Accrual_Conversion_Rate, Null) into l_Accrual_Conversion_Rate
2215: from QP_LIST_LINES ql where ql.list_line_id = p_list_line_id;
2216:
2217: RETURN l_Accrual_Conversion_Rate;
2218:
2219: EXCEPTION

Line 2232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

2228:
2229: END Get_Accrual_Conversion_Rate;
2230:
2231: FUNCTION Get_Estim_Accrual_Rate
2232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2234: )
2235: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type IS
2236: l_Estim_Accrual_Rate QP_LIST_LINES.Estim_Accrual_Rate%Type;

Line 2233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2229: END Get_Accrual_Conversion_Rate;
2230:
2231: FUNCTION Get_Estim_Accrual_Rate
2232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2234: )
2235: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type IS
2236: l_Estim_Accrual_Rate QP_LIST_LINES.Estim_Accrual_Rate%Type;
2237: BEGIN

Line 2235: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type IS

2231: FUNCTION Get_Estim_Accrual_Rate
2232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2234: )
2235: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type IS
2236: l_Estim_Accrual_Rate QP_LIST_LINES.Estim_Accrual_Rate%Type;
2237: BEGIN
2238:
2239: select decode(p_modifier_type_code, ql.list_line_type_code,

Line 2236: l_Estim_Accrual_Rate QP_LIST_LINES.Estim_Accrual_Rate%Type;

2232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2234: )
2235: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type IS
2236: l_Estim_Accrual_Rate QP_LIST_LINES.Estim_Accrual_Rate%Type;
2237: BEGIN
2238:
2239: select decode(p_modifier_type_code, ql.list_line_type_code,
2240: ql.Estim_Accrual_Rate, Null) into l_Estim_Accrual_Rate from

Line 2241: QP_LIST_LINES ql where ql.list_line_id = p_list_line_id;

2237: BEGIN
2238:
2239: select decode(p_modifier_type_code, ql.list_line_type_code,
2240: ql.Estim_Accrual_Rate, Null) into l_Estim_Accrual_Rate from
2241: QP_LIST_LINES ql where ql.list_line_id = p_list_line_id;
2242:
2243: RETURN l_Estim_Accrual_Rate;
2244:
2245: EXCEPTION

Line 2259: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

2255: END Get_Estim_Accrual_Rate;
2256:
2257: --changes for bug 1496839 to improve performance
2258: FUNCTION Get_Break_Line_Type_Code
2259: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2260: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2261: )
2262: RETURN QP_LIST_LINES.List_Line_Type_Code%Type IS
2263: l_Break_Line_Type_Code QP_LIST_LINES.List_Line_Type_Code%Type;

Line 2260: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2256:
2257: --changes for bug 1496839 to improve performance
2258: FUNCTION Get_Break_Line_Type_Code
2259: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2260: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2261: )
2262: RETURN QP_LIST_LINES.List_Line_Type_Code%Type IS
2263: l_Break_Line_Type_Code QP_LIST_LINES.List_Line_Type_Code%Type;
2264: BEGIN

Line 2262: RETURN QP_LIST_LINES.List_Line_Type_Code%Type IS

2258: FUNCTION Get_Break_Line_Type_Code
2259: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2260: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2261: )
2262: RETURN QP_LIST_LINES.List_Line_Type_Code%Type IS
2263: l_Break_Line_Type_Code QP_LIST_LINES.List_Line_Type_Code%Type;
2264: BEGIN
2265:
2266: IF p_modifier_type_code = 'PBH' then

Line 2263: l_Break_Line_Type_Code QP_LIST_LINES.List_Line_Type_Code%Type;

2259: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2260: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2261: )
2262: RETURN QP_LIST_LINES.List_Line_Type_Code%Type IS
2263: l_Break_Line_Type_Code QP_LIST_LINES.List_Line_Type_Code%Type;
2264: BEGIN
2265:
2266: IF p_modifier_type_code = 'PBH' then
2267:

Line 2269: from QP_LIST_LINES ql

2265:
2266: IF p_modifier_type_code = 'PBH' then
2267:
2268: select ql.list_line_type_code into l_Break_Line_Type_Code
2269: from QP_LIST_LINES ql
2270: where ql.list_line_id = (select to_rltd_modifier_id from
2271: qp_rltd_modifiers where from_rltd_modifier_id = p_list_line_id and
2272: rownum < 2);
2273:

Line 2296: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type

2292: END Get_Break_Line_Type_Code;
2293:
2294: --changes for bug 1496839 to improve performance
2295: FUNCTION Get_Break_Line_Type
2296: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2297: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2298: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
2299: )
2300: RETURN QP_LOOKUPS.Meaning%Type IS

Line 2297: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type

2293:
2294: --changes for bug 1496839 to improve performance
2295: FUNCTION Get_Break_Line_Type
2296: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2297: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2298: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
2299: )
2300: RETURN QP_LOOKUPS.Meaning%Type IS
2301: l_Break_Line_Type QP_LOOKUPS.Meaning%Type;

Line 2298: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type

2294: --changes for bug 1496839 to improve performance
2295: FUNCTION Get_Break_Line_Type
2296: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2297: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2298: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
2299: )
2300: RETURN QP_LOOKUPS.Meaning%Type IS
2301: l_Break_Line_Type QP_LOOKUPS.Meaning%Type;
2302: BEGIN

Line 2314: from QP_LIST_LINES ql, qp_lookups qlook

2310:
2311:
2312: /*
2313: select qlook.Meaning into l_Break_Line_Type
2314: from QP_LIST_LINES ql, qp_lookups qlook
2315: where qlook.lookup_code = ql.list_line_type_code and
2316: ql.list_line_id = (select to_rltd_modifier_id from
2317: qp_rltd_modifiers where from_rltd_modifier_id = p_list_line_id and
2318: rownum < 2);