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_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
);
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 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_value_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;
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
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
);
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
);
SELECT L.LANGUAGE_CODE
FROM FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B');
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
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
);
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
);
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';