139: l_clause_prefix VARCHAR2(4000);
140: l_system_var_prefix VARCHAR2(4000);
141: l_question_prefix VARCHAR2(4000);
142: l_deviation_prefix VARCHAR2(4000);
143: -- l_stmt_rule cz_imp_rules.rule_text%TYPE :='';
144: l_condition_stmt cz_imp_rules.rule_text%TYPE ;
145: l_outcome_stmt cz_imp_rules.rule_text%TYPE ;
146:
147: l_temp_string VARCHAR2(4000);
140: l_system_var_prefix VARCHAR2(4000);
141: l_question_prefix VARCHAR2(4000);
142: l_deviation_prefix VARCHAR2(4000);
143: -- l_stmt_rule cz_imp_rules.rule_text%TYPE :='';
144: l_condition_stmt cz_imp_rules.rule_text%TYPE ;
145: l_outcome_stmt cz_imp_rules.rule_text%TYPE ;
146:
147: l_temp_string VARCHAR2(4000);
148:
141: l_question_prefix VARCHAR2(4000);
142: l_deviation_prefix VARCHAR2(4000);
143: -- l_stmt_rule cz_imp_rules.rule_text%TYPE :='';
144: l_condition_stmt cz_imp_rules.rule_text%TYPE ;
145: l_outcome_stmt cz_imp_rules.rule_text%TYPE ;
146:
147: l_temp_string VARCHAR2(4000);
148:
149: BEGIN
667:
668: /*====================================================================+
669: Procedure Name : build_and_insert_rule
670: Description : This API calls build_statement_rule to build the rule statement.
671: It then inserts the statement into cz_imp_rules
672: Parameters:
673: p_rule_id - Rule Id
674: p_template_id - Template Id to which the rule is attached
675: p_run_id - Run Id for rules import
732: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
733: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
737:
738: l_rule_text cz_imp_rules.rule_text%TYPE;
739: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
740:
734: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
735: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
737:
738: l_rule_text cz_imp_rules.rule_text%TYPE;
739: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
740:
741:
742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
741:
742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
743: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
744:
745: l_cz_imp_rules cz_imp_rules%ROWTYPE;
746: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
747:
748: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
749: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;
940:
941: END LOOP; -- for all installed languages
942: CLOSE csr_installed_languages;
943:
944: -- Populate the cz_imp_rules record
945:
946: l_cz_imp_rules.RULE_ID := NULL;
947: l_cz_imp_rules.SUB_CONS_ID := NULL;
948: l_cz_imp_rules.REASON_ID := NULL;
942: CLOSE csr_installed_languages;
943:
944: -- Populate the cz_imp_rules record
945:
946: l_cz_imp_rules.RULE_ID := NULL;
947: l_cz_imp_rules.SUB_CONS_ID := NULL;
948: l_cz_imp_rules.REASON_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
943:
944: -- Populate the cz_imp_rules record
945:
946: l_cz_imp_rules.RULE_ID := NULL;
947: l_cz_imp_rules.SUB_CONS_ID := NULL;
948: l_cz_imp_rules.REASON_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
944: -- Populate the cz_imp_rules record
945:
946: l_cz_imp_rules.RULE_ID := NULL;
947: l_cz_imp_rules.SUB_CONS_ID := NULL;
948: l_cz_imp_rules.REASON_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
945:
946: l_cz_imp_rules.RULE_ID := NULL;
947: l_cz_imp_rules.SUB_CONS_ID := NULL;
948: l_cz_imp_rules.REASON_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
946: l_cz_imp_rules.RULE_ID := NULL;
947: l_cz_imp_rules.SUB_CONS_ID := NULL;
948: l_cz_imp_rules.REASON_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
947: l_cz_imp_rules.SUB_CONS_ID := NULL;
948: l_cz_imp_rules.REASON_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
948: l_cz_imp_rules.REASON_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
949: l_cz_imp_rules.AMOUNT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
950: l_cz_imp_rules.GRID_ID := NULL;
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
951: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
953: l_cz_imp_rules.INVALID_FLAG := NULL;
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
954: l_cz_imp_rules.DESC_TEXT := l_rule_description;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
955: l_cz_imp_rules.NAME := l_rule_name; -- check
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
956: l_cz_imp_rules.ANTECEDENT_ID := NULL;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
957: l_cz_imp_rules.CONSEQUENT_ID := NULL;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
959: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
960: l_cz_imp_rules.COMPONENT_ID := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
962: l_cz_imp_rules.DISABLED_FLAG := NULL;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
963: l_cz_imp_rules.ORIG_SYS_REF := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id; --ORIG_SYS_REF
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
964: l_cz_imp_rules.CREATION_DATE := SYSDATE;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
979: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
980: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
981: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
982: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
984: l_cz_imp_rules.SIGNATURE_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
986: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
987: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
989: l_cz_imp_rules.NOTES := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
990: l_cz_imp_rules.CLASS_NAME := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
991: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
992: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
993: l_cz_imp_rules.MUTABLE_FLAG := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
994: l_cz_imp_rules.SEEDED_FLAG := NULL;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
995: l_cz_imp_rules.UI_DEF_ID := NULL;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
996: l_cz_imp_rules.UI_PAGE_ID := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
997: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
998: l_cz_imp_rules.MESSAGE := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1006: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
999: l_cz_imp_rules.RUN_ID := p_run_id;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1006: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1000: l_cz_imp_rules.DISPOSITION := NULL;
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1006: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1008:
1001: l_cz_imp_rules.REC_STATUS := NULL;
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1006: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1008:
1009: -- Insert into cz_imp_rules
1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1006: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1008:
1009: -- Insert into cz_imp_rules
1010:
1003: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_RULE_OSR||l_org_id||':'||l_intent||':'||l_template_id||':'||l_rule_type||':'||l_rule_id;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1006: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1008:
1009: -- Insert into cz_imp_rules
1010:
1011: INSERT INTO cz_imp_rules
1005: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1006: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1008:
1009: -- Insert into cz_imp_rules
1010:
1011: INSERT INTO cz_imp_rules
1012: (
1013: RULE_ID,
1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1008:
1009: -- Insert into cz_imp_rules
1010:
1011: INSERT INTO cz_imp_rules
1012: (
1013: RULE_ID,
1014: SUB_CONS_ID,
1015: REASON_ID,
1074: FSK_MODEL_REF_EXPL_ID
1075: )
1076: VALUES
1077: (
1078: l_cz_imp_rules.RULE_ID,
1079: l_cz_imp_rules.SUB_CONS_ID,
1080: l_cz_imp_rules.REASON_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1075: )
1076: VALUES
1077: (
1078: l_cz_imp_rules.RULE_ID,
1079: l_cz_imp_rules.SUB_CONS_ID,
1080: l_cz_imp_rules.REASON_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1076: VALUES
1077: (
1078: l_cz_imp_rules.RULE_ID,
1079: l_cz_imp_rules.SUB_CONS_ID,
1080: l_cz_imp_rules.REASON_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1077: (
1078: l_cz_imp_rules.RULE_ID,
1079: l_cz_imp_rules.SUB_CONS_ID,
1080: l_cz_imp_rules.REASON_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1078: l_cz_imp_rules.RULE_ID,
1079: l_cz_imp_rules.SUB_CONS_ID,
1080: l_cz_imp_rules.REASON_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1079: l_cz_imp_rules.SUB_CONS_ID,
1080: l_cz_imp_rules.REASON_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1080: l_cz_imp_rules.REASON_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1081: l_cz_imp_rules.AMOUNT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1082: l_cz_imp_rules.GRID_ID,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1083: l_cz_imp_rules.RULE_FOLDER_ID,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1084: l_cz_imp_rules.DEVL_PROJECT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1085: l_cz_imp_rules.INVALID_FLAG,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1086: l_cz_imp_rules.DESC_TEXT,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1087: l_cz_imp_rules.NAME,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1088: l_cz_imp_rules.ANTECEDENT_ID,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1089: l_cz_imp_rules.CONSEQUENT_ID,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1090: l_cz_imp_rules.RULE_TYPE,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1091: l_cz_imp_rules.EXPR_RULE_TYPE,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1092: l_cz_imp_rules.COMPONENT_ID,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1093: l_cz_imp_rules.REASON_TYPE,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1094: l_cz_imp_rules.DISABLED_FLAG,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1095: l_cz_imp_rules.ORIG_SYS_REF,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1096: l_cz_imp_rules.CREATION_DATE,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1097: l_cz_imp_rules.LAST_UPDATE_DATE,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1098: l_cz_imp_rules.DELETED_FLAG,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1099: l_cz_imp_rules.EFF_FROM,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1100: l_cz_imp_rules.EFF_TO,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1101: l_cz_imp_rules.CREATED_BY,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1102: l_cz_imp_rules.LAST_UPDATED_BY,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1103: l_cz_imp_rules.SECURITY_MASK,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1104: l_cz_imp_rules.EFF_MASK,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1105: l_cz_imp_rules.CHECKOUT_USER,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1108: l_cz_imp_rules.SEQ_NBR,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1109: l_cz_imp_rules.EFFECTIVE_FROM,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1110: l_cz_imp_rules.EFFECTIVE_UNTIL,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1111: l_cz_imp_rules.PERSISTENT_RULE_ID,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1113: l_cz_imp_rules.RULE_FOLDER_TYPE,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1116: l_cz_imp_rules.SIGNATURE_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1118: l_cz_imp_rules.PRESENTATION_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1119: l_cz_imp_rules.TEMPLATE_TOKEN,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1120: l_cz_imp_rules.RULE_TEXT,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1121: l_cz_imp_rules.NOTES,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1122: l_cz_imp_rules.CLASS_NAME,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1123: l_cz_imp_rules.INSTANTIATION_SCOPE,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1124: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1125: l_cz_imp_rules.MUTABLE_FLAG,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1126: l_cz_imp_rules.SEEDED_FLAG,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1127: l_cz_imp_rules.UI_DEF_ID,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1128: l_cz_imp_rules.UI_PAGE_ID,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1129: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1137: l_cz_imp_rules.IMPORT_PROG_VERSION,
1130: l_cz_imp_rules.MESSAGE,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1137: l_cz_imp_rules.IMPORT_PROG_VERSION,
1138: l_cz_imp_rules.FSK_COMPONENT_ID,
1131: l_cz_imp_rules.RUN_ID,
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1137: l_cz_imp_rules.IMPORT_PROG_VERSION,
1138: l_cz_imp_rules.FSK_COMPONENT_ID,
1139: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1132: l_cz_imp_rules.DISPOSITION,
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1137: l_cz_imp_rules.IMPORT_PROG_VERSION,
1138: l_cz_imp_rules.FSK_COMPONENT_ID,
1139: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1140: );
1133: l_cz_imp_rules.REC_STATUS,
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1137: l_cz_imp_rules.IMPORT_PROG_VERSION,
1138: l_cz_imp_rules.FSK_COMPONENT_ID,
1139: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1140: );
1141:
1134: l_cz_imp_rules.FSK_DEVL_PROJECT,
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1137: l_cz_imp_rules.IMPORT_PROG_VERSION,
1138: l_cz_imp_rules.FSK_COMPONENT_ID,
1139: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1140: );
1141:
1142:
1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1137: l_cz_imp_rules.IMPORT_PROG_VERSION,
1138: l_cz_imp_rules.FSK_COMPONENT_ID,
1139: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1140: );
1141:
1142:
1143:
1953: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1954: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1955: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%TYPE;
1961: l_rule_text cz_imp_rules.rule_text%TYPE;
1954: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1955: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%TYPE;
1961: l_rule_text cz_imp_rules.rule_text%TYPE;
1962: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1955: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%TYPE;
1961: l_rule_text cz_imp_rules.rule_text%TYPE;
1962: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1963: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1956: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%TYPE;
1961: l_rule_text cz_imp_rules.rule_text%TYPE;
1962: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1963: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1964:
1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1959: l_rule_name cz_imp_rules.NAME%TYPE;
1960: l_rule_description cz_imp_rules.desc_text%TYPE;
1961: l_rule_text cz_imp_rules.rule_text%TYPE;
1962: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1963: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1964:
1965: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1963: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1964:
1965: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1966:
1967: l_cz_imp_rules cz_imp_rules%ROWTYPE;
1968:
1969: BEGIN
1970: -- start debug log
1971: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2090: END LOOP;
2091: CLOSE csr_installed_languages;
2092:
2093:
2094: -- Populate the cz_imp_rules record
2095: l_seq_nbr := l_seq_nbr + 1;
2096:
2097: l_cz_imp_rules.RULE_ID := NULL;
2098: l_cz_imp_rules.SUB_CONS_ID := NULL;
2093:
2094: -- Populate the cz_imp_rules record
2095: l_seq_nbr := l_seq_nbr + 1;
2096:
2097: l_cz_imp_rules.RULE_ID := NULL;
2098: l_cz_imp_rules.SUB_CONS_ID := NULL;
2099: l_cz_imp_rules.REASON_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2094: -- Populate the cz_imp_rules record
2095: l_seq_nbr := l_seq_nbr + 1;
2096:
2097: l_cz_imp_rules.RULE_ID := NULL;
2098: l_cz_imp_rules.SUB_CONS_ID := NULL;
2099: l_cz_imp_rules.REASON_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2095: l_seq_nbr := l_seq_nbr + 1;
2096:
2097: l_cz_imp_rules.RULE_ID := NULL;
2098: l_cz_imp_rules.SUB_CONS_ID := NULL;
2099: l_cz_imp_rules.REASON_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2096:
2097: l_cz_imp_rules.RULE_ID := NULL;
2098: l_cz_imp_rules.SUB_CONS_ID := NULL;
2099: l_cz_imp_rules.REASON_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2097: l_cz_imp_rules.RULE_ID := NULL;
2098: l_cz_imp_rules.SUB_CONS_ID := NULL;
2099: l_cz_imp_rules.REASON_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2098: l_cz_imp_rules.SUB_CONS_ID := NULL;
2099: l_cz_imp_rules.REASON_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2099: l_cz_imp_rules.REASON_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2100: l_cz_imp_rules.AMOUNT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2101: l_cz_imp_rules.GRID_ID := NULL;
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2102: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2106: l_cz_imp_rules.NAME := l_rule_name; -- check
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2107: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2108: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2111: l_cz_imp_rules.COMPONENT_ID := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2130: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2132: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2135: l_cz_imp_rules.SIGNATURE_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2138: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2140: l_cz_imp_rules.NOTES := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2143: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2146: l_cz_imp_rules.UI_DEF_ID := NULL;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2147: l_cz_imp_rules.UI_PAGE_ID := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2148: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2156: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2149: l_cz_imp_rules.MESSAGE := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2156: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2157: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2156: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2157: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2158: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2151: l_cz_imp_rules.DISPOSITION := NULL;
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2156: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2157: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2158: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2159:
2152: l_cz_imp_rules.REC_STATUS := NULL;
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2156: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2157: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2158: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2159:
2160:
2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2156: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2157: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2158: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2159:
2160:
2161: -- Insert into cz_imp_rules
2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2156: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2157: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2158: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2159:
2160:
2161: -- Insert into cz_imp_rules
2162:
2157: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2158: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2159:
2160:
2161: -- Insert into cz_imp_rules
2162:
2163: INSERT INTO cz_imp_rules
2164: (
2165: RULE_ID,
2159:
2160:
2161: -- Insert into cz_imp_rules
2162:
2163: INSERT INTO cz_imp_rules
2164: (
2165: RULE_ID,
2166: SUB_CONS_ID,
2167: REASON_ID,
2226: FSK_MODEL_REF_EXPL_ID
2227: )
2228: VALUES
2229: (
2230: l_cz_imp_rules.RULE_ID,
2231: l_cz_imp_rules.SUB_CONS_ID,
2232: l_cz_imp_rules.REASON_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2227: )
2228: VALUES
2229: (
2230: l_cz_imp_rules.RULE_ID,
2231: l_cz_imp_rules.SUB_CONS_ID,
2232: l_cz_imp_rules.REASON_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2228: VALUES
2229: (
2230: l_cz_imp_rules.RULE_ID,
2231: l_cz_imp_rules.SUB_CONS_ID,
2232: l_cz_imp_rules.REASON_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2229: (
2230: l_cz_imp_rules.RULE_ID,
2231: l_cz_imp_rules.SUB_CONS_ID,
2232: l_cz_imp_rules.REASON_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2230: l_cz_imp_rules.RULE_ID,
2231: l_cz_imp_rules.SUB_CONS_ID,
2232: l_cz_imp_rules.REASON_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2231: l_cz_imp_rules.SUB_CONS_ID,
2232: l_cz_imp_rules.REASON_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2232: l_cz_imp_rules.REASON_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2233: l_cz_imp_rules.AMOUNT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2234: l_cz_imp_rules.GRID_ID,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2235: l_cz_imp_rules.RULE_FOLDER_ID,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2236: l_cz_imp_rules.DEVL_PROJECT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2237: l_cz_imp_rules.INVALID_FLAG,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2238: l_cz_imp_rules.DESC_TEXT,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2239: l_cz_imp_rules.NAME,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2240: l_cz_imp_rules.ANTECEDENT_ID,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2241: l_cz_imp_rules.CONSEQUENT_ID,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2242: l_cz_imp_rules.RULE_TYPE,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2243: l_cz_imp_rules.EXPR_RULE_TYPE,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2244: l_cz_imp_rules.COMPONENT_ID,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2245: l_cz_imp_rules.REASON_TYPE,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2246: l_cz_imp_rules.DISABLED_FLAG,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2247: l_cz_imp_rules.ORIG_SYS_REF,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2248: l_cz_imp_rules.CREATION_DATE,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2249: l_cz_imp_rules.LAST_UPDATE_DATE,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2250: l_cz_imp_rules.DELETED_FLAG,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2251: l_cz_imp_rules.EFF_FROM,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2252: l_cz_imp_rules.EFF_TO,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2253: l_cz_imp_rules.CREATED_BY,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2254: l_cz_imp_rules.LAST_UPDATED_BY,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2255: l_cz_imp_rules.SECURITY_MASK,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2256: l_cz_imp_rules.EFF_MASK,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2257: l_cz_imp_rules.CHECKOUT_USER,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2260: l_cz_imp_rules.SEQ_NBR,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2261: l_cz_imp_rules.EFFECTIVE_FROM,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2262: l_cz_imp_rules.EFFECTIVE_UNTIL,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2263: l_cz_imp_rules.PERSISTENT_RULE_ID,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2272: --l_cz_imp_rules.RULE_TEXT,
2265: l_cz_imp_rules.RULE_FOLDER_TYPE,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2272: --l_cz_imp_rules.RULE_TEXT,
2273: G_XTN_RULE_TEXT,
2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2272: --l_cz_imp_rules.RULE_TEXT,
2273: G_XTN_RULE_TEXT,
2274: l_cz_imp_rules.NOTES,
2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2272: --l_cz_imp_rules.RULE_TEXT,
2273: G_XTN_RULE_TEXT,
2274: l_cz_imp_rules.NOTES,
2275: l_cz_imp_rules.CLASS_NAME,
2268: l_cz_imp_rules.SIGNATURE_ID,
2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2272: --l_cz_imp_rules.RULE_TEXT,
2273: G_XTN_RULE_TEXT,
2274: l_cz_imp_rules.NOTES,
2275: l_cz_imp_rules.CLASS_NAME,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2270: l_cz_imp_rules.PRESENTATION_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2272: --l_cz_imp_rules.RULE_TEXT,
2273: G_XTN_RULE_TEXT,
2274: l_cz_imp_rules.NOTES,
2275: l_cz_imp_rules.CLASS_NAME,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2271: l_cz_imp_rules.TEMPLATE_TOKEN,
2272: --l_cz_imp_rules.RULE_TEXT,
2273: G_XTN_RULE_TEXT,
2274: l_cz_imp_rules.NOTES,
2275: l_cz_imp_rules.CLASS_NAME,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2272: --l_cz_imp_rules.RULE_TEXT,
2273: G_XTN_RULE_TEXT,
2274: l_cz_imp_rules.NOTES,
2275: l_cz_imp_rules.CLASS_NAME,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2273: G_XTN_RULE_TEXT,
2274: l_cz_imp_rules.NOTES,
2275: l_cz_imp_rules.CLASS_NAME,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2274: l_cz_imp_rules.NOTES,
2275: l_cz_imp_rules.CLASS_NAME,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2275: l_cz_imp_rules.CLASS_NAME,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2276: l_cz_imp_rules.INSTANTIATION_SCOPE,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2277: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2278: l_cz_imp_rules.MUTABLE_FLAG,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2279: l_cz_imp_rules.SEEDED_FLAG,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2280: l_cz_imp_rules.UI_DEF_ID,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2281: l_cz_imp_rules.UI_PAGE_ID,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2282: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2283: l_cz_imp_rules.MESSAGE,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2284: l_cz_imp_rules.RUN_ID,
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2285: l_cz_imp_rules.DISPOSITION,
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2293: );
2286: l_cz_imp_rules.REC_STATUS,
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2293: );
2294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2287: l_cz_imp_rules.FSK_DEVL_PROJECT,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2293: );
2294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2293: );
2294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2296: G_MODULE||l_api_name,
2293: );
2294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2296: G_MODULE||l_api_name,
2297: '170: After Insert into cz_imp_rules' || '='||l_intent);
2298: END IF;
2299:
2300: END IF; -- check extn rule exists
2301:
2392: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2393: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2394: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%TYPE;
2400: l_rule_text cz_imp_rules.rule_text%TYPE;
2393: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2394: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%TYPE;
2400: l_rule_text cz_imp_rules.rule_text%TYPE;
2401: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2394: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%TYPE;
2400: l_rule_text cz_imp_rules.rule_text%TYPE;
2401: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2402: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2395: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%TYPE;
2400: l_rule_text cz_imp_rules.rule_text%TYPE;
2401: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2402: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2403:
2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2398: l_rule_name cz_imp_rules.NAME%TYPE;
2399: l_rule_description cz_imp_rules.desc_text%TYPE;
2400: l_rule_text cz_imp_rules.rule_text%TYPE;
2401: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2402: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2403:
2404: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
2402: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2403:
2404: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
2405:
2406: l_cz_imp_rules cz_imp_rules%ROWTYPE;
2407:
2408: BEGIN
2409: -- start debug log
2410: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2529: END LOOP;
2530: CLOSE csr_installed_languages;
2531:
2532:
2533: -- Populate the cz_imp_rules record
2534: l_seq_nbr := l_seq_nbr + 1;
2535:
2536: l_cz_imp_rules.RULE_ID := NULL;
2537: l_cz_imp_rules.SUB_CONS_ID := NULL;
2532:
2533: -- Populate the cz_imp_rules record
2534: l_seq_nbr := l_seq_nbr + 1;
2535:
2536: l_cz_imp_rules.RULE_ID := NULL;
2537: l_cz_imp_rules.SUB_CONS_ID := NULL;
2538: l_cz_imp_rules.REASON_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2533: -- Populate the cz_imp_rules record
2534: l_seq_nbr := l_seq_nbr + 1;
2535:
2536: l_cz_imp_rules.RULE_ID := NULL;
2537: l_cz_imp_rules.SUB_CONS_ID := NULL;
2538: l_cz_imp_rules.REASON_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2534: l_seq_nbr := l_seq_nbr + 1;
2535:
2536: l_cz_imp_rules.RULE_ID := NULL;
2537: l_cz_imp_rules.SUB_CONS_ID := NULL;
2538: l_cz_imp_rules.REASON_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2535:
2536: l_cz_imp_rules.RULE_ID := NULL;
2537: l_cz_imp_rules.SUB_CONS_ID := NULL;
2538: l_cz_imp_rules.REASON_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2536: l_cz_imp_rules.RULE_ID := NULL;
2537: l_cz_imp_rules.SUB_CONS_ID := NULL;
2538: l_cz_imp_rules.REASON_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2537: l_cz_imp_rules.SUB_CONS_ID := NULL;
2538: l_cz_imp_rules.REASON_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2538: l_cz_imp_rules.REASON_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2539: l_cz_imp_rules.AMOUNT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2540: l_cz_imp_rules.GRID_ID := NULL;
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2541: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2545: l_cz_imp_rules.NAME := l_rule_name; -- check
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2546: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2547: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2550: l_cz_imp_rules.COMPONENT_ID := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2569: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2571: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2574: l_cz_imp_rules.SIGNATURE_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2577: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2579: l_cz_imp_rules.NOTES := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2582: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2585: l_cz_imp_rules.UI_DEF_ID := NULL;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2586: l_cz_imp_rules.UI_PAGE_ID := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2587: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2595: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2588: l_cz_imp_rules.MESSAGE := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2595: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2596: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2595: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2596: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2597: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2590: l_cz_imp_rules.DISPOSITION := NULL;
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2595: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2596: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2597: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2598:
2591: l_cz_imp_rules.REC_STATUS := NULL;
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2595: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2596: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2597: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2598:
2599:
2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2595: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2596: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2597: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2598:
2599:
2600: -- Insert into cz_imp_rules
2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2595: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2596: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2597: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2598:
2599:
2600: -- Insert into cz_imp_rules
2601:
2596: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2597: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2598:
2599:
2600: -- Insert into cz_imp_rules
2601:
2602: INSERT INTO cz_imp_rules
2603: (
2604: RULE_ID,
2598:
2599:
2600: -- Insert into cz_imp_rules
2601:
2602: INSERT INTO cz_imp_rules
2603: (
2604: RULE_ID,
2605: SUB_CONS_ID,
2606: REASON_ID,
2665: FSK_MODEL_REF_EXPL_ID
2666: )
2667: VALUES
2668: (
2669: l_cz_imp_rules.RULE_ID,
2670: l_cz_imp_rules.SUB_CONS_ID,
2671: l_cz_imp_rules.REASON_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2666: )
2667: VALUES
2668: (
2669: l_cz_imp_rules.RULE_ID,
2670: l_cz_imp_rules.SUB_CONS_ID,
2671: l_cz_imp_rules.REASON_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2667: VALUES
2668: (
2669: l_cz_imp_rules.RULE_ID,
2670: l_cz_imp_rules.SUB_CONS_ID,
2671: l_cz_imp_rules.REASON_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2668: (
2669: l_cz_imp_rules.RULE_ID,
2670: l_cz_imp_rules.SUB_CONS_ID,
2671: l_cz_imp_rules.REASON_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2669: l_cz_imp_rules.RULE_ID,
2670: l_cz_imp_rules.SUB_CONS_ID,
2671: l_cz_imp_rules.REASON_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2670: l_cz_imp_rules.SUB_CONS_ID,
2671: l_cz_imp_rules.REASON_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2671: l_cz_imp_rules.REASON_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2672: l_cz_imp_rules.AMOUNT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2673: l_cz_imp_rules.GRID_ID,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2674: l_cz_imp_rules.RULE_FOLDER_ID,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2675: l_cz_imp_rules.DEVL_PROJECT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2676: l_cz_imp_rules.INVALID_FLAG,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2677: l_cz_imp_rules.DESC_TEXT,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2678: l_cz_imp_rules.NAME,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2679: l_cz_imp_rules.ANTECEDENT_ID,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2680: l_cz_imp_rules.CONSEQUENT_ID,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2681: l_cz_imp_rules.RULE_TYPE,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2682: l_cz_imp_rules.EXPR_RULE_TYPE,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2683: l_cz_imp_rules.COMPONENT_ID,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2684: l_cz_imp_rules.REASON_TYPE,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2685: l_cz_imp_rules.DISABLED_FLAG,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2686: l_cz_imp_rules.ORIG_SYS_REF,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2687: l_cz_imp_rules.CREATION_DATE,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2688: l_cz_imp_rules.LAST_UPDATE_DATE,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2689: l_cz_imp_rules.DELETED_FLAG,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2690: l_cz_imp_rules.EFF_FROM,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2691: l_cz_imp_rules.EFF_TO,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2692: l_cz_imp_rules.CREATED_BY,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2693: l_cz_imp_rules.LAST_UPDATED_BY,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2694: l_cz_imp_rules.SECURITY_MASK,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2695: l_cz_imp_rules.EFF_MASK,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2696: l_cz_imp_rules.CHECKOUT_USER,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2699: l_cz_imp_rules.SEQ_NBR,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2700: l_cz_imp_rules.EFFECTIVE_FROM,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2701: l_cz_imp_rules.EFFECTIVE_UNTIL,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2702: l_cz_imp_rules.PERSISTENT_RULE_ID,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2711: --l_cz_imp_rules.RULE_TEXT,
2704: l_cz_imp_rules.RULE_FOLDER_TYPE,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2711: --l_cz_imp_rules.RULE_TEXT,
2712: G_XTN_RULE_TEXT,
2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2711: --l_cz_imp_rules.RULE_TEXT,
2712: G_XTN_RULE_TEXT,
2713: l_cz_imp_rules.NOTES,
2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2711: --l_cz_imp_rules.RULE_TEXT,
2712: G_XTN_RULE_TEXT,
2713: l_cz_imp_rules.NOTES,
2714: l_cz_imp_rules.CLASS_NAME,
2707: l_cz_imp_rules.SIGNATURE_ID,
2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2711: --l_cz_imp_rules.RULE_TEXT,
2712: G_XTN_RULE_TEXT,
2713: l_cz_imp_rules.NOTES,
2714: l_cz_imp_rules.CLASS_NAME,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2709: l_cz_imp_rules.PRESENTATION_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2711: --l_cz_imp_rules.RULE_TEXT,
2712: G_XTN_RULE_TEXT,
2713: l_cz_imp_rules.NOTES,
2714: l_cz_imp_rules.CLASS_NAME,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2710: l_cz_imp_rules.TEMPLATE_TOKEN,
2711: --l_cz_imp_rules.RULE_TEXT,
2712: G_XTN_RULE_TEXT,
2713: l_cz_imp_rules.NOTES,
2714: l_cz_imp_rules.CLASS_NAME,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2711: --l_cz_imp_rules.RULE_TEXT,
2712: G_XTN_RULE_TEXT,
2713: l_cz_imp_rules.NOTES,
2714: l_cz_imp_rules.CLASS_NAME,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2712: G_XTN_RULE_TEXT,
2713: l_cz_imp_rules.NOTES,
2714: l_cz_imp_rules.CLASS_NAME,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2713: l_cz_imp_rules.NOTES,
2714: l_cz_imp_rules.CLASS_NAME,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2714: l_cz_imp_rules.CLASS_NAME,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2715: l_cz_imp_rules.INSTANTIATION_SCOPE,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2716: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2717: l_cz_imp_rules.MUTABLE_FLAG,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2718: l_cz_imp_rules.SEEDED_FLAG,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2719: l_cz_imp_rules.UI_DEF_ID,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2720: l_cz_imp_rules.UI_PAGE_ID,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2721: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2722: l_cz_imp_rules.MESSAGE,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2723: l_cz_imp_rules.RUN_ID,
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2724: l_cz_imp_rules.DISPOSITION,
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2732: );
2725: l_cz_imp_rules.REC_STATUS,
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2732: );
2733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2726: l_cz_imp_rules.FSK_DEVL_PROJECT,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2732: );
2733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2732: );
2733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2735: G_MODULE||l_api_name,
2732: );
2733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2735: G_MODULE||l_api_name,
2736: '170: After Insert into cz_imp_rules' || '='||l_intent);
2737: END IF;
2738:
2739: END IF; -- check extn rule exists
2740: