APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on ICX_CAT_POPULATE_STATUS_PVT

Line 4527: -- Quotations: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus returns

4523: RAISE;
4524: END purgeInvalidReqTmpltLines;
4525:
4526: -- Purges invalid quotations
4527: -- Quotations: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus returns
4528: -- ICX_CAT_POPULATE_STATUS_PVT.INVALID_FOR_POPULATE i.e -1
4529: PROCEDURE purgeInvalidQuoteLines
4530: IS
4531:

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

4524: END purgeInvalidReqTmpltLines;
4525:
4526: -- Purges invalid quotations
4527: -- Quotations: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus returns
4528: -- ICX_CAT_POPULATE_STATUS_PVT.INVALID_FOR_POPULATE i.e -1
4529: PROCEDURE purgeInvalidQuoteLines
4530: IS
4531:
4532: ----- Start of declaring columns returned from the delete -----

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

4569: DELETE FROM icx_cat_items_ctx_hdrs_tlp hdrs
4570: WHERE hdrs.source_type = 'QUOTATION'
4571: AND (
4572: -- Quote lines that are invalid.
4573: ICX_CAT_POPULATE_STATUS_PVT.getQuoteLineStatus(hdrs.po_line_id) = -1
4574: OR
4575: -- Quote lines that are deleted.
4576: NOT EXISTS ( SELECT 'x' FROM po_lines_all pl
4577: WHERE hdrs.po_line_id = pl.po_line_id)