APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on ICX_CAT_POPULATE_STATUS_PVT

Line 4502: -- Quotations: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus returns

4498: RAISE;
4499: END purgeInvalidReqTmpltLines;
4500:
4501: -- Purges invalid quotations
4502: -- Quotations: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus returns
4503: -- ICX_CAT_POPULATE_STATUS_PVT.INVALID_FOR_POPULATE i.e -1
4504: PROCEDURE purgeInvalidQuoteLines
4505: IS
4506:

Line 4503: -- ICX_CAT_POPULATE_STATUS_PVT.INVALID_FOR_POPULATE i.e -1

4499: END purgeInvalidReqTmpltLines;
4500:
4501: -- Purges invalid quotations
4502: -- Quotations: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus returns
4503: -- ICX_CAT_POPULATE_STATUS_PVT.INVALID_FOR_POPULATE i.e -1
4504: PROCEDURE purgeInvalidQuoteLines
4505: IS
4506:
4507: ----- Start of declaring columns returned from the delete -----

Line 4548: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus(hdrs.po_line_id) = -1

4544: DELETE FROM icx_cat_items_ctx_hdrs_tlp hdrs
4545: WHERE hdrs.source_type = 'QUOTATION'
4546: AND (
4547: -- Quote lines that are invalid.
4548: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus(hdrs.po_line_id) = -1
4549: OR
4550: -- Quote lines that are deleted.
4551: NOT EXISTS ( SELECT 'x' FROM po_lines_all pl
4552: WHERE hdrs.po_line_id = pl.po_line_id)