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.OKC_XPRT_IMPORT_VARIABLES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 100


      l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;

Line: 101


      l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted

Line: 105


      l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

Line: 119


      l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

Line: 127


      INSERT INTO cz_imp_devl_project
      (
       DEVL_PROJECT_ID,
       INTL_TEXT_ID,
       ORGANIZATION_ID,
       NAME,
       GSL_FILENAME,
       TOP_ITEM_ID,
       VERSION,
       EXPLOSION_TYPE,
       DESC_TEXT,
       ORIG_SYS_REF,
       CREATION_DATE,
       LAST_UPDATE_DATE,
       DELETED_FLAG,
       EFF_FROM,
       EFF_TO,
       CREATED_BY,
       LAST_UPDATED_BY,
       SECURITY_MASK,
       EFF_MASK,
       CHECKOUT_USER,
       RUN_ID,
       REC_STATUS,
       DISPOSITION,
       FSK_INTLTEXT_1_1,
       MODEL_ID,
       PLAN_LEVEL,
       PERSISTENT_PROJECT_ID,
       MODEL_TYPE,
       INVENTORY_ITEM_ID,
       PRODUCT_KEY,
       LAST_UPDATE_LOGIN,
       BOM_CAPTION_RULE_ID,
       NONBOM_CAPTION_RULE_ID,
       SEEDED_FLAG
      )
      VALUES
      (
      l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
      l_cz_imp_devl_project_rec.INTL_TEXT_ID,
      l_cz_imp_devl_project_rec.ORGANIZATION_ID,
      l_cz_imp_devl_project_rec.NAME,
      l_cz_imp_devl_project_rec.GSL_FILENAME,
      l_cz_imp_devl_project_rec.TOP_ITEM_ID,
      l_cz_imp_devl_project_rec.VERSION,
      l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
      l_cz_imp_devl_project_rec.DESC_TEXT,
      l_cz_imp_devl_project_rec.ORIG_SYS_REF,
      l_cz_imp_devl_project_rec.CREATION_DATE,
      l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
      l_cz_imp_devl_project_rec.DELETED_FLAG,
      l_cz_imp_devl_project_rec.EFF_FROM,
      l_cz_imp_devl_project_rec.EFF_TO,
      l_cz_imp_devl_project_rec.CREATED_BY,
      l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
      l_cz_imp_devl_project_rec.SECURITY_MASK,
      l_cz_imp_devl_project_rec.EFF_MASK,
      l_cz_imp_devl_project_rec.CHECKOUT_USER,
      l_cz_imp_devl_project_rec.RUN_ID,
      l_cz_imp_devl_project_rec.REC_STATUS,
      l_cz_imp_devl_project_rec.DISPOSITION,
      l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
      l_cz_imp_devl_project_rec.MODEL_ID,
      l_cz_imp_devl_project_rec.PLAN_LEVEL,
      l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
      l_cz_imp_devl_project_rec.MODEL_TYPE,
      l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
      l_cz_imp_devl_project_rec.PRODUCT_KEY,
      l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
      l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
      l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
      l_cz_imp_devl_project_rec.SEEDED_FLAG
      );

Line: 251


SELECT L.LANGUAGE_CODE
  FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');

Line: 286


            INSERT INTO CZ_IMP_LOCALIZED_TEXTS
            (
             LAST_UPDATE_LOGIN,
             LOCALE_ID,
             LOCALIZED_STR,
             INTL_TEXT_ID,
             CREATION_DATE,
             LAST_UPDATE_DATE,
             DELETED_FLAG,
             EFF_FROM,
             EFF_TO,
             CREATED_BY,
             LAST_UPDATED_BY,
             SECURITY_MASK,
             EFF_MASK,
             CHECKOUT_USER,
             LANGUAGE,
             ORIG_SYS_REF,
             SOURCE_LANG,
             RUN_ID,
             REC_STATUS,
             DISPOSITION,
             MODEL_ID,
             FSK_DEVLPROJECT_1_1,
             MESSAGE,
             SEEDED_FLAG
            )
            VALUES
            (
            FND_GLOBAL.LOGIN_ID,  --LAST_UPDATE_LOGIN
            NULL, -- LOCALE_ID
            l_model_component_name,  --LOCALIZED_STR
            NULL, -- INTL_TEXT_ID
            SYSDATE, -- CREATION_DATE
            SYSDATE, -- LAST_UPDATE_DATE
            '0', -- DELETED_FLAG
            NULL, -- EFF_FROM
            NULL, -- EFF_TO
            FND_GLOBAL.USER_ID, -- CREATED_BY
            FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
            NULL, -- SECURITY_MASK
            NULL, -- EFF_MASK
            NULL, -- CHECKOUT_USER
            l_language,  --LANGUAGE
            G_VARIABLE_MODEL_TOPNODE_OSR||p_intent, -- ORIG_SYS_REF
            USERENV('LANG'),  --SOURCE_LANG
            G_RUN_ID, -- RUN_ID
            NULL, -- REC_STATUS
            NULL, -- DISPOSITION
            NULL, -- MODEL_ID
            G_VARIABLE_MODEL_OSR||p_intent , -- FSK_DEVLPROJECT_1_1
            NULL, -- MESSAGE
            NULL -- SEEDED_FLAG
            );

Line: 380


      l_cz_imp_ps_nodes_rec.DELETED_FLAG :=  0;

Line: 394


      l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:=  SYSDATE;

Line: 396


      l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:=  FND_GLOBAL.USER_ID;

Line: 413


      l_cz_imp_ps_nodes_rec.MINIMUM_SELECTED:=  NULL;

Line: 414


      l_cz_imp_ps_nodes_rec.MAXIMUM_SELECTED:=  NULL;

Line: 431


      l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:=  FND_GLOBAL.LOGIN_ID;

Line: 440


      INSERT INTO cz_imp_ps_nodes
      (
      PS_NODE_ID,
      DEVL_PROJECT_ID,
      FROM_POPULATOR_ID,
      PROPERTY_BACKPTR,
      ITEM_TYPE_BACKPTR,
      INTL_TEXT_ID,
      SUB_CONS_ID,
      ORGANIZATION_ID,
      ITEM_ID,
      EXPLOSION_TYPE,
      NAME,
      ORIG_SYS_REF,
      RESOURCE_FLAG,
      TOP_ITEM_ID,
      INITIAL_VALUE,
      PARENT_ID,
      MINIMUM,
      MAXIMUM,
      PS_NODE_TYPE,
      FEATURE_TYPE,
      PRODUCT_FLAG,
      REFERENCE_ID,
      MULTI_CONFIG_FLAG,
      ORDER_SEQ_FLAG,
      SYSTEM_NODE_FLAG,
      TREE_SEQ,
      COUNTED_OPTIONS_FLAG,
      UI_OMIT,
      UI_SECTION,
      BOM_TREATMENT,
      RUN_ID,
      REC_STATUS,
      DISPOSITION,
      DELETED_FLAG ,
      EFF_FROM,
      EFF_TO,
      EFF_MASK,
      USER_STR01,
      USER_STR02,
      USER_STR03,
      USER_STR04,
      USER_NUM01,
      USER_NUM02,
      USER_NUM03,
      USER_NUM04,
      CHECKOUT_USER,
      CREATION_DATE,
      LAST_UPDATE_DATE,
      CREATED_BY,
      LAST_UPDATED_BY,
      SECURITY_MASK,
      FSK_INTLTEXT_1_1,
      FSK_INTLTEXT_1_EXT,
      FSK_ITEMMASTER_2_1,
      FSK_ITEMMASTER_2_EXT,
      FSK_PSNODE_3_1,
      FSK_PSNODE_3_EXT,
      FSK_PSNODE_4_1,
      FSK_PSNODE_4_EXT,
      FSK_DEVLPROJECT_5_1,
      FSK_DEVLPROJECT_5_EXT,
      COMPONENT_SEQUENCE_ID,
      COMPONENT_CODE,
      PLAN_LEVEL,
      BOM_ITEM_TYPE,
      SO_ITEM_TYPE_CODE,
      MINIMUM_SELECTED,
      MAXIMUM_SELECTED,
      BOM_REQUIRED,
      MUTUALLY_EXCLUSIVE_OPTIONS,
      OPTIONAL,
      FSK_EXPLNODE_1_1,
      FSK_PSNODE_6_1,
      EFFECTIVE_FROM,
      EFFECTIVE_UNTIL,
      EFFECTIVE_USAGE_MASK,
      EFFECTIVITY_SET_ID,
      FSK_EFFSET_7_1,
      DECIMAL_QTY_FLAG,
      QUOTEABLE_FLAG,
      PRIMARY_UOM_CODE,
      COMPONENT_SEQUENCE_PATH,
      BOM_SORT_ORDER,
      IB_TRACKABLE,
      LAST_UPDATE_LOGIN,
      INITIAL_NUM_VALUE,
      SRC_APPLICATION_ID,
      FSK_ITEMMASTER_2_2,
      INSTANTIABLE_FLAG,
      DISPLAY_IN_SUMMARY_FLAG
      )
      VALUES
      (
      l_cz_imp_ps_nodes_rec.PS_NODE_ID,
      l_cz_imp_ps_nodes_rec.DEVL_PROJECT_ID,
      l_cz_imp_ps_nodes_rec.FROM_POPULATOR_ID,
      l_cz_imp_ps_nodes_rec.PROPERTY_BACKPTR,
      l_cz_imp_ps_nodes_rec.ITEM_TYPE_BACKPTR,
      l_cz_imp_ps_nodes_rec.INTL_TEXT_ID,
      l_cz_imp_ps_nodes_rec.SUB_CONS_ID,
      l_cz_imp_ps_nodes_rec.ORGANIZATION_ID,
      l_cz_imp_ps_nodes_rec.ITEM_ID,
      l_cz_imp_ps_nodes_rec.EXPLOSION_TYPE,
      l_cz_imp_ps_nodes_rec.NAME,
      l_cz_imp_ps_nodes_rec.ORIG_SYS_REF,
      l_cz_imp_ps_nodes_rec.RESOURCE_FLAG,
      l_cz_imp_ps_nodes_rec.TOP_ITEM_ID,
      l_cz_imp_ps_nodes_rec.INITIAL_VALUE,
      l_cz_imp_ps_nodes_rec.PARENT_ID,
      l_cz_imp_ps_nodes_rec.MINIMUM,
      l_cz_imp_ps_nodes_rec.MAXIMUM,
      l_cz_imp_ps_nodes_rec.PS_NODE_TYPE,
      l_cz_imp_ps_nodes_rec.FEATURE_TYPE,
      l_cz_imp_ps_nodes_rec.PRODUCT_FLAG,
      l_cz_imp_ps_nodes_rec.REFERENCE_ID,
      l_cz_imp_ps_nodes_rec.MULTI_CONFIG_FLAG,
      l_cz_imp_ps_nodes_rec.ORDER_SEQ_FLAG,
      l_cz_imp_ps_nodes_rec.SYSTEM_NODE_FLAG,
      l_cz_imp_ps_nodes_rec.TREE_SEQ,
      l_cz_imp_ps_nodes_rec.COUNTED_OPTIONS_FLAG,
      l_cz_imp_ps_nodes_rec.UI_OMIT,
      l_cz_imp_ps_nodes_rec.UI_SECTION,
      l_cz_imp_ps_nodes_rec.BOM_TREATMENT,
      l_cz_imp_ps_nodes_rec.RUN_ID,
      l_cz_imp_ps_nodes_rec.REC_STATUS,
      l_cz_imp_ps_nodes_rec.DISPOSITION,
      l_cz_imp_ps_nodes_rec.DELETED_FLAG ,
      l_cz_imp_ps_nodes_rec.EFF_FROM,
      l_cz_imp_ps_nodes_rec.EFF_TO,
      l_cz_imp_ps_nodes_rec.EFF_MASK,
      l_cz_imp_ps_nodes_rec.USER_STR01,
      l_cz_imp_ps_nodes_rec.USER_STR02,
      l_cz_imp_ps_nodes_rec.USER_STR03,
      l_cz_imp_ps_nodes_rec.USER_STR04,
      l_cz_imp_ps_nodes_rec.USER_NUM01,
      l_cz_imp_ps_nodes_rec.USER_NUM02,
      l_cz_imp_ps_nodes_rec.USER_NUM03,
      l_cz_imp_ps_nodes_rec.USER_NUM04,
      l_cz_imp_ps_nodes_rec.CHECKOUT_USER,
      l_cz_imp_ps_nodes_rec.CREATION_DATE,
      l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE,
      l_cz_imp_ps_nodes_rec.CREATED_BY,
      l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY,
      l_cz_imp_ps_nodes_rec.SECURITY_MASK,
      l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1,
      l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT,
      l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_1,
      l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_EXT,
      l_cz_imp_ps_nodes_rec.FSK_PSNODE_3_1,
      l_cz_imp_ps_nodes_rec.FSK_PSNODE_3_EXT,
      l_cz_imp_ps_nodes_rec.FSK_PSNODE_4_1,
      l_cz_imp_ps_nodes_rec.FSK_PSNODE_4_EXT,
      l_cz_imp_ps_nodes_rec.FSK_DEVLPROJECT_5_1,
      l_cz_imp_ps_nodes_rec.FSK_DEVLPROJECT_5_EXT,
      l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_ID,
      l_cz_imp_ps_nodes_rec.COMPONENT_CODE,
      l_cz_imp_ps_nodes_rec.PLAN_LEVEL,
      l_cz_imp_ps_nodes_rec.BOM_ITEM_TYPE,
      l_cz_imp_ps_nodes_rec.SO_ITEM_TYPE_CODE,
      l_cz_imp_ps_nodes_rec.MINIMUM_SELECTED,
      l_cz_imp_ps_nodes_rec.MAXIMUM_SELECTED,
      l_cz_imp_ps_nodes_rec.BOM_REQUIRED,
      l_cz_imp_ps_nodes_rec.MUTUALLY_EXCLUSIVE_OPTIONS,
      l_cz_imp_ps_nodes_rec.OPTIONAL,
      l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1,
      l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1,
      l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM,
      l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL,
      l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK,
      l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID,
      l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1,
      l_cz_imp_ps_nodes_rec.DECIMAL_QTY_FLAG,
      l_cz_imp_ps_nodes_rec.QUOTEABLE_FLAG,
      l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE,
      l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH,
      l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER,
      l_cz_imp_ps_nodes_rec.IB_TRACKABLE,
      l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN,
      l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE,
      l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID,
      l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2,
      l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG,
      l_cz_imp_ps_nodes_rec.DISPLAY_IN_SUMMARY_FLAG
      );

Line: 681


SELECT distinct DECODE(SUBSTR(rcon.object_code,1,3),'OKC',rcon.object_code,'USER$' || rcon.object_code) variable_code, -- LHS of Condition
   t.variable_name variable_name,
   v.variable_datatype variable_datatype,
   t.LANGUAGE language,
   t.source_lang source_lang
FROM okc_xprt_rule_hdrs_all rhdr,
   okc_xprt_rule_conditions rcon,
   okc_bus_variables_b v,
   okc_bus_variables_tl t
WHERE rhdr.rule_id = rcon.rule_id
AND rhdr.intent = p_intent
AND rcon.object_type = 'VARIABLE'
AND rhdr.status_code NOT IN ('DRAFT','INACTIVE')
AND rcon.object_code = v.variable_code
AND v.variable_code = t.variable_code
AND t.LANGUAGE = USERENV('LANG')
--AND t.language = NVL(p_language,t.language)
UNION
SELECT distinct DECODE(SUBSTR(rcon.object_value_code,1,3),'OKC',rcon.object_value_code,'USER$' || rcon.object_value_code) variable_code, -- RHS of Condition
   t.variable_name variable_name,
   v.variable_datatype variable_datatype,
   t.LANGUAGE language,
   t.source_lang source_lang
FROM okc_xprt_rule_hdrs_all rhdr,
   okc_xprt_rule_conditions rcon,
   okc_bus_variables_b v,
   okc_bus_variables_tl t
WHERE rhdr.rule_id = rcon.rule_id
AND rhdr.intent = p_intent
AND rcon.object_value_type = 'VARIABLE'
AND rhdr.status_code NOT IN ('DRAFT','INACTIVE')
AND rcon.object_code = v.variable_code
AND v.variable_code = t.variable_code
AND t.LANGUAGE = USERENV('LANG')
--AND t.language = NVL(p_language,t.language)
UNION
SELECT distinct 'CONSTANT$' || to_char(q.question_id) variable_code,  -- Query for Constants used
   ql.question_name variable_name,
   q.question_datatype variable_datatype,
   ql.LANGUAGE language,
   ql.source_lang source_lang
FROM okc_xprt_rule_hdrs_all rhdr,
   okc_xprt_rule_conditions rcon,
   okc_xprt_questions_b q,
   okc_xprt_questions_tl ql
WHERE rhdr.rule_id = rcon.rule_id
AND rhdr.intent = p_intent
AND rcon.object_value_type = 'CONSTANT'
AND rhdr.status_code NOT IN ('DRAFT','INACTIVE')
AND rcon.object_value_code = to_char(q.question_id)
AND q.question_id = ql.question_id
AND ql.LANGUAGE = USERENV('LANG')
--AND ql.language = NVL(p_language,ql.language)
UNION
SELECT distinct to_char(rh.rule_id) variable_code, -- Deviation Rule
        rh.rule_name variable_name,
        'DR' variable_datatype, -- Will use this for decoding Deviation Rule to Option Feature
        USERENV('LANG') language,
        USERENV('LANG') source_lang
  FROM okc_xprt_rule_hdrs_all rh
 WHERE rh.rule_type = 'TERM_DEVIATION'
   AND rh.status_code NOT IN ('DRAFT','INACTIVE')
   AND rh.intent = p_intent
UNION
SELECT  'LINE_NUMBER' variable_code, -- Dummy Text feature
        'LINE_NUMBER' variable_name,
        'LN' variable_datatype, -- Will use this for decoding to  Line number to Text Feature
        USERENV('LANG') language,
        USERENV('LANG') source_lang
  FROM  dual;

Line: 771


SELECT L.LANGUAGE_CODE
  FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');

Line: 814


            INSERT INTO CZ_IMP_LOCALIZED_TEXTS
            (
             LAST_UPDATE_LOGIN,
             LOCALE_ID,
             LOCALIZED_STR,
             INTL_TEXT_ID,
             CREATION_DATE,
             LAST_UPDATE_DATE,
             DELETED_FLAG,
             EFF_FROM,
             EFF_TO,
             CREATED_BY,
             LAST_UPDATED_BY,
             SECURITY_MASK,
             EFF_MASK,
             CHECKOUT_USER,
             LANGUAGE,
             ORIG_SYS_REF,
             SOURCE_LANG,
             RUN_ID,
             REC_STATUS,
             DISPOSITION,
             MODEL_ID,
             FSK_DEVLPROJECT_1_1,
             MESSAGE,
             SEEDED_FLAG
            )
            VALUES
            (
            FND_GLOBAL.LOGIN_ID,  --LAST_UPDATE_LOGIN
            NULL, -- LOCALE_ID
            variableName_tbl(i),  --LOCALIZED_STR
            NULL, -- INTL_TEXT_ID
            SYSDATE, -- CREATION_DATE
            SYSDATE, -- LAST_UPDATE_DATE
            '0', -- DELETED_FLAG
            NULL, -- EFF_FROM
            NULL, -- EFF_TO
            FND_GLOBAL.USER_ID, -- CREATED_BY
            FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
            NULL, -- SECURITY_MASK
            NULL, -- EFF_MASK
            NULL, -- CHECKOUT_USER
            l_language,
            --language_tbl(i),  --LANGUAGE
            DECODE(variableDatatype_tbl(i), 'LN', G_VAR_MODEL_TEXT_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- ORIG_SYS_REF for Line Number
                                            'DR', G_VAR_MODEL_DEVI_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- ORIG_SYS_REF for Deviation Rule
                                             G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i)), -- ORIG_SYS_REF
            --sourceLang_tbl(i),  --SOURCE_LANG
            USERENV('LANG'),  --SOURCE_LANG
            G_RUN_ID, -- RUN_ID
            NULL, -- REC_STATUS
            NULL, -- DISPOSITION
            NULL, -- MODEL_ID
            G_VARIABLE_MODEL_OSR||p_intent , -- FSK_DEVLPROJECT_1_1
            NULL, -- MESSAGE
            NULL -- SEEDED_FLAG
            );

Line: 889


       INSERT INTO cz_imp_ps_nodes
       (
       PS_NODE_ID,
       DEVL_PROJECT_ID,
       FROM_POPULATOR_ID,
       PROPERTY_BACKPTR,
       ITEM_TYPE_BACKPTR,
       INTL_TEXT_ID,
       SUB_CONS_ID,
       ORGANIZATION_ID,
       ITEM_ID,
       EXPLOSION_TYPE,
       NAME,
       ORIG_SYS_REF,
       RESOURCE_FLAG,
       TOP_ITEM_ID,
       INITIAL_VALUE,
       PARENT_ID,
       MINIMUM,
       MAXIMUM,
       PS_NODE_TYPE,
       FEATURE_TYPE,
       PRODUCT_FLAG,
       REFERENCE_ID,
       MULTI_CONFIG_FLAG,
       ORDER_SEQ_FLAG,
       SYSTEM_NODE_FLAG,
       TREE_SEQ,
       COUNTED_OPTIONS_FLAG,
       UI_OMIT,
       UI_SECTION,
       BOM_TREATMENT,
       RUN_ID,
       REC_STATUS,
       DISPOSITION,
       DELETED_FLAG ,
       EFF_FROM,
       EFF_TO,
       EFF_MASK,
       USER_STR01,
       USER_STR02,
       USER_STR03,
       USER_STR04,
       USER_NUM01,
       USER_NUM02,
       USER_NUM03,
       USER_NUM04,
       CHECKOUT_USER,
       CREATION_DATE,
       LAST_UPDATE_DATE,
       CREATED_BY,
       LAST_UPDATED_BY,
       SECURITY_MASK,
       FSK_INTLTEXT_1_1,
       FSK_INTLTEXT_1_EXT,
       FSK_ITEMMASTER_2_1,
       FSK_ITEMMASTER_2_EXT,
       FSK_PSNODE_3_1,
       FSK_PSNODE_3_EXT,
       FSK_PSNODE_4_1,
       FSK_PSNODE_4_EXT,
       FSK_DEVLPROJECT_5_1,
       FSK_DEVLPROJECT_5_EXT,
       COMPONENT_SEQUENCE_ID,
       COMPONENT_CODE,
       PLAN_LEVEL,
       BOM_ITEM_TYPE,
       SO_ITEM_TYPE_CODE,
       MINIMUM_SELECTED,
       MAXIMUM_SELECTED,
       BOM_REQUIRED,
       MUTUALLY_EXCLUSIVE_OPTIONS,
       OPTIONAL,
       FSK_EXPLNODE_1_1,
       FSK_PSNODE_6_1,
       EFFECTIVE_FROM,
       EFFECTIVE_UNTIL,
       EFFECTIVE_USAGE_MASK,
       EFFECTIVITY_SET_ID,
       FSK_EFFSET_7_1,
       DECIMAL_QTY_FLAG,
       QUOTEABLE_FLAG,
       PRIMARY_UOM_CODE,
       COMPONENT_SEQUENCE_PATH,
       BOM_SORT_ORDER,
       IB_TRACKABLE,
       LAST_UPDATE_LOGIN,
       INITIAL_NUM_VALUE,
       SRC_APPLICATION_ID,
       FSK_ITEMMASTER_2_2,
       INSTANTIABLE_FLAG,
       DISPLAY_IN_SUMMARY_FLAG
       )
       VALUES
       (
       NULL, --PS_NODE_ID,
       NULL, --DEVL_PROJECT_ID,
       NULL, --FROM_POPULATOR_ID,
       NULL, --PROPERTY_BACKPTR,
       NULL, --ITEM_TYPE_BACKPTR,
       NULL, --INTL_TEXT_ID,
       NULL, --SUB_CONS_ID,
       -99, --ORGANIZATION_ID
       NULL, --ITEM_ID,
       NULL, --EXPLOSION_TYPE,
       variableCode_tbl(i), --NAME
       --G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), --ORIG_SYS_REF
       DECODE(variableDatatype_tbl(i), 'LN', G_VAR_MODEL_TEXT_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- ORIG_SYS_REF for Line Number
            			       'DR', G_VAR_MODEL_DEVI_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- ORIG_SYS_REF for Deviation Rule
       				        G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i)), -- ORIG_SYS_REF
       NULL, --RESOURCE_FLAG
       1, --TOP_ITEM_ID  -- same value as in cz_imp_devl_projects
       NULL, --INITIAL_VALUE
       NULL, --PARENT_ID
       -- 0, --MINIMUM  -- Commented for Bug 4090738
       DECODE(variableDatatype_tbl(i),'N',NULL,0), --MINIMUM -- Added for Bug 4090738
       NULL, --MAXIMUM
       261, --PS_NODE_TYPE  261:Feature
       DECODE(variableDatatype_tbl(i),'LN',4,'N',2,0), -- FEATURE_TYPE 2:Decimal and 0:option and 4: Text feature
       --DECODE(variableDatatype_tbl(i),'N',2,0), --FEATURE_TYPE 2:Decimal and 0:option
       NULL, --PRODUCT_FLAG,
       NULL, --REFERENCE_ID,
       NULL, --MULTI_CONFIG_FLAG,
       NULL, --ORDER_SEQ_FLAG,
       NULL, --SYSTEM_NODE_FLAG
       SeqNoList_tbl(i), --TREE_SEQ
       '0', --COUNTED_OPTIONS_FLAG
       '1', --UI_OMIT
       0, --UI_SECTION
       NULL, --BOM_TREATMENT,
       G_RUN_ID, --RUN_ID
       NULL, --REC_STATUS,
       NULL, --DISPOSITION,
       '0', --DELETED_FLAG
       NULL, --EFF_FROM,
       NULL, --EFF_TO,
       NULL, --EFF_MASK,
       NULL, --USER_STR01,
       NULL, --USER_STR02,
       NULL, --USER_STR03,
       NULL, --USER_STR04,
       NULL, --USER_NUM01,
       NULL, --USER_NUM02,
       NULL, --USER_NUM03,
       NULL, --USER_NUM04,
       NULL, --CHECKOUT_USER,
       SYSDATE, --CREATION_DATE
       SYSDATE, --LAST_UPDATE_DATE
       FND_GLOBAL.USER_ID, --CREATED_BY
       FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
       NULL, --SECURITY_MASK,
       --G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), --FSK_INTLTEXT_1_1
       DECODE(variableDatatype_tbl(i), 'LN', G_VAR_MODEL_TEXT_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- FSK_INTLTEXT_1_1 for Line Number
				   'DR', G_VAR_MODEL_DEVI_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- FSK_INTLTEXT_1_1 for Deviation Rule
				    G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i)), -- FSK_INTLTEXT_1_1
       NULL, --FSK_INTLTEXT_1_EXT,
       NULL, --FSK_ITEMMASTER_2_1,
       NULL, --FSK_ITEMMASTER_2_EXT,
       G_VARIABLE_MODEL_TOPNODE_OSR||p_intent, --FSK_PSNODE_3_1
       NULL, --FSK_PSNODE_3_EXT,
       NULL, --FSK_PSNODE_4_1,
       NULL, --FSK_PSNODE_4_EXT,
       G_VARIABLE_MODEL_OSR||p_intent, --FSK_DEVLPROJECT_5_1
       NULL, --FSK_DEVLPROJECT_5_EXT,
       NULL, --COMPONENT_SEQUENCE_ID,
       NULL, --COMPONENT_CODE,
       1, --PLAN_LEVEL  -- Plan Level for Feature:1
       NULL, --BOM_ITEM_TYPE,
       NULL, --SO_ITEM_TYPE_CODE,
       NULL, --MINIMUM_SELECTED,
       NULL, --MAXIMUM_SELECTED,
       NULL, --BOM_REQUIRED,
       NULL, --MUTUALLY_EXCLUSIVE_OPTIONS,
       NULL, --OPTIONAL,
       NULL, --FSK_EXPLNODE_1_1,
       NULL, --FSK_PSNODE_6_1,
       OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM
       OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL
       NULL, --EFFECTIVE_USAGE_MASK,
       NULL, --EFFECTIVITY_SET_ID,
       NULL, --FSK_EFFSET_7_1,
       '0', --DECIMAL_QTY_FLAG  -- 0 for all nodes
       NULL, --QUOTEABLE_FLAG
       NULL, --PRIMARY_UOM_CODE,
       NULL, --COMPONENT_SEQUENCE_PATH, -- Must be NULL
       NULL, --BOM_SORT_ORDER,
       NULL, --IB_TRACKABLE,
       FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
       NULL, --INITIAL_NUM_VALUE,
       G_APPLICATION_ID, --SRC_APPLICATION_ID
       NULL, --FSK_ITEMMASTER_2_2,
       NULL, --INSTANTIABLE_FLAG,
       NULL --DISPLAY_IN_SUMMARY_FLAG
      );

Line: 1142


SELECT L.LANGUAGE_CODE
  FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');

Line: 1150


      SELECT DISTINCT DECODE(SUBSTR(c.object_code,1,3),'OKC',c.object_code,'USER$' || c.object_code) variable_code,
              v.object_value_code variable_value,
		      okc_xprt_util_pvt.get_value_display(v.rule_condition_id,v.object_value_code) variable_value_desc
      FROM okc_xprt_rule_cond_vals v,
           okc_xprt_rule_conditions c,
           okc_xprt_rule_hdrs_all r
      WHERE v.rule_condition_id = c.rule_condition_id
        AND c.rule_id = r.rule_id
        AND c.object_type = 'VARIABLE'
        AND c.object_value_type = 'VALUE'
        AND r.intent = p_intent
        AND r.status_code NOT IN ('DRAFT','INACTIVE'); -- Added inactive status for bug 4758803

Line: 1212


            INSERT INTO CZ_IMP_LOCALIZED_TEXTS
            (
             LAST_UPDATE_LOGIN,
             LOCALE_ID,
             LOCALIZED_STR,
             INTL_TEXT_ID,
             CREATION_DATE,
             LAST_UPDATE_DATE,
             DELETED_FLAG,
             EFF_FROM,
             EFF_TO,
             CREATED_BY,
             LAST_UPDATED_BY,
             SECURITY_MASK,
             EFF_MASK,
             CHECKOUT_USER,
             LANGUAGE,
             ORIG_SYS_REF,
             SOURCE_LANG,
             RUN_ID,
             REC_STATUS,
             DISPOSITION,
             MODEL_ID,
             FSK_DEVLPROJECT_1_1,
             MESSAGE,
             SEEDED_FLAG
            )
            VALUES
            (
            FND_GLOBAL.LOGIN_ID,  --LAST_UPDATE_LOGIN
            NULL, -- LOCALE_ID
            variableOptionDesc_tbl(i),  --LOCALIZED_STR
            NULL, -- INTL_TEXT_ID
            SYSDATE, -- CREATION_DATE
            SYSDATE, -- LAST_UPDATE_DATE
            '0', -- DELETED_FLAG
            NULL, -- EFF_FROM
            NULL, -- EFF_TO
            FND_GLOBAL.USER_ID, -- CREATED_BY
            FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
            NULL, -- SECURITY_MASK
            NULL, -- EFF_MASK
            NULL, -- CHECKOUT_USER
            l_language,  --LANGUAGE
		  G_VARIABLE_MODEL_OPTION_OSR||p_intent||':'||variableCode_tbl(i)||':'||variableOption_tbl(i), --ORIG_SYS_REF
            USERENV('LANG'),  --SOURCE_LANG
            G_RUN_ID, -- RUN_ID
            NULL, -- REC_STATUS
            NULL, -- DISPOSITION
            NULL, -- MODEL_ID
            G_VARIABLE_MODEL_OSR||p_intent , -- FSK_DEVLPROJECT_1_1
            NULL, -- MESSAGE
            NULL -- SEEDED_FLAG
            );

Line: 1284


       INSERT INTO cz_imp_ps_nodes
       (
       PS_NODE_ID,
       DEVL_PROJECT_ID,
       FROM_POPULATOR_ID,
       PROPERTY_BACKPTR,
       ITEM_TYPE_BACKPTR,
       INTL_TEXT_ID,
       SUB_CONS_ID,
       ORGANIZATION_ID,
       ITEM_ID,
       EXPLOSION_TYPE,
       NAME,
       ORIG_SYS_REF,
       RESOURCE_FLAG,
       TOP_ITEM_ID,
       INITIAL_VALUE,
       PARENT_ID,
       MINIMUM,
       MAXIMUM,
       PS_NODE_TYPE,
       FEATURE_TYPE,
       PRODUCT_FLAG,
       REFERENCE_ID,
       MULTI_CONFIG_FLAG,
       ORDER_SEQ_FLAG,
       SYSTEM_NODE_FLAG,
       TREE_SEQ,
       COUNTED_OPTIONS_FLAG,
       UI_OMIT,
       UI_SECTION,
       BOM_TREATMENT,
       RUN_ID,
       REC_STATUS,
       DISPOSITION,
       DELETED_FLAG ,
       EFF_FROM,
       EFF_TO,
       EFF_MASK,
       USER_STR01,
       USER_STR02,
       USER_STR03,
       USER_STR04,
       USER_NUM01,
       USER_NUM02,
       USER_NUM03,
       USER_NUM04,
       CHECKOUT_USER,
       CREATION_DATE,
       LAST_UPDATE_DATE,
       CREATED_BY,
       LAST_UPDATED_BY,
       SECURITY_MASK,
       FSK_INTLTEXT_1_1,
       FSK_INTLTEXT_1_EXT,
       FSK_ITEMMASTER_2_1,
       FSK_ITEMMASTER_2_EXT,
       FSK_PSNODE_3_1,
       FSK_PSNODE_3_EXT,
       FSK_PSNODE_4_1,
       FSK_PSNODE_4_EXT,
       FSK_DEVLPROJECT_5_1,
       FSK_DEVLPROJECT_5_EXT,
       COMPONENT_SEQUENCE_ID,
       COMPONENT_CODE,
       PLAN_LEVEL,
       BOM_ITEM_TYPE,
       SO_ITEM_TYPE_CODE,
       MINIMUM_SELECTED,
       MAXIMUM_SELECTED,
       BOM_REQUIRED,
       MUTUALLY_EXCLUSIVE_OPTIONS,
       OPTIONAL,
       FSK_EXPLNODE_1_1,
       FSK_PSNODE_6_1,
       EFFECTIVE_FROM,
       EFFECTIVE_UNTIL,
       EFFECTIVE_USAGE_MASK,
       EFFECTIVITY_SET_ID,
       FSK_EFFSET_7_1,
       DECIMAL_QTY_FLAG,
       QUOTEABLE_FLAG,
       PRIMARY_UOM_CODE,
       COMPONENT_SEQUENCE_PATH,
       BOM_SORT_ORDER,
       IB_TRACKABLE,
       LAST_UPDATE_LOGIN,
       INITIAL_NUM_VALUE,
       SRC_APPLICATION_ID,
       FSK_ITEMMASTER_2_2,
       INSTANTIABLE_FLAG,
       DISPLAY_IN_SUMMARY_FLAG
       )
       VALUES
       (
       NULL, --PS_NODE_ID,
       NULL, --DEVL_PROJECT_ID,
       NULL, --FROM_POPULATOR_ID,
       NULL, --PROPERTY_BACKPTR,
       NULL, --ITEM_TYPE_BACKPTR,
       NULL, --INTL_TEXT_ID,
       NULL, --SUB_CONS_ID,
       -99, --ORGANIZATION_ID
       NULL, --ITEM_ID,
       NULL, --EXPLOSION_TYPE,
       variableOption_tbl(i), --NAME
       G_VARIABLE_MODEL_OPTION_OSR||p_intent||':'||variableCode_tbl(i)||':'||variableOption_tbl(i), --ORIG_SYS_REF
       NULL, --RESOURCE_FLAG
       1, --TOP_ITEM_ID  -- same value as in cz_imp_devl_projects
       NULL, --INITIAL_VALUE
       NULL, --PARENT_ID
       0, --MINIMUM
       NULL, --MAXIMUM
       262, --PS_NODE_TYPE  262:Option
       NULL,  --FEATURE_TYPE
       NULL, --PRODUCT_FLAG,
       NULL, --REFERENCE_ID,
       NULL, --MULTI_CONFIG_FLAG,
       NULL, --ORDER_SEQ_FLAG,
       NULL, --SYSTEM_NODE_FLAG
       SeqNoList_tbl(i) , --TREE_SEQ
       '0', --COUNTED_OPTIONS_FLAG
       '1', --UI_OMIT
       NULL, --UI_SECTION
       NULL, --BOM_TREATMENT,
       G_RUN_ID, --RUN_ID
       NULL, --REC_STATUS,
       NULL, --DISPOSITION,
       '0', --DELETED_FLAG
       NULL, --EFF_FROM,
       NULL, --EFF_TO,
       NULL, --EFF_MASK,
       NULL, --USER_STR01,
       NULL, --USER_STR02,
       NULL, --USER_STR03,
       NULL, --USER_STR04,
       NULL, --USER_NUM01,
       NULL, --USER_NUM02,
       NULL, --USER_NUM03,
       NULL, --USER_NUM04,
       NULL, --CHECKOUT_USER,
       SYSDATE, --CREATION_DATE
       SYSDATE, --LAST_UPDATE_DATE
       FND_GLOBAL.USER_ID, --CREATED_BY
       FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
       NULL, --SECURITY_MASK,
       G_VARIABLE_MODEL_OPTION_OSR||p_intent||':'||variableCode_tbl(i)||':'||variableOption_tbl(i),  --FSK_INTLTEXT_1_1
       NULL, --FSK_INTLTEXT_1_EXT,
       NULL, --FSK_ITEMMASTER_2_1,
       NULL, --FSK_ITEMMASTER_2_EXT,
       G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i) , --FSK_PSNODE_3_1
       NULL, --FSK_PSNODE_3_EXT,
       NULL, --FSK_PSNODE_4_1,
       NULL, --FSK_PSNODE_4_EXT,
       G_VARIABLE_MODEL_OSR||p_intent, --FSK_DEVLPROJECT_5_1
       NULL, --FSK_DEVLPROJECT_5_EXT,
       NULL, --COMPONENT_SEQUENCE_ID,
       NULL, --COMPONENT_CODE,
       2, --PLAN_LEVEL  --Plan Level for Option:2
       NULL, --BOM_ITEM_TYPE,
       NULL, --SO_ITEM_TYPE_CODE,
       NULL, --MINIMUM_SELECTED,
       NULL, --MAXIMUM_SELECTED,
       NULL, --BOM_REQUIRED,
       NULL, --MUTUALLY_EXCLUSIVE_OPTIONS,
       NULL, --OPTIONAL,
       NULL, --FSK_EXPLNODE_1_1,
       NULL, --FSK_PSNODE_6_1,
       OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM
       OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL
       NULL, --EFFECTIVE_USAGE_MASK,
       NULL, --EFFECTIVITY_SET_ID,
       NULL, --FSK_EFFSET_7_1,
       '0', --DECIMAL_QTY_FLAG  -- 0 for all nodes
       NULL, --QUOTEABLE_FLAG
       NULL, --PRIMARY_UOM_CODE,
       NULL, --COMPONENT_SEQUENCE_PATH, -- Must be NULL
       NULL, --BOM_SORT_ORDER,
       NULL, --IB_TRACKABLE,
       FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
       NULL, --INITIAL_NUM_VALUE,
       G_APPLICATION_ID, --SRC_APPLICATION_ID
       NULL, --FSK_ITEMMASTER_2_2,
       NULL, --INSTANTIABLE_FLAG,
       NULL --DISPLAY_IN_SUMMARY_FLAG
      );

Line: 1533


SELECT cz_xfr_run_infos_s.NEXTVAL
FROM dual;

Line: 1538


SELECT devl_project_id
FROM cz_devl_projects
WHERE orig_sys_ref = p_orig_sys_ref
  AND devl_project_id = persistent_project_id
  AND deleted_flag = 0;

Line: 1547


SELECT DISTINCT INTENT
FROM okc_xprt_rule_hdrs_all
WHERE org_id = p_org_id
  AND status_code = 'PENDINGPUB';