[Home] [Help]
31:
32: --gNumLanguages NUMBER;
33: NULL_ID NUMBER := -2;
34: g_R12_UPGRADE_USER NUMBER := PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER;
35: g_R12_MIGRATION_PROGRAM PO_HEADERS_ALL.last_updated_program%TYPE
36: := PO_R12_CAT_UPG_PVT.g_R12_MIGRATION_PROGRAM;
37:
38: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;
39:
376: NULL, -- Attribute
377: 'Y', -- Recreate Attrib Flag
378: 'Y' -- Recreate Attrib TLP Flag
379: FROM PO_LINES_ALL POL,
380: PO_HEADERS_ALL POH,
381: ICX_CAT_PURCHASING_CAT_MAP_V ICXM
382: WHERE POL.last_updated_program IS NULL
383: AND POL.po_header_id = POH.po_header_id
384: AND POH.type_lookup_code IN ('BLANKET', 'QUOTATION')
750: -- SQL Join: several
751: --
752: -- Assumption: Can we make the assumption or document that cst should not
753: -- change the base language ? if so then we can always use the base language
754: -- instead of joining with po_headers_all to get created_language.
755:
756: -- This sql#3 is used to create a default TLP row for the created_lang
757: -- (only for Blankets/Quotations), if:
758: -- 1. The created_lang is different from base_lang
791: g_R12_MIGRATION_PROGRAM, -- last_update_program
792: sysdate, -- last_update_date
793: g_R12_UPGRADE_USER, -- created_by
794: sysdate -- creation_date
795: FROM PO_HEADERS_ALL POH,
796: PO_LINES_ALL POL
797: --, PO_ATTRIBUTE_VALUES POAT
798: WHERE gPoLineIds(i) <> NULL_ID
799: AND gInvItemids(i) <> NULL_ID