DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on CZ_IMP_RULES

Line 143: -- l_stmt_rule cz_imp_rules.rule_text%TYPE :='';

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);

Line 144: l_condition_stmt cz_imp_rules.rule_text%TYPE ;

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:

Line 145: l_outcome_stmt cz_imp_rules.rule_text%TYPE ;

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

Line 671: It then inserts the statement into cz_imp_rules

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

Line 736: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

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:

Line 738: l_rule_text cz_imp_rules.rule_text%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:
741:
742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

Line 745: l_cz_imp_rules cz_imp_rules%ROWTYPE;

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;

Line 944: -- Populate the cz_imp_rules record

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;

Line 946: l_cz_imp_rules.RULE_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;

Line 947: l_cz_imp_rules.SUB_CONS_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;

Line 948: l_cz_imp_rules.REASON_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;

Line 949: l_cz_imp_rules.AMOUNT_ID := NULL;

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;

Line 950: l_cz_imp_rules.GRID_ID := 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;

Line 951: l_cz_imp_rules.RULE_FOLDER_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;
955: l_cz_imp_rules.NAME := l_rule_name; -- check

Line 952: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

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;

Line 953: l_cz_imp_rules.INVALID_FLAG := 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;

Line 954: l_cz_imp_rules.DESC_TEXT := l_rule_description;

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

Line 955: l_cz_imp_rules.NAME := l_rule_name; -- check

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;

Line 956: l_cz_imp_rules.ANTECEDENT_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;
960: l_cz_imp_rules.COMPONENT_ID := NULL;

Line 957: l_cz_imp_rules.CONSEQUENT_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

Line 958: l_cz_imp_rules.RULE_TYPE := 200; -- Expression 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;

Line 959: l_cz_imp_rules.EXPR_RULE_TYPE := 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

Line 960: l_cz_imp_rules.COMPONENT_ID := NULL;

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;

Line 961: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule

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;

Line 962: l_cz_imp_rules.DISABLED_FLAG := 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;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check

Line 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

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;

Line 964: l_cz_imp_rules.CREATION_DATE := SYSDATE;

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;

Line 965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

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;

Line 966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check

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;

Line 967: l_cz_imp_rules.EFF_FROM := 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;
971: l_cz_imp_rules.SECURITY_MASK := NULL;

Line 968: l_cz_imp_rules.EFF_TO := 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;

Line 969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

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;

Line 970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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;

Line 971: l_cz_imp_rules.SECURITY_MASK := NULL;

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;

Line 972: l_cz_imp_rules.EFF_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;

Line 973: l_cz_imp_rules.CHECKOUT_USER := 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;

Line 974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_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;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

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;

Line 976: l_cz_imp_rules.SEQ_NBR := 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;

Line 977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

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;

Line 978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

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;

Line 979: l_cz_imp_rules.PERSISTENT_RULE_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;

Line 980: l_cz_imp_rules.EFFECTIVITY_SET_ID := 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;

Line 981: l_cz_imp_rules.RULE_FOLDER_TYPE := 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;

Line 982: l_cz_imp_rules.UNSATISFIED_MSG_ID := 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;

Line 983: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := 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;

Line 984: l_cz_imp_rules.SIGNATURE_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;
988: l_cz_imp_rules.RULE_TEXT := l_rule_text;

Line 985: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := 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;
989: l_cz_imp_rules.NOTES := NULL;

Line 986: l_cz_imp_rules.PRESENTATION_FLAG := 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;

Line 987: l_cz_imp_rules.TEMPLATE_TOKEN := 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;

Line 988: l_cz_imp_rules.RULE_TEXT := l_rule_text;

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;

Line 989: l_cz_imp_rules.NOTES := 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;

Line 990: l_cz_imp_rules.CLASS_NAME := 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;

Line 991: l_cz_imp_rules.INSTANTIATION_SCOPE := 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;

Line 992: l_cz_imp_rules.MODEL_REF_EXPL_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;

Line 993: l_cz_imp_rules.MUTABLE_FLAG := 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;

Line 994: l_cz_imp_rules.SEEDED_FLAG := 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;

Line 995: l_cz_imp_rules.UI_DEF_ID := 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;

Line 996: l_cz_imp_rules.UI_PAGE_ID := 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;
1000: l_cz_imp_rules.DISPOSITION := NULL;

Line 997: l_cz_imp_rules.UI_PAGE_ELEMENT_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;
1001: l_cz_imp_rules.REC_STATUS := NULL;

Line 998: l_cz_imp_rules.MESSAGE := 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;

Line 999: l_cz_imp_rules.RUN_ID := p_run_id;

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;

Line 1000: l_cz_imp_rules.DISPOSITION := 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;
1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

Line 1001: l_cz_imp_rules.REC_STATUS := 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;

Line 1002: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

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;

Line 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;

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;

Line 1004: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := 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:

Line 1005: l_cz_imp_rules.IMPORT_PROG_VERSION := 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:
1009: -- Insert into cz_imp_rules

Line 1006: l_cz_imp_rules.FSK_COMPONENT_ID := 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
1010:

Line 1007: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

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

Line 1009: -- 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,

Line 1011: INSERT INTO cz_imp_rules

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,

Line 1078: l_cz_imp_rules.RULE_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,

Line 1079: l_cz_imp_rules.SUB_CONS_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,

Line 1080: l_cz_imp_rules.REASON_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,

Line 1081: l_cz_imp_rules.AMOUNT_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,

Line 1082: l_cz_imp_rules.GRID_ID,

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,

Line 1083: l_cz_imp_rules.RULE_FOLDER_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,
1087: l_cz_imp_rules.NAME,

Line 1084: l_cz_imp_rules.DEVL_PROJECT_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,
1088: l_cz_imp_rules.ANTECEDENT_ID,

Line 1085: l_cz_imp_rules.INVALID_FLAG,

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,

Line 1086: l_cz_imp_rules.DESC_TEXT,

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,

Line 1087: l_cz_imp_rules.NAME,

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,

Line 1088: l_cz_imp_rules.ANTECEDENT_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,
1092: l_cz_imp_rules.COMPONENT_ID,

Line 1089: l_cz_imp_rules.CONSEQUENT_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,

Line 1090: l_cz_imp_rules.RULE_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,

Line 1091: l_cz_imp_rules.EXPR_RULE_TYPE,

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,

Line 1092: l_cz_imp_rules.COMPONENT_ID,

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,

Line 1093: l_cz_imp_rules.REASON_TYPE,

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,

Line 1094: l_cz_imp_rules.DISABLED_FLAG,

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,

Line 1095: l_cz_imp_rules.ORIG_SYS_REF,

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,

Line 1096: l_cz_imp_rules.CREATION_DATE,

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,

Line 1097: l_cz_imp_rules.LAST_UPDATE_DATE,

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,

Line 1098: l_cz_imp_rules.DELETED_FLAG,

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,

Line 1099: l_cz_imp_rules.EFF_FROM,

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,

Line 1100: l_cz_imp_rules.EFF_TO,

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,

Line 1101: l_cz_imp_rules.CREATED_BY,

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,

Line 1102: l_cz_imp_rules.LAST_UPDATED_BY,

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,

Line 1103: l_cz_imp_rules.SECURITY_MASK,

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,

Line 1104: l_cz_imp_rules.EFF_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,

Line 1105: l_cz_imp_rules.CHECKOUT_USER,

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,

Line 1106: l_cz_imp_rules.LAST_UPDATE_LOGIN,

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,

Line 1107: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

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,

Line 1108: l_cz_imp_rules.SEQ_NBR,

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,

Line 1109: l_cz_imp_rules.EFFECTIVE_FROM,

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,

Line 1110: l_cz_imp_rules.EFFECTIVE_UNTIL,

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,

Line 1111: l_cz_imp_rules.PERSISTENT_RULE_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,

Line 1112: l_cz_imp_rules.EFFECTIVITY_SET_ID,

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,

Line 1113: l_cz_imp_rules.RULE_FOLDER_TYPE,

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,

Line 1114: l_cz_imp_rules.UNSATISFIED_MSG_ID,

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,

Line 1115: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

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,

Line 1116: l_cz_imp_rules.SIGNATURE_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,
1120: l_cz_imp_rules.RULE_TEXT,

Line 1117: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

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,

Line 1118: l_cz_imp_rules.PRESENTATION_FLAG,

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,

Line 1119: l_cz_imp_rules.TEMPLATE_TOKEN,

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,

Line 1120: l_cz_imp_rules.RULE_TEXT,

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,

Line 1121: l_cz_imp_rules.NOTES,

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,

Line 1122: l_cz_imp_rules.CLASS_NAME,

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,

Line 1123: l_cz_imp_rules.INSTANTIATION_SCOPE,

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,

Line 1124: l_cz_imp_rules.MODEL_REF_EXPL_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,

Line 1125: l_cz_imp_rules.MUTABLE_FLAG,

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,

Line 1126: l_cz_imp_rules.SEEDED_FLAG,

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,

Line 1127: l_cz_imp_rules.UI_DEF_ID,

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,

Line 1128: l_cz_imp_rules.UI_PAGE_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,

Line 1129: l_cz_imp_rules.UI_PAGE_ELEMENT_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,
1133: l_cz_imp_rules.REC_STATUS,

Line 1130: l_cz_imp_rules.MESSAGE,

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,

Line 1131: l_cz_imp_rules.RUN_ID,

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,

Line 1132: l_cz_imp_rules.DISPOSITION,

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,

Line 1133: l_cz_imp_rules.REC_STATUS,

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,

Line 1134: l_cz_imp_rules.FSK_DEVL_PROJECT,

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,

Line 1135: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

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

Line 1136: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

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: );

Line 1137: l_cz_imp_rules.IMPORT_PROG_VERSION,

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:

Line 1138: l_cz_imp_rules.FSK_COMPONENT_ID,

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:

Line 1139: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

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:

Line 1957: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

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;

Line 1958: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;

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;

Line 1959: l_rule_name cz_imp_rules.NAME%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;

Line 1960: l_rule_description cz_imp_rules.desc_text%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:

Line 1961: l_rule_text cz_imp_rules.rule_text%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:
1965: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

Line 1967: l_cz_imp_rules cz_imp_rules%ROWTYPE;

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

Line 2094: -- Populate the cz_imp_rules record

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;

Line 2097: l_cz_imp_rules.RULE_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;

Line 2098: l_cz_imp_rules.SUB_CONS_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;

Line 2099: l_cz_imp_rules.REASON_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;

Line 2100: l_cz_imp_rules.AMOUNT_ID := NULL;

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

Line 2101: l_cz_imp_rules.GRID_ID := NULL;

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;

Line 2102: l_cz_imp_rules.RULE_FOLDER_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;
2106: l_cz_imp_rules.NAME := l_rule_name; -- check

Line 2103: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

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;

Line 2104: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule

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;

Line 2105: l_cz_imp_rules.DESC_TEXT := l_rule_description;

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

Line 2106: l_cz_imp_rules.NAME := l_rule_name; -- check

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

Line 2107: l_cz_imp_rules.ANTECEDENT_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
2111: l_cz_imp_rules.COMPONENT_ID := NULL;

Line 2108: l_cz_imp_rules.CONSEQUENT_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

Line 2109: l_cz_imp_rules.RULE_TYPE := 300; -- Extension 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

Line 2110: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension 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;

Line 2111: l_cz_imp_rules.COMPONENT_ID := NULL;

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;

Line 2112: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule

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;

Line 2113: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule

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

Line 2114: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;

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;

Line 2115: l_cz_imp_rules.CREATION_DATE := SYSDATE;

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;

Line 2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

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;

Line 2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check

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;

Line 2118: l_cz_imp_rules.EFF_FROM := NULL;

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;

Line 2119: l_cz_imp_rules.EFF_TO := 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;

Line 2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

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;

Line 2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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;

Line 2122: l_cz_imp_rules.SECURITY_MASK := NULL;

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;

Line 2123: l_cz_imp_rules.EFF_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;

Line 2124: l_cz_imp_rules.CHECKOUT_USER := 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;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

Line 2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_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;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

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;

Line 2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;

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;

Line 2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

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;

Line 2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

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;

Line 2130: l_cz_imp_rules.PERSISTENT_RULE_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

Line 2131: l_cz_imp_rules.EFFECTIVITY_SET_ID := 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;

Line 2132: l_cz_imp_rules.RULE_FOLDER_TYPE := 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;

Line 2133: l_cz_imp_rules.UNSATISFIED_MSG_ID := 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

Line 2134: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL

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;

Line 2135: l_cz_imp_rules.SIGNATURE_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;
2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;

Line 2136: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := 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;
2140: l_cz_imp_rules.NOTES := NULL;

Line 2137: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value

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;

Line 2138: l_cz_imp_rules.TEMPLATE_TOKEN := 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;
2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule

Line 2139: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;

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;

Line 2140: l_cz_imp_rules.NOTES := 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

Line 2141: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;

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

Line 2142: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension 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;

Line 2143: l_cz_imp_rules.MODEL_REF_EXPL_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;

Line 2144: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value

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;

Line 2145: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule

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;

Line 2146: l_cz_imp_rules.UI_DEF_ID := 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

Line 2147: l_cz_imp_rules.UI_PAGE_ID := NULL;

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;

Line 2148: l_cz_imp_rules.UI_PAGE_ELEMENT_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;
2152: l_cz_imp_rules.REC_STATUS := NULL;

Line 2149: l_cz_imp_rules.MESSAGE := 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;

Line 2150: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid

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;

Line 2151: l_cz_imp_rules.DISPOSITION := 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;
2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

Line 2152: l_cz_imp_rules.REC_STATUS := 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;

Line 2153: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

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;

Line 2154: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;

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;

Line 2155: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := 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:

Line 2156: l_cz_imp_rules.IMPORT_PROG_VERSION := 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:
2160:

Line 2157: l_cz_imp_rules.FSK_COMPONENT_ID := 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:
2161: -- Insert into cz_imp_rules

Line 2158: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

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:

Line 2161: -- Insert into cz_imp_rules

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,

Line 2163: INSERT INTO cz_imp_rules

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,

Line 2230: l_cz_imp_rules.RULE_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,

Line 2231: l_cz_imp_rules.SUB_CONS_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,

Line 2232: l_cz_imp_rules.REASON_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,

Line 2233: l_cz_imp_rules.AMOUNT_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,

Line 2234: l_cz_imp_rules.GRID_ID,

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,

Line 2235: l_cz_imp_rules.RULE_FOLDER_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,
2239: l_cz_imp_rules.NAME,

Line 2236: l_cz_imp_rules.DEVL_PROJECT_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,
2240: l_cz_imp_rules.ANTECEDENT_ID,

Line 2237: l_cz_imp_rules.INVALID_FLAG,

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,

Line 2238: l_cz_imp_rules.DESC_TEXT,

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,

Line 2239: l_cz_imp_rules.NAME,

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,

Line 2240: l_cz_imp_rules.ANTECEDENT_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,
2244: l_cz_imp_rules.COMPONENT_ID,

Line 2241: l_cz_imp_rules.CONSEQUENT_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,

Line 2242: l_cz_imp_rules.RULE_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,

Line 2243: l_cz_imp_rules.EXPR_RULE_TYPE,

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,

Line 2244: l_cz_imp_rules.COMPONENT_ID,

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,

Line 2245: l_cz_imp_rules.REASON_TYPE,

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,

Line 2246: l_cz_imp_rules.DISABLED_FLAG,

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,

Line 2247: l_cz_imp_rules.ORIG_SYS_REF,

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,

Line 2248: l_cz_imp_rules.CREATION_DATE,

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,

Line 2249: l_cz_imp_rules.LAST_UPDATE_DATE,

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,

Line 2250: l_cz_imp_rules.DELETED_FLAG,

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,

Line 2251: l_cz_imp_rules.EFF_FROM,

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,

Line 2252: l_cz_imp_rules.EFF_TO,

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,

Line 2253: l_cz_imp_rules.CREATED_BY,

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,

Line 2254: l_cz_imp_rules.LAST_UPDATED_BY,

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,

Line 2255: l_cz_imp_rules.SECURITY_MASK,

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,

Line 2256: l_cz_imp_rules.EFF_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,

Line 2257: l_cz_imp_rules.CHECKOUT_USER,

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,

Line 2258: l_cz_imp_rules.LAST_UPDATE_LOGIN,

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,

Line 2259: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

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,

Line 2260: l_cz_imp_rules.SEQ_NBR,

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,

Line 2261: l_cz_imp_rules.EFFECTIVE_FROM,

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,

Line 2262: l_cz_imp_rules.EFFECTIVE_UNTIL,

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,

Line 2263: l_cz_imp_rules.PERSISTENT_RULE_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,

Line 2264: l_cz_imp_rules.EFFECTIVITY_SET_ID,

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,

Line 2265: l_cz_imp_rules.RULE_FOLDER_TYPE,

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,

Line 2266: l_cz_imp_rules.UNSATISFIED_MSG_ID,

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,

Line 2267: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

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,

Line 2268: l_cz_imp_rules.SIGNATURE_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,
2272: --l_cz_imp_rules.RULE_TEXT,

Line 2269: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

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,

Line 2270: l_cz_imp_rules.PRESENTATION_FLAG,

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,

Line 2271: l_cz_imp_rules.TEMPLATE_TOKEN,

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,

Line 2272: --l_cz_imp_rules.RULE_TEXT,

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,

Line 2274: l_cz_imp_rules.NOTES,

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,

Line 2275: l_cz_imp_rules.CLASS_NAME,

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,

Line 2276: l_cz_imp_rules.INSTANTIATION_SCOPE,

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,

Line 2277: l_cz_imp_rules.MODEL_REF_EXPL_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,

Line 2278: l_cz_imp_rules.MUTABLE_FLAG,

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,

Line 2279: l_cz_imp_rules.SEEDED_FLAG,

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,

Line 2280: l_cz_imp_rules.UI_DEF_ID,

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,

Line 2281: l_cz_imp_rules.UI_PAGE_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,

Line 2282: l_cz_imp_rules.UI_PAGE_ELEMENT_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,
2286: l_cz_imp_rules.REC_STATUS,

Line 2283: l_cz_imp_rules.MESSAGE,

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,

Line 2284: l_cz_imp_rules.RUN_ID,

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,

Line 2285: l_cz_imp_rules.DISPOSITION,

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,

Line 2286: l_cz_imp_rules.REC_STATUS,

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,

Line 2287: l_cz_imp_rules.FSK_DEVL_PROJECT,

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,

Line 2288: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

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

Line 2289: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

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: );

Line 2290: l_cz_imp_rules.IMPORT_PROG_VERSION,

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

Line 2291: l_cz_imp_rules.FSK_COMPONENT_ID,

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 ,

Line 2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

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,

Line 2297: '170: After Insert into cz_imp_rules' || '='||l_intent);

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:

Line 2396: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

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;

Line 2397: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;

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;

Line 2398: l_rule_name cz_imp_rules.NAME%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;

Line 2399: l_rule_description cz_imp_rules.desc_text%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:

Line 2400: l_rule_text cz_imp_rules.rule_text%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:
2404: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

Line 2406: l_cz_imp_rules cz_imp_rules%ROWTYPE;

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

Line 2533: -- Populate the cz_imp_rules record

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;

Line 2536: l_cz_imp_rules.RULE_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;

Line 2537: l_cz_imp_rules.SUB_CONS_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;

Line 2538: l_cz_imp_rules.REASON_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;

Line 2539: l_cz_imp_rules.AMOUNT_ID := NULL;

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

Line 2540: l_cz_imp_rules.GRID_ID := NULL;

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;

Line 2541: l_cz_imp_rules.RULE_FOLDER_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;
2545: l_cz_imp_rules.NAME := l_rule_name; -- check

Line 2542: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

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;

Line 2543: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule

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;

Line 2544: l_cz_imp_rules.DESC_TEXT := l_rule_description;

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

Line 2545: l_cz_imp_rules.NAME := l_rule_name; -- check

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

Line 2546: l_cz_imp_rules.ANTECEDENT_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
2550: l_cz_imp_rules.COMPONENT_ID := NULL;

Line 2547: l_cz_imp_rules.CONSEQUENT_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

Line 2548: l_cz_imp_rules.RULE_TYPE := 300; -- Extension 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

Line 2549: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension 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;

Line 2550: l_cz_imp_rules.COMPONENT_ID := NULL;

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;

Line 2551: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule

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;

Line 2552: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule

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

Line 2553: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;

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;

Line 2554: l_cz_imp_rules.CREATION_DATE := SYSDATE;

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;

Line 2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

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;

Line 2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check

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;

Line 2557: l_cz_imp_rules.EFF_FROM := NULL;

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;

Line 2558: l_cz_imp_rules.EFF_TO := 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;

Line 2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

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;

Line 2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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;

Line 2561: l_cz_imp_rules.SECURITY_MASK := NULL;

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;

Line 2562: l_cz_imp_rules.EFF_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;

Line 2563: l_cz_imp_rules.CHECKOUT_USER := 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;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

Line 2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_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;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

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;

Line 2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;

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;

Line 2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

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;

Line 2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

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;

Line 2569: l_cz_imp_rules.PERSISTENT_RULE_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

Line 2570: l_cz_imp_rules.EFFECTIVITY_SET_ID := 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;

Line 2571: l_cz_imp_rules.RULE_FOLDER_TYPE := 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;

Line 2572: l_cz_imp_rules.UNSATISFIED_MSG_ID := 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

Line 2573: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL

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;

Line 2574: l_cz_imp_rules.SIGNATURE_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;
2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;

Line 2575: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := 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;
2579: l_cz_imp_rules.NOTES := NULL;

Line 2576: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value

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;

Line 2577: l_cz_imp_rules.TEMPLATE_TOKEN := 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;
2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule

Line 2578: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;

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;

Line 2579: l_cz_imp_rules.NOTES := 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

Line 2580: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;

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

Line 2581: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension 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;

Line 2582: l_cz_imp_rules.MODEL_REF_EXPL_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;

Line 2583: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value

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;

Line 2584: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule

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;

Line 2585: l_cz_imp_rules.UI_DEF_ID := 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

Line 2586: l_cz_imp_rules.UI_PAGE_ID := NULL;

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;

Line 2587: l_cz_imp_rules.UI_PAGE_ELEMENT_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;
2591: l_cz_imp_rules.REC_STATUS := NULL;

Line 2588: l_cz_imp_rules.MESSAGE := 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;

Line 2589: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid

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;

Line 2590: l_cz_imp_rules.DISPOSITION := 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;
2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

Line 2591: l_cz_imp_rules.REC_STATUS := 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;

Line 2592: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

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;

Line 2593: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;

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;

Line 2594: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := 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:

Line 2595: l_cz_imp_rules.IMPORT_PROG_VERSION := 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:
2599:

Line 2596: l_cz_imp_rules.FSK_COMPONENT_ID := 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:
2600: -- Insert into cz_imp_rules

Line 2597: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

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:

Line 2600: -- Insert into cz_imp_rules

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,

Line 2602: INSERT INTO cz_imp_rules

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,

Line 2669: l_cz_imp_rules.RULE_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,

Line 2670: l_cz_imp_rules.SUB_CONS_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,

Line 2671: l_cz_imp_rules.REASON_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,

Line 2672: l_cz_imp_rules.AMOUNT_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,

Line 2673: l_cz_imp_rules.GRID_ID,

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,

Line 2674: l_cz_imp_rules.RULE_FOLDER_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,
2678: l_cz_imp_rules.NAME,

Line 2675: l_cz_imp_rules.DEVL_PROJECT_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,
2679: l_cz_imp_rules.ANTECEDENT_ID,

Line 2676: l_cz_imp_rules.INVALID_FLAG,

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,

Line 2677: l_cz_imp_rules.DESC_TEXT,

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,

Line 2678: l_cz_imp_rules.NAME,

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,

Line 2679: l_cz_imp_rules.ANTECEDENT_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,
2683: l_cz_imp_rules.COMPONENT_ID,

Line 2680: l_cz_imp_rules.CONSEQUENT_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,

Line 2681: l_cz_imp_rules.RULE_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,

Line 2682: l_cz_imp_rules.EXPR_RULE_TYPE,

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,

Line 2683: l_cz_imp_rules.COMPONENT_ID,

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,

Line 2684: l_cz_imp_rules.REASON_TYPE,

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,

Line 2685: l_cz_imp_rules.DISABLED_FLAG,

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,

Line 2686: l_cz_imp_rules.ORIG_SYS_REF,

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,

Line 2687: l_cz_imp_rules.CREATION_DATE,

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,

Line 2688: l_cz_imp_rules.LAST_UPDATE_DATE,

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,

Line 2689: l_cz_imp_rules.DELETED_FLAG,

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,

Line 2690: l_cz_imp_rules.EFF_FROM,

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,

Line 2691: l_cz_imp_rules.EFF_TO,

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,

Line 2692: l_cz_imp_rules.CREATED_BY,

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,

Line 2693: l_cz_imp_rules.LAST_UPDATED_BY,

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,

Line 2694: l_cz_imp_rules.SECURITY_MASK,

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,

Line 2695: l_cz_imp_rules.EFF_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,

Line 2696: l_cz_imp_rules.CHECKOUT_USER,

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,

Line 2697: l_cz_imp_rules.LAST_UPDATE_LOGIN,

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,

Line 2698: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

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,

Line 2699: l_cz_imp_rules.SEQ_NBR,

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,

Line 2700: l_cz_imp_rules.EFFECTIVE_FROM,

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,

Line 2701: l_cz_imp_rules.EFFECTIVE_UNTIL,

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,

Line 2702: l_cz_imp_rules.PERSISTENT_RULE_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,

Line 2703: l_cz_imp_rules.EFFECTIVITY_SET_ID,

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,

Line 2704: l_cz_imp_rules.RULE_FOLDER_TYPE,

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,

Line 2705: l_cz_imp_rules.UNSATISFIED_MSG_ID,

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,

Line 2706: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

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,

Line 2707: l_cz_imp_rules.SIGNATURE_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,
2711: --l_cz_imp_rules.RULE_TEXT,

Line 2708: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

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,

Line 2709: l_cz_imp_rules.PRESENTATION_FLAG,

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,

Line 2710: l_cz_imp_rules.TEMPLATE_TOKEN,

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,

Line 2711: --l_cz_imp_rules.RULE_TEXT,

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,

Line 2713: l_cz_imp_rules.NOTES,

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,

Line 2714: l_cz_imp_rules.CLASS_NAME,

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,

Line 2715: l_cz_imp_rules.INSTANTIATION_SCOPE,

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,

Line 2716: l_cz_imp_rules.MODEL_REF_EXPL_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,

Line 2717: l_cz_imp_rules.MUTABLE_FLAG,

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,

Line 2718: l_cz_imp_rules.SEEDED_FLAG,

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,

Line 2719: l_cz_imp_rules.UI_DEF_ID,

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,

Line 2720: l_cz_imp_rules.UI_PAGE_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,

Line 2721: l_cz_imp_rules.UI_PAGE_ELEMENT_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,
2725: l_cz_imp_rules.REC_STATUS,

Line 2722: l_cz_imp_rules.MESSAGE,

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,

Line 2723: l_cz_imp_rules.RUN_ID,

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,

Line 2724: l_cz_imp_rules.DISPOSITION,

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,

Line 2725: l_cz_imp_rules.REC_STATUS,

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,

Line 2726: l_cz_imp_rules.FSK_DEVL_PROJECT,

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,

Line 2727: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

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

Line 2728: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

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: );

Line 2729: l_cz_imp_rules.IMPORT_PROG_VERSION,

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

Line 2730: l_cz_imp_rules.FSK_COMPONENT_ID,

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 ,

Line 2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

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,

Line 2736: '170: After Insert into cz_imp_rules' || '='||l_intent);

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: