DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_REQEXPRESS_HEADERS_ALL

Line 1917: -- express_name in po_reqexpress_headers_all cannot be changed once created.

1913: -- which cannnot be changed once created, so donot need to remove the row
1914: -- Source for BPA/GBPA/Quotation: Agreement/Quotation .
1915: -- segment1 in po_headers cannot be changed
1916: -- Source for req templates: express_name.
1917: -- express_name in po_reqexpress_headers_all cannot be changed once created.
1918: IF (p_current_ctx_item_rec.ctx_ip_category_id <> p_current_ctx_item_rec.ip_category_id) THEN
1919: l_err_loc := 1600;
1920: -- Re-populate the row with sequence = 1 and 6 i.e. mandatory row and shopping_category row
1921: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4400: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,

4396: WHERE hdrs.source_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
4397: AND (
4398: -- Req template lines that are invalid.
4399: EXISTS ( SELECT 'x'
4400: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,
4401: po_lines_all pl, po_headers_all ph
4402: WHERE hdrs.po_line_id = -2
4403: AND hdrs.inventory_item_id = nvl(prl.item_id, -2)
4404: AND hdrs.req_template_name = prl.express_name