The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
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
);
SELECT L.LANGUAGE_CODE
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');
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_CLAUSE_MODEL_TOPNODE_OSR||p_org_id||':'||p_intent, -- ORIG_SYS_REF
USERENV('LANG'), --SOURCE_LANG
G_RUN_ID, -- RUN_ID
NULL, -- REC_STATUS
NULL, -- DISPOSITION
NULL, -- MODEL_ID
G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent, -- FSK_DEVLPROJECT_1_1
NULL, -- MESSAGE
NULL -- SEEDED_FLAG
);
l_cz_imp_ps_nodes_rec.DELETED_FLAG := 0;
l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
l_cz_imp_ps_nodes_rec.MINIMUM_SELECTED:= NULL;
l_cz_imp_ps_nodes_rec.MAXIMUM_SELECTED:= NULL;
l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
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
);
SELECT L.LANGUAGE_CODE
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');
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_feature_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_CLAUSE_MODEL_FEATURE_OSR||p_org_id||':'||p_intent, -- ORIG_SYS_REF
USERENV('LANG'), --SOURCE_LANG
G_RUN_ID, -- RUN_ID
NULL, -- REC_STATUS
NULL, -- DISPOSITION
NULL, -- MODEL_ID
G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent, -- FSK_DEVLPROJECT_1_1
NULL, -- MESSAGE
NULL -- SEEDED_FLAG
);
l_cz_imp_ps_nodes_rec.DELETED_FLAG := 0;
l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
l_cz_imp_ps_nodes_rec.MINIMUM_SELECTED:= NULL;
l_cz_imp_ps_nodes_rec.MAXIMUM_SELECTED:= NULL;
l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
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
);
SELECT article_id,
article_title,
rownum
FROM
(
-- All DISTINCT Clauses from Conditions
SELECT v.object_value_code article_id,
a.article_title
FROM okc_xprt_rule_cond_vals v,
okc_xprt_rule_conditions c,
okc_xprt_rule_hdrs_all r,
okc_articles_all a
WHERE v.rule_condition_id = c.rule_condition_id
AND c.rule_id = r.rule_id
AND a.article_id = to_number(v.object_value_code) -- Fix for bug 5030078.Removed to_char and added to_number
AND c.object_type = 'CLAUSE'
AND r.org_id = p_org_id
AND r.intent = p_intent
AND r.status_code <> 'DRAFT'
GROUP BY v.object_value_code, a.article_title
UNION
-- All DISTINCT Clauses from Outcome
SELECT to_char(o.object_value_id) article_id,
a.article_title
FROM okc_xprt_rule_outcomes o,
okc_xprt_rule_hdrs_all r,
okc_articles_all a
WHERE o.rule_id = r.rule_id
AND a.article_id = o.object_value_id
AND o.object_type = 'CLAUSE'
AND r.org_id = p_org_id
AND r.intent = p_intent
AND r.status_code <> 'DRAFT'
GROUP BY o.object_value_id, a.article_title
) ;
SELECT L.LANGUAGE_CODE
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');
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
ClauseTitleList_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_CLAUSE_MODEL_OPTION_OSR||p_org_id ||':'||p_intent||':'||ClauseIdList_tbl(i),--ORIG_SYS_REF
USERENV('LANG'), --SOURCE_LANG
G_RUN_ID, -- RUN_ID
NULL, -- REC_STATUS
NULL, -- DISPOSITION
NULL, -- MODEL_ID
G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent , -- FSK_DEVLPROJECT_1_1
NULL, -- MESSAGE
NULL -- SEEDED_FLAG
);
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,
p_org_id, --ORGANIZATION_ID
NULL, --ITEM_ID
NULL, --EXPLOSION_TYPE,
ClauseIdList_tbl(i), --NAME
G_CLAUSE_MODEL_OPTION_OSR||p_org_id ||':'||p_intent||':'||ClauseIdList_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
1, --MINIMUM
1, --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_CLAUSE_MODEL_OPTION_OSR||p_org_id ||':'||p_intent||':'||ClauseIdList_tbl(i),--FSK_INTLTEXT_1_1
NULL, --FSK_INTLTEXT_1_EXT,
NULL, --FSK_ITEMMASTER_2_1,
NULL, --FSK_ITEMMASTER_2_EXT,
G_CLAUSE_MODEL_FEATURE_OSR||p_org_id||':'||p_intent , --FSK_PSNODE_3_1
NULL, --FSK_PSNODE_3_EXT,
NULL, --FSK_PSNODE_4_1,
NULL, --FSK_PSNODE_4_EXT,
G_CLAUSE_MODEL_OSR||p_org_id||':'||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,
'1' --DISPLAY_IN_SUMMARY_FLAG -- 1: For Clauses to display in Summary UI
);
SELECT L.LANGUAGE_CODE
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');
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_variable_model_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_CLAUSE_MODEL_VM_REF_NODE_OSR||p_org_id||':'||p_intent, -- ORIG_SYS_REF
USERENV('LANG'), --SOURCE_LANG
G_RUN_ID, -- RUN_ID
NULL, -- REC_STATUS
NULL, -- DISPOSITION
NULL, -- MODEL_ID
G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent, -- FSK_DEVLPROJECT_1_1
NULL, -- MESSAGE
NULL -- SEEDED_FLAG
);
l_cz_imp_ps_nodes_rec.DELETED_FLAG := 0;
l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
l_cz_imp_ps_nodes_rec.MINIMUM_SELECTED:= NULL;
l_cz_imp_ps_nodes_rec.MAXIMUM_SELECTED:= NULL;
l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
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
);
SELECT cz_xfr_run_infos_s.NEXTVAL
FROM dual;
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;
SELECT DISTINCT INTENT
FROM okc_xprt_rule_hdrs_all
WHERE org_id = p_org_id
AND status_code ='PENDINGPUB';
SELECT name
FROM hr_operating_units
WHERE organization_id = p_org_id;
SELECT object_id
FROM cz_rp_entries
WHERE enclosing_folder= OKC_XPRT_CZ_INT_PVT.G_CLAUSE_FOLDER_ID
AND object_type = 'FLD'
AND deleted_flag=0
AND name = p_folder_name ;