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.OKS_BILLING_PUB dependencies on QP_PREQ_GRP

Line 1527: p_modifier_details IN qp_preq_grp.line_detail_tbl_type,

1523: --skuchima 05-Jan-2012 Bug 13105205 Ceredian ER
1524: ----------------------------------------------------------------------------------------------------------
1525: Procedure Modifier_4_usg (
1526: p_bsl_id IN NUMBER,
1527: p_modifier_details IN qp_preq_grp.line_detail_tbl_type,
1528: x_return_status OUT NOCOPY VARCHAR2
1529: )
1530: IS
1531: l_api_name CONSTANT VARCHAR2 (30)

Line 1790: l_control_rec qp_preq_grp.control_record_type;

1786:
1787:
1788: g_module CONSTANT VARCHAR2 (250) := 'oks.plsql.BILLING.' || '.';
1789:
1790: l_control_rec qp_preq_grp.control_record_type;
1791: l_req_line_tbl qp_preq_grp.line_tbl_type;
1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

Line 1791: l_req_line_tbl qp_preq_grp.line_tbl_type;

1787:
1788: g_module CONSTANT VARCHAR2 (250) := 'oks.plsql.BILLING.' || '.';
1789:
1790: l_control_rec qp_preq_grp.control_record_type;
1791: l_req_line_tbl qp_preq_grp.line_tbl_type;
1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

Line 1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

1788: g_module CONSTANT VARCHAR2 (250) := 'oks.plsql.BILLING.' || '.';
1789:
1790: l_control_rec qp_preq_grp.control_record_type;
1791: l_req_line_tbl qp_preq_grp.line_tbl_type;
1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1796: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

1789:
1790: l_control_rec qp_preq_grp.control_record_type;
1791: l_req_line_tbl qp_preq_grp.line_tbl_type;
1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1796: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1797: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;

1790: l_control_rec qp_preq_grp.control_record_type;
1791: l_req_line_tbl qp_preq_grp.line_tbl_type;
1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1796: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1797: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1798:

Line 1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

1791: l_req_line_tbl qp_preq_grp.line_tbl_type;
1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1796: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1797: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1798:
1799: lx_return_status varchar2 (1);

Line 1796: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

1792: l_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1796: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1797: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1798:
1799: lx_return_status varchar2 (1);
1800: lx_return_status_text varchar2 (2000);

Line 1797: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

1793: l_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1794: l_req_qual_tbl qp_preq_grp.qual_tbl_type;
1795: l_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1796: l_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1797: l_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1798:
1799: lx_return_status varchar2 (1);
1800: lx_return_status_text varchar2 (2000);
1801:

Line 1805: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;

1801:
1802: l_price_break_tbl OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1803:
1804:
1805: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;

Line 1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;

1802: l_price_break_tbl OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1803:
1804:
1805: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
1810: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;

Line 1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;

1803:
1804:
1805: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
1810: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
1811: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;

Line 1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;

1804:
1805: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
1810: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
1811: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
1812: g_line_tbl_ctr NUMBER:=0;

Line 1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;

1805: g_req_line_tbl_blk qp_preq_grp.line_tbl_type;
1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
1810: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
1811: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
1812: g_line_tbl_ctr NUMBER:=0;
1813: g_qual_tbl_ctr NUMBER:=0;

Line 1810: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;

1806: g_req_line_detail_tbl_blk qp_preq_grp.line_detail_tbl_type;
1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
1810: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
1811: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
1812: g_line_tbl_ctr NUMBER:=0;
1813: g_qual_tbl_ctr NUMBER:=0;
1814: g_line_attr_tbl_ctr NUMBER:=0;

Line 1811: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;

1807: g_req_related_lines_tbl_blk qp_preq_grp.related_lines_tbl_type;
1808: g_req_qual_tbl_blk qp_preq_grp.qual_tbl_type;
1809: g_req_line_attr_tbl_blk qp_preq_grp.line_attr_tbl_type;
1810: g_req_line_detail_qual_tbl_blk qp_preq_grp.line_detail_qual_tbl_type;
1811: g_req_line_detail_attr_tbl_blk qp_preq_grp.line_detail_attr_tbl_type;
1812: g_line_tbl_ctr NUMBER:=0;
1813: g_qual_tbl_ctr NUMBER:=0;
1814: g_line_attr_tbl_ctr NUMBER:=0;
1815: g_line_detail_tbl_ctr NUMBER:=0;

Line 1818: gx_req_line_tbl qp_preq_grp.line_tbl_type;

1814: g_line_attr_tbl_ctr NUMBER:=0;
1815: g_line_detail_tbl_ctr NUMBER:=0;
1816: g_related_lines_tbl_ctr NUMBER:=0;
1817:
1818: gx_req_line_tbl qp_preq_grp.line_tbl_type;
1819: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

Line 1819: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;

1815: g_line_detail_tbl_ctr NUMBER:=0;
1816: g_related_lines_tbl_ctr NUMBER:=0;
1817:
1818: gx_req_line_tbl qp_preq_grp.line_tbl_type;
1819: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1823: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

Line 1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;

1816: g_related_lines_tbl_ctr NUMBER:=0;
1817:
1818: gx_req_line_tbl qp_preq_grp.line_tbl_type;
1819: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1823: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1824: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

Line 1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;

1817:
1818: gx_req_line_tbl qp_preq_grp.line_tbl_type;
1819: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1823: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1824: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1825:

Line 1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;

1818: gx_req_line_tbl qp_preq_grp.line_tbl_type;
1819: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1823: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1824: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1825:
1826: l_pbr_rec_in OKS_PBR_PVT.pbrv_rec_type;

Line 1823: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;

1819: gx_req_qual_tbl qp_preq_grp.qual_tbl_type;
1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1823: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1824: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1825:
1826: l_pbr_rec_in OKS_PBR_PVT.pbrv_rec_type;
1827: l_pbr_rec_out OKS_PBR_PVT.pbrv_rec_type;

Line 1824: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;

1820: gx_req_line_attr_tbl qp_preq_grp.line_attr_tbl_type;
1821: gx_req_line_detail_tbl qp_preq_grp.line_detail_tbl_type;
1822: gx_req_line_detail_qual_tbl qp_preq_grp.line_detail_qual_tbl_type;
1823: gx_req_line_detail_attr_tbl qp_preq_grp.line_detail_attr_tbl_type;
1824: gx_req_related_lines_tbl qp_preq_grp.related_lines_tbl_type;
1825:
1826: l_pbr_rec_in OKS_PBR_PVT.pbrv_rec_type;
1827: l_pbr_rec_out OKS_PBR_PVT.pbrv_rec_type;
1828:

Line 1831: x_modifier_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1827: l_pbr_rec_out OKS_PBR_PVT.pbrv_rec_type;
1828:
1829: x_return_status VARCHAR2(1);
1830: x_price_details OKS_QP_PKG.Price_Details ;
1831: x_modifier_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1832: x_price_break_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
1833: x_msg_data varchar2(1000);
1834: x_msg_count NUMBER;
1835:

Line 1867: p_req_line_tbl IN qp_preq_grp.line_tbl_type,

1863:
1864:
1865: /* skuchima procedure changes the single input to bulk input */
1866: PROCEDURE single_to_bulk_input(
1867: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
1868: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,

Line 1868: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,

1864:
1865: /* skuchima procedure changes the single input to bulk input */
1866: PROCEDURE single_to_bulk_input(
1867: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
1868: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
1872: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,

Line 1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,

1865: /* skuchima procedure changes the single input to bulk input */
1866: PROCEDURE single_to_bulk_input(
1867: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
1868: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
1872: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
1873: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,

Line 1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,

1866: PROCEDURE single_to_bulk_input(
1867: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
1868: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
1872: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
1873: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
1874: p_visit_cnt IN number

Line 1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,

1867: p_req_line_tbl IN qp_preq_grp.line_tbl_type,
1868: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
1872: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
1873: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
1874: p_visit_cnt IN number
1875: )IS

Line 1872: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,

1868: p_req_qual_tbl IN qp_preq_grp.qual_tbl_type,
1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
1872: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
1873: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
1874: p_visit_cnt IN number
1875: )IS
1876:

Line 1873: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,

1869: p_req_line_attr_tbl IN qp_preq_grp.line_attr_tbl_type,
1870: p_req_line_detail_tbl IN qp_preq_grp.line_detail_tbl_type,
1871: p_req_line_detail_qual_tbl IN qp_preq_grp.line_detail_qual_tbl_type,
1872: p_req_line_detail_attr_tbl IN qp_preq_grp.line_detail_attr_tbl_type,
1873: p_req_related_lines_tbl IN qp_preq_grp.related_lines_tbl_type,
1874: p_visit_cnt IN number
1875: )IS
1876:
1877: p NUMBER;

Line 3099: IF NVL (gx_req_line_tbl(bsl_index).status_code, qp_preq_grp.g_status_new) NOT IN

3095: l_price_break_tbl.DELETE;
3096: l_amount:= bsl_rec.amount;
3097: l_PROD_EXT_AMOUNT:=0;
3098:
3099: IF NVL (gx_req_line_tbl(bsl_index).status_code, qp_preq_grp.g_status_new) NOT IN
3100: (qp_preq_grp.g_status_updated,
3101: qp_preq_grp.g_status_system_generated,
3102: qp_preq_grp.g_by_engine,
3103: qp_preq_grp.g_status_unchanged,

Line 3100: (qp_preq_grp.g_status_updated,

3096: l_amount:= bsl_rec.amount;
3097: l_PROD_EXT_AMOUNT:=0;
3098:
3099: IF NVL (gx_req_line_tbl(bsl_index).status_code, qp_preq_grp.g_status_new) NOT IN
3100: (qp_preq_grp.g_status_updated,
3101: qp_preq_grp.g_status_system_generated,
3102: qp_preq_grp.g_by_engine,
3103: qp_preq_grp.g_status_unchanged,
3104: qp_preq_grp.g_status_new

Line 3101: qp_preq_grp.g_status_system_generated,

3097: l_PROD_EXT_AMOUNT:=0;
3098:
3099: IF NVL (gx_req_line_tbl(bsl_index).status_code, qp_preq_grp.g_status_new) NOT IN
3100: (qp_preq_grp.g_status_updated,
3101: qp_preq_grp.g_status_system_generated,
3102: qp_preq_grp.g_by_engine,
3103: qp_preq_grp.g_status_unchanged,
3104: qp_preq_grp.g_status_new
3105: )

Line 3102: qp_preq_grp.g_by_engine,

3098:
3099: IF NVL (gx_req_line_tbl(bsl_index).status_code, qp_preq_grp.g_status_new) NOT IN
3100: (qp_preq_grp.g_status_updated,
3101: qp_preq_grp.g_status_system_generated,
3102: qp_preq_grp.g_by_engine,
3103: qp_preq_grp.g_status_unchanged,
3104: qp_preq_grp.g_status_new
3105: )
3106: THEN

Line 3103: qp_preq_grp.g_status_unchanged,

3099: IF NVL (gx_req_line_tbl(bsl_index).status_code, qp_preq_grp.g_status_new) NOT IN
3100: (qp_preq_grp.g_status_updated,
3101: qp_preq_grp.g_status_system_generated,
3102: qp_preq_grp.g_by_engine,
3103: qp_preq_grp.g_status_unchanged,
3104: qp_preq_grp.g_status_new
3105: )
3106: THEN
3107:

Line 3104: qp_preq_grp.g_status_new

3100: (qp_preq_grp.g_status_updated,
3101: qp_preq_grp.g_status_system_generated,
3102: qp_preq_grp.g_by_engine,
3103: qp_preq_grp.g_status_unchanged,
3104: qp_preq_grp.g_status_new
3105: )
3106: THEN
3107:
3108: l_msg_data:=gx_req_line_tbl(bsl_index).status_text;

Line 3168: IF gx_req_related_lines_tbl (l_top_ctr).relationship_type_code = qp_preq_grp.g_pbh_line AND

3164:
3165: IF l_top_ctr IS NOT NULL THEN
3166: LOOP
3167:
3168: IF gx_req_related_lines_tbl (l_top_ctr).relationship_type_code = qp_preq_grp.g_pbh_line AND
3169: gx_req_related_lines_tbl(l_top_ctr).line_index = bsl_index THEN
3170:
3171:
3172: