eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_IMPORT_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 685: It then inserts the statement into cz_imp_rules

681:
682: /*====================================================================+
683: Procedure Name : build_and_insert_rule
684: Description : This API calls build_statement_rule to build the rule statement.
685: It then inserts the statement into cz_imp_rules
686: Parameters:
687: p_rule_id - Rule Id
688: p_template_id - Template Id to which the rule is attached
689: p_run_id - Run Id for rules import

Line 750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

746: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
747: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
751:
752: l_rule_text cz_imp_rules.rule_text%TYPE;
753: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
754:

Line 752: l_rule_text cz_imp_rules.rule_text%TYPE;

748: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
749: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
750: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
751:
752: l_rule_text cz_imp_rules.rule_text%TYPE;
753: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
754:
755:
756: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

Line 759: l_cz_imp_rules cz_imp_rules%ROWTYPE;

755:
756: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
757: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
758:
759: l_cz_imp_rules cz_imp_rules%ROWTYPE;
760: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
761:
762: l_model_id cz_devl_projects.devl_project_id%TYPE :=NULL;
763: l_model_osr cz_devl_projects.orig_sys_ref%TYPE := NULL;

Line 958: -- Populate the cz_imp_rules record

954:
955: END LOOP; -- for all installed languages
956: CLOSE csr_installed_languages;
957:
958: -- Populate the cz_imp_rules record
959:
960: l_cz_imp_rules.RULE_ID := NULL;
961: l_cz_imp_rules.SUB_CONS_ID := NULL;
962: l_cz_imp_rules.REASON_ID := NULL;

Line 960: l_cz_imp_rules.RULE_ID := NULL;

956: CLOSE csr_installed_languages;
957:
958: -- Populate the cz_imp_rules record
959:
960: l_cz_imp_rules.RULE_ID := NULL;
961: l_cz_imp_rules.SUB_CONS_ID := NULL;
962: l_cz_imp_rules.REASON_ID := NULL;
963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;

Line 961: l_cz_imp_rules.SUB_CONS_ID := NULL;

957:
958: -- Populate the cz_imp_rules record
959:
960: l_cz_imp_rules.RULE_ID := NULL;
961: l_cz_imp_rules.SUB_CONS_ID := NULL;
962: l_cz_imp_rules.REASON_ID := NULL;
963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;

Line 962: l_cz_imp_rules.REASON_ID := NULL;

958: -- Populate the cz_imp_rules record
959:
960: l_cz_imp_rules.RULE_ID := NULL;
961: l_cz_imp_rules.SUB_CONS_ID := NULL;
962: l_cz_imp_rules.REASON_ID := NULL;
963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

Line 963: l_cz_imp_rules.AMOUNT_ID := NULL;

959:
960: l_cz_imp_rules.RULE_ID := NULL;
961: l_cz_imp_rules.SUB_CONS_ID := NULL;
962: l_cz_imp_rules.REASON_ID := NULL;
963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;

Line 964: l_cz_imp_rules.GRID_ID := NULL;

960: l_cz_imp_rules.RULE_ID := NULL;
961: l_cz_imp_rules.SUB_CONS_ID := NULL;
962: l_cz_imp_rules.REASON_ID := NULL;
963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;

Line 965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;

961: l_cz_imp_rules.SUB_CONS_ID := NULL;
962: l_cz_imp_rules.REASON_ID := NULL;
963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check

Line 966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

962: l_cz_imp_rules.REASON_ID := NULL;
963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;

Line 967: l_cz_imp_rules.INVALID_FLAG := NULL;

963: l_cz_imp_rules.AMOUNT_ID := NULL;
964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;

Line 968: l_cz_imp_rules.DESC_TEXT := l_rule_description;

964: l_cz_imp_rules.GRID_ID := NULL;
965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule

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

965: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;

Line 970: l_cz_imp_rules.ANTECEDENT_ID := NULL;

966: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;

Line 971: l_cz_imp_rules.CONSEQUENT_ID := NULL;

967: l_cz_imp_rules.INVALID_FLAG := NULL;
968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule

Line 972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule

968: l_cz_imp_rules.DESC_TEXT := l_rule_description;
969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;

Line 973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;

969: l_cz_imp_rules.NAME := l_rule_name; -- check
970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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 974: l_cz_imp_rules.COMPONENT_ID := NULL;

970: l_cz_imp_rules.ANTECEDENT_ID := NULL;
971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;

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

971: l_cz_imp_rules.CONSEQUENT_ID := NULL;
972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

Line 976: l_cz_imp_rules.DISABLED_FLAG := NULL;

972: l_cz_imp_rules.RULE_TYPE := 200; -- Expression Rule
973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check

Line 977: 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

973: l_cz_imp_rules.EXPR_RULE_TYPE := NULL;
974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;

Line 978: l_cz_imp_rules.CREATION_DATE := SYSDATE;

974: l_cz_imp_rules.COMPONENT_ID := NULL;
975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;

Line 979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

975: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

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

976: l_cz_imp_rules.DISABLED_FLAG := NULL;
977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 981: l_cz_imp_rules.EFF_FROM := NULL;

977: 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
978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;

Line 982: l_cz_imp_rules.EFF_TO := NULL;

978: l_cz_imp_rules.CREATION_DATE := SYSDATE;
979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;

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

979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;

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

980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 985: l_cz_imp_rules.SECURITY_MASK := NULL;

981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

Line 986: l_cz_imp_rules.EFF_MASK := NULL;

982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;

Line 987: l_cz_imp_rules.CHECKOUT_USER := NULL;

983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

Line 988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;

Line 990: l_cz_imp_rules.SEQ_NBR := NULL;

986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;

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

987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;

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

988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;

Line 993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;

989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;

Line 994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;

990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;

Line 995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;

991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;

Line 996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;

992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;

Line 997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;

993: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;

Line 998: l_cz_imp_rules.SIGNATURE_ID := NULL;

994: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;

Line 999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;

995: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;

Line 1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;

996: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;

Line 1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;

997: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := NULL;
998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;

Line 1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;

998: l_cz_imp_rules.SIGNATURE_ID := NULL;
999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;

Line 1003: l_cz_imp_rules.NOTES := NULL;

999: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;

Line 1004: l_cz_imp_rules.CLASS_NAME := NULL;

1000: l_cz_imp_rules.PRESENTATION_FLAG := NULL;
1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;

Line 1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;

1001: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;

Line 1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;

1002: l_cz_imp_rules.RULE_TEXT := l_rule_text;
1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;

Line 1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;

1003: l_cz_imp_rules.NOTES := NULL;
1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;

Line 1008: l_cz_imp_rules.SEEDED_FLAG := NULL;

1004: l_cz_imp_rules.CLASS_NAME := NULL;
1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;

Line 1009: l_cz_imp_rules.UI_DEF_ID := NULL;

1005: l_cz_imp_rules.INSTANTIATION_SCOPE := NULL;
1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;

Line 1010: l_cz_imp_rules.UI_PAGE_ID := NULL;

1006: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;

Line 1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;

1007: l_cz_imp_rules.MUTABLE_FLAG := NULL;
1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;

Line 1012: l_cz_imp_rules.MESSAGE := NULL;

1008: l_cz_imp_rules.SEEDED_FLAG := NULL;
1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

Line 1013: l_cz_imp_rules.RUN_ID := p_run_id;

1009: l_cz_imp_rules.UI_DEF_ID := NULL;
1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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 1014: l_cz_imp_rules.DISPOSITION := NULL;

1010: l_cz_imp_rules.UI_PAGE_ID := NULL;
1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

Line 1015: l_cz_imp_rules.REC_STATUS := NULL;

1011: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;

Line 1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

1012: l_cz_imp_rules.MESSAGE := NULL;
1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;

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

1013: l_cz_imp_rules.RUN_ID := p_run_id;
1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

Line 1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

1014: l_cz_imp_rules.DISPOSITION := NULL;
1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1022:

Line 1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;

1015: l_cz_imp_rules.REC_STATUS := NULL;
1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1022:
1023: -- Insert into cz_imp_rules

Line 1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;

1016: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1022:
1023: -- Insert into cz_imp_rules
1024:

Line 1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

1017: 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;
1018: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1022:
1023: -- Insert into cz_imp_rules
1024:
1025: INSERT INTO cz_imp_rules

Line 1023: -- Insert into cz_imp_rules

1019: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
1020: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1022:
1023: -- Insert into cz_imp_rules
1024:
1025: INSERT INTO cz_imp_rules
1026: (
1027: RULE_ID,

Line 1025: INSERT INTO cz_imp_rules

1021: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
1022:
1023: -- Insert into cz_imp_rules
1024:
1025: INSERT INTO cz_imp_rules
1026: (
1027: RULE_ID,
1028: SUB_CONS_ID,
1029: REASON_ID,

Line 1092: l_cz_imp_rules.RULE_ID,

1088: FSK_MODEL_REF_EXPL_ID
1089: )
1090: VALUES
1091: (
1092: l_cz_imp_rules.RULE_ID,
1093: l_cz_imp_rules.SUB_CONS_ID,
1094: l_cz_imp_rules.REASON_ID,
1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,

Line 1093: l_cz_imp_rules.SUB_CONS_ID,

1089: )
1090: VALUES
1091: (
1092: l_cz_imp_rules.RULE_ID,
1093: l_cz_imp_rules.SUB_CONS_ID,
1094: l_cz_imp_rules.REASON_ID,
1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,

Line 1094: l_cz_imp_rules.REASON_ID,

1090: VALUES
1091: (
1092: l_cz_imp_rules.RULE_ID,
1093: l_cz_imp_rules.SUB_CONS_ID,
1094: l_cz_imp_rules.REASON_ID,
1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,

Line 1095: l_cz_imp_rules.AMOUNT_ID,

1091: (
1092: l_cz_imp_rules.RULE_ID,
1093: l_cz_imp_rules.SUB_CONS_ID,
1094: l_cz_imp_rules.REASON_ID,
1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,

Line 1096: l_cz_imp_rules.GRID_ID,

1092: l_cz_imp_rules.RULE_ID,
1093: l_cz_imp_rules.SUB_CONS_ID,
1094: l_cz_imp_rules.REASON_ID,
1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,

Line 1097: l_cz_imp_rules.RULE_FOLDER_ID,

1093: l_cz_imp_rules.SUB_CONS_ID,
1094: l_cz_imp_rules.REASON_ID,
1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,

Line 1098: l_cz_imp_rules.DEVL_PROJECT_ID,

1094: l_cz_imp_rules.REASON_ID,
1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,

Line 1099: l_cz_imp_rules.INVALID_FLAG,

1095: l_cz_imp_rules.AMOUNT_ID,
1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,

Line 1100: l_cz_imp_rules.DESC_TEXT,

1096: l_cz_imp_rules.GRID_ID,
1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,

Line 1101: l_cz_imp_rules.NAME,

1097: l_cz_imp_rules.RULE_FOLDER_ID,
1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,

Line 1102: l_cz_imp_rules.ANTECEDENT_ID,

1098: l_cz_imp_rules.DEVL_PROJECT_ID,
1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,

Line 1103: l_cz_imp_rules.CONSEQUENT_ID,

1099: l_cz_imp_rules.INVALID_FLAG,
1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,

Line 1104: l_cz_imp_rules.RULE_TYPE,

1100: l_cz_imp_rules.DESC_TEXT,
1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,

Line 1105: l_cz_imp_rules.EXPR_RULE_TYPE,

1101: l_cz_imp_rules.NAME,
1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,

Line 1106: l_cz_imp_rules.COMPONENT_ID,

1102: l_cz_imp_rules.ANTECEDENT_ID,
1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,

Line 1107: l_cz_imp_rules.REASON_TYPE,

1103: l_cz_imp_rules.CONSEQUENT_ID,
1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,

Line 1108: l_cz_imp_rules.DISABLED_FLAG,

1104: l_cz_imp_rules.RULE_TYPE,
1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,

Line 1109: l_cz_imp_rules.ORIG_SYS_REF,

1105: l_cz_imp_rules.EXPR_RULE_TYPE,
1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,

Line 1110: l_cz_imp_rules.CREATION_DATE,

1106: l_cz_imp_rules.COMPONENT_ID,
1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,

Line 1111: l_cz_imp_rules.LAST_UPDATE_DATE,

1107: l_cz_imp_rules.REASON_TYPE,
1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,

Line 1112: l_cz_imp_rules.DELETED_FLAG,

1108: l_cz_imp_rules.DISABLED_FLAG,
1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,

Line 1113: l_cz_imp_rules.EFF_FROM,

1109: l_cz_imp_rules.ORIG_SYS_REF,
1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,

Line 1114: l_cz_imp_rules.EFF_TO,

1110: l_cz_imp_rules.CREATION_DATE,
1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,

Line 1115: l_cz_imp_rules.CREATED_BY,

1111: l_cz_imp_rules.LAST_UPDATE_DATE,
1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,

Line 1116: l_cz_imp_rules.LAST_UPDATED_BY,

1112: l_cz_imp_rules.DELETED_FLAG,
1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,

Line 1117: l_cz_imp_rules.SECURITY_MASK,

1113: l_cz_imp_rules.EFF_FROM,
1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

Line 1118: l_cz_imp_rules.EFF_MASK,

1114: l_cz_imp_rules.EFF_TO,
1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,

Line 1119: l_cz_imp_rules.CHECKOUT_USER,

1115: l_cz_imp_rules.CREATED_BY,
1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,

Line 1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,

1116: l_cz_imp_rules.LAST_UPDATED_BY,
1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,

Line 1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

1117: l_cz_imp_rules.SECURITY_MASK,
1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,

Line 1122: l_cz_imp_rules.SEQ_NBR,

1118: l_cz_imp_rules.EFF_MASK,
1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,

Line 1123: l_cz_imp_rules.EFFECTIVE_FROM,

1119: l_cz_imp_rules.CHECKOUT_USER,
1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,

Line 1124: l_cz_imp_rules.EFFECTIVE_UNTIL,

1120: l_cz_imp_rules.LAST_UPDATE_LOGIN,
1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,

Line 1125: l_cz_imp_rules.PERSISTENT_RULE_ID,

1121: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

Line 1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,

1122: l_cz_imp_rules.SEQ_NBR,
1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,

Line 1127: l_cz_imp_rules.RULE_FOLDER_TYPE,

1123: l_cz_imp_rules.EFFECTIVE_FROM,
1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

Line 1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,

1124: l_cz_imp_rules.EFFECTIVE_UNTIL,
1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,

Line 1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

1125: l_cz_imp_rules.PERSISTENT_RULE_ID,
1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,

Line 1130: l_cz_imp_rules.SIGNATURE_ID,

1126: l_cz_imp_rules.EFFECTIVITY_SET_ID,
1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,

Line 1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

1127: l_cz_imp_rules.RULE_FOLDER_TYPE,
1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,

Line 1132: l_cz_imp_rules.PRESENTATION_FLAG,

1128: l_cz_imp_rules.UNSATISFIED_MSG_ID,
1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,

Line 1133: l_cz_imp_rules.TEMPLATE_TOKEN,

1129: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,

Line 1134: l_cz_imp_rules.RULE_TEXT,

1130: l_cz_imp_rules.SIGNATURE_ID,
1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,

Line 1135: l_cz_imp_rules.NOTES,

1131: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,

Line 1136: l_cz_imp_rules.CLASS_NAME,

1132: l_cz_imp_rules.PRESENTATION_FLAG,
1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,

Line 1137: l_cz_imp_rules.INSTANTIATION_SCOPE,

1133: l_cz_imp_rules.TEMPLATE_TOKEN,
1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,

Line 1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,

1134: l_cz_imp_rules.RULE_TEXT,
1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,

Line 1139: l_cz_imp_rules.MUTABLE_FLAG,

1135: l_cz_imp_rules.NOTES,
1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,

Line 1140: l_cz_imp_rules.SEEDED_FLAG,

1136: l_cz_imp_rules.CLASS_NAME,
1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,

Line 1141: l_cz_imp_rules.UI_DEF_ID,

1137: l_cz_imp_rules.INSTANTIATION_SCOPE,
1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,

Line 1142: l_cz_imp_rules.UI_PAGE_ID,

1138: l_cz_imp_rules.MODEL_REF_EXPL_ID,
1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,

Line 1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,

1139: l_cz_imp_rules.MUTABLE_FLAG,
1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,

Line 1144: l_cz_imp_rules.MESSAGE,

1140: l_cz_imp_rules.SEEDED_FLAG,
1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,

Line 1145: l_cz_imp_rules.RUN_ID,

1141: l_cz_imp_rules.UI_DEF_ID,
1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

Line 1146: l_cz_imp_rules.DISPOSITION,

1142: l_cz_imp_rules.UI_PAGE_ID,
1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

Line 1147: l_cz_imp_rules.REC_STATUS,

1143: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1151: l_cz_imp_rules.IMPORT_PROG_VERSION,

Line 1148: l_cz_imp_rules.FSK_DEVL_PROJECT,

1144: l_cz_imp_rules.MESSAGE,
1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1151: l_cz_imp_rules.IMPORT_PROG_VERSION,
1152: l_cz_imp_rules.FSK_COMPONENT_ID,

Line 1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

1145: l_cz_imp_rules.RUN_ID,
1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1151: l_cz_imp_rules.IMPORT_PROG_VERSION,
1152: l_cz_imp_rules.FSK_COMPONENT_ID,
1153: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

Line 1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

1146: l_cz_imp_rules.DISPOSITION,
1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1151: l_cz_imp_rules.IMPORT_PROG_VERSION,
1152: l_cz_imp_rules.FSK_COMPONENT_ID,
1153: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1154: );

Line 1151: l_cz_imp_rules.IMPORT_PROG_VERSION,

1147: l_cz_imp_rules.REC_STATUS,
1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1151: l_cz_imp_rules.IMPORT_PROG_VERSION,
1152: l_cz_imp_rules.FSK_COMPONENT_ID,
1153: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1154: );
1155:

Line 1152: l_cz_imp_rules.FSK_COMPONENT_ID,

1148: l_cz_imp_rules.FSK_DEVL_PROJECT,
1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1151: l_cz_imp_rules.IMPORT_PROG_VERSION,
1152: l_cz_imp_rules.FSK_COMPONENT_ID,
1153: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1154: );
1155:
1156:

Line 1153: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

1149: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
1150: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
1151: l_cz_imp_rules.IMPORT_PROG_VERSION,
1152: l_cz_imp_rules.FSK_COMPONENT_ID,
1153: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
1154: );
1155:
1156:
1157:

Line 1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

1967: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule';
1968: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1969: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;
1974: l_rule_description cz_imp_rules.desc_text%TYPE;
1975: l_rule_text cz_imp_rules.rule_text%TYPE;

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

1968: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1969: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;
1974: l_rule_description cz_imp_rules.desc_text%TYPE;
1975: l_rule_text cz_imp_rules.rule_text%TYPE;
1976: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;

Line 1973: l_rule_name cz_imp_rules.NAME%TYPE;

1969: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;
1974: l_rule_description cz_imp_rules.desc_text%TYPE;
1975: l_rule_text cz_imp_rules.rule_text%TYPE;
1976: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1977: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;

Line 1974: l_rule_description cz_imp_rules.desc_text%TYPE;

1970: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;
1974: l_rule_description cz_imp_rules.desc_text%TYPE;
1975: l_rule_text cz_imp_rules.rule_text%TYPE;
1976: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1977: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1978:

Line 1975: l_rule_text cz_imp_rules.rule_text%TYPE;

1971: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
1972: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
1973: l_rule_name cz_imp_rules.NAME%TYPE;
1974: l_rule_description cz_imp_rules.desc_text%TYPE;
1975: l_rule_text cz_imp_rules.rule_text%TYPE;
1976: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
1977: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1978:
1979: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

Line 1981: l_cz_imp_rules cz_imp_rules%ROWTYPE;

1977: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1978:
1979: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
1980:
1981: l_cz_imp_rules cz_imp_rules%ROWTYPE;
1982:
1983: BEGIN
1984: -- start debug log
1985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2108: -- Populate the cz_imp_rules record

2104: END LOOP;
2105: CLOSE csr_installed_languages;
2106:
2107:
2108: -- Populate the cz_imp_rules record
2109: l_seq_nbr := l_seq_nbr + 1;
2110:
2111: l_cz_imp_rules.RULE_ID := NULL;
2112: l_cz_imp_rules.SUB_CONS_ID := NULL;

Line 2111: l_cz_imp_rules.RULE_ID := NULL;

2107:
2108: -- Populate the cz_imp_rules record
2109: l_seq_nbr := l_seq_nbr + 1;
2110:
2111: l_cz_imp_rules.RULE_ID := NULL;
2112: l_cz_imp_rules.SUB_CONS_ID := NULL;
2113: l_cz_imp_rules.REASON_ID := NULL;
2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;

Line 2112: l_cz_imp_rules.SUB_CONS_ID := NULL;

2108: -- Populate the cz_imp_rules record
2109: l_seq_nbr := l_seq_nbr + 1;
2110:
2111: l_cz_imp_rules.RULE_ID := NULL;
2112: l_cz_imp_rules.SUB_CONS_ID := NULL;
2113: l_cz_imp_rules.REASON_ID := NULL;
2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;

Line 2113: l_cz_imp_rules.REASON_ID := NULL;

2109: l_seq_nbr := l_seq_nbr + 1;
2110:
2111: l_cz_imp_rules.RULE_ID := NULL;
2112: l_cz_imp_rules.SUB_CONS_ID := NULL;
2113: l_cz_imp_rules.REASON_ID := NULL;
2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

Line 2114: l_cz_imp_rules.AMOUNT_ID := NULL;

2110:
2111: l_cz_imp_rules.RULE_ID := NULL;
2112: l_cz_imp_rules.SUB_CONS_ID := NULL;
2113: l_cz_imp_rules.REASON_ID := NULL;
2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule

Line 2115: l_cz_imp_rules.GRID_ID := NULL;

2111: l_cz_imp_rules.RULE_ID := NULL;
2112: l_cz_imp_rules.SUB_CONS_ID := NULL;
2113: l_cz_imp_rules.REASON_ID := NULL;
2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;

Line 2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;

2112: l_cz_imp_rules.SUB_CONS_ID := NULL;
2113: l_cz_imp_rules.REASON_ID := NULL;
2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check

Line 2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

2113: l_cz_imp_rules.REASON_ID := NULL;
2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;

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

2114: l_cz_imp_rules.AMOUNT_ID := NULL;
2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;

Line 2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;

2115: l_cz_imp_rules.GRID_ID := NULL;
2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule

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

2116: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule

Line 2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;

2117: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;

Line 2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;

2118: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule

Line 2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule

2119: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule

Line 2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule

2120: l_cz_imp_rules.NAME := l_rule_name; -- check
2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;

Line 2125: l_cz_imp_rules.COMPONENT_ID := NULL;

2121: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;

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

2122: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

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

2123: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check

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

2124: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;

Line 2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;

2125: l_cz_imp_rules.COMPONENT_ID := NULL;
2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;

Line 2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

2126: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

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

2127: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 2132: l_cz_imp_rules.EFF_FROM := NULL;

2128: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;

Line 2133: l_cz_imp_rules.EFF_TO := NULL;

2129: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;

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

2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;

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

2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2136: l_cz_imp_rules.SECURITY_MASK := NULL;

2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

Line 2137: l_cz_imp_rules.EFF_MASK := NULL;

2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;

Line 2138: l_cz_imp_rules.CHECKOUT_USER := NULL;

2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

Line 2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;

Line 2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;

2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;

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

2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;

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

2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;

Line 2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;

2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL

Line 2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;

2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;

Line 2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;

2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;

Line 2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;

2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value

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

2144: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;

Line 2149: l_cz_imp_rules.SIGNATURE_ID := NULL;

2145: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;

Line 2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;

2146: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;

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

2147: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;

Line 2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;

2148: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule

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

2149: l_cz_imp_rules.SIGNATURE_ID := NULL;
2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;

Line 2154: l_cz_imp_rules.NOTES := NULL;

2150: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value

Line 2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;

2151: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule

Line 2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule

2152: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;

Line 2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;

2153: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;

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

2154: l_cz_imp_rules.NOTES := NULL;
2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;

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

2155: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;

Line 2160: l_cz_imp_rules.UI_DEF_ID := NULL;

2156: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid

Line 2161: l_cz_imp_rules.UI_PAGE_ID := NULL;

2157: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;

Line 2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;

2158: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;

Line 2163: l_cz_imp_rules.MESSAGE := NULL;

2159: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

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

2160: l_cz_imp_rules.UI_DEF_ID := NULL;
2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;

Line 2165: l_cz_imp_rules.DISPOSITION := NULL;

2161: l_cz_imp_rules.UI_PAGE_ID := NULL;
2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

Line 2166: l_cz_imp_rules.REC_STATUS := NULL;

2162: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;

Line 2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

2163: l_cz_imp_rules.MESSAGE := NULL;
2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;

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

2164: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2172: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

Line 2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

2165: l_cz_imp_rules.DISPOSITION := NULL;
2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2172: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2173:

Line 2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;

2166: l_cz_imp_rules.REC_STATUS := NULL;
2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2172: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2173:
2174:

Line 2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;

2167: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2172: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2173:
2174:
2175: -- Insert into cz_imp_rules

Line 2172: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

2168: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2169: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2170: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2172: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2173:
2174:
2175: -- Insert into cz_imp_rules
2176:

Line 2175: -- Insert into cz_imp_rules

2171: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2172: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2173:
2174:
2175: -- Insert into cz_imp_rules
2176:
2177: INSERT INTO cz_imp_rules
2178: (
2179: RULE_ID,

Line 2177: INSERT INTO cz_imp_rules

2173:
2174:
2175: -- Insert into cz_imp_rules
2176:
2177: INSERT INTO cz_imp_rules
2178: (
2179: RULE_ID,
2180: SUB_CONS_ID,
2181: REASON_ID,

Line 2244: l_cz_imp_rules.RULE_ID,

2240: FSK_MODEL_REF_EXPL_ID
2241: )
2242: VALUES
2243: (
2244: l_cz_imp_rules.RULE_ID,
2245: l_cz_imp_rules.SUB_CONS_ID,
2246: l_cz_imp_rules.REASON_ID,
2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,

Line 2245: l_cz_imp_rules.SUB_CONS_ID,

2241: )
2242: VALUES
2243: (
2244: l_cz_imp_rules.RULE_ID,
2245: l_cz_imp_rules.SUB_CONS_ID,
2246: l_cz_imp_rules.REASON_ID,
2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,

Line 2246: l_cz_imp_rules.REASON_ID,

2242: VALUES
2243: (
2244: l_cz_imp_rules.RULE_ID,
2245: l_cz_imp_rules.SUB_CONS_ID,
2246: l_cz_imp_rules.REASON_ID,
2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,

Line 2247: l_cz_imp_rules.AMOUNT_ID,

2243: (
2244: l_cz_imp_rules.RULE_ID,
2245: l_cz_imp_rules.SUB_CONS_ID,
2246: l_cz_imp_rules.REASON_ID,
2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,

Line 2248: l_cz_imp_rules.GRID_ID,

2244: l_cz_imp_rules.RULE_ID,
2245: l_cz_imp_rules.SUB_CONS_ID,
2246: l_cz_imp_rules.REASON_ID,
2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,

Line 2249: l_cz_imp_rules.RULE_FOLDER_ID,

2245: l_cz_imp_rules.SUB_CONS_ID,
2246: l_cz_imp_rules.REASON_ID,
2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,

Line 2250: l_cz_imp_rules.DEVL_PROJECT_ID,

2246: l_cz_imp_rules.REASON_ID,
2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,

Line 2251: l_cz_imp_rules.INVALID_FLAG,

2247: l_cz_imp_rules.AMOUNT_ID,
2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,

Line 2252: l_cz_imp_rules.DESC_TEXT,

2248: l_cz_imp_rules.GRID_ID,
2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,

Line 2253: l_cz_imp_rules.NAME,

2249: l_cz_imp_rules.RULE_FOLDER_ID,
2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,

Line 2254: l_cz_imp_rules.ANTECEDENT_ID,

2250: l_cz_imp_rules.DEVL_PROJECT_ID,
2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,

Line 2255: l_cz_imp_rules.CONSEQUENT_ID,

2251: l_cz_imp_rules.INVALID_FLAG,
2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,

Line 2256: l_cz_imp_rules.RULE_TYPE,

2252: l_cz_imp_rules.DESC_TEXT,
2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,

Line 2257: l_cz_imp_rules.EXPR_RULE_TYPE,

2253: l_cz_imp_rules.NAME,
2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,

Line 2258: l_cz_imp_rules.COMPONENT_ID,

2254: l_cz_imp_rules.ANTECEDENT_ID,
2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,

Line 2259: l_cz_imp_rules.REASON_TYPE,

2255: l_cz_imp_rules.CONSEQUENT_ID,
2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,

Line 2260: l_cz_imp_rules.DISABLED_FLAG,

2256: l_cz_imp_rules.RULE_TYPE,
2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,

Line 2261: l_cz_imp_rules.ORIG_SYS_REF,

2257: l_cz_imp_rules.EXPR_RULE_TYPE,
2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,

Line 2262: l_cz_imp_rules.CREATION_DATE,

2258: l_cz_imp_rules.COMPONENT_ID,
2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,

Line 2263: l_cz_imp_rules.LAST_UPDATE_DATE,

2259: l_cz_imp_rules.REASON_TYPE,
2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,

Line 2264: l_cz_imp_rules.DELETED_FLAG,

2260: l_cz_imp_rules.DISABLED_FLAG,
2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,

Line 2265: l_cz_imp_rules.EFF_FROM,

2261: l_cz_imp_rules.ORIG_SYS_REF,
2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,

Line 2266: l_cz_imp_rules.EFF_TO,

2262: l_cz_imp_rules.CREATION_DATE,
2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,

Line 2267: l_cz_imp_rules.CREATED_BY,

2263: l_cz_imp_rules.LAST_UPDATE_DATE,
2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,

Line 2268: l_cz_imp_rules.LAST_UPDATED_BY,

2264: l_cz_imp_rules.DELETED_FLAG,
2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,

Line 2269: l_cz_imp_rules.SECURITY_MASK,

2265: l_cz_imp_rules.EFF_FROM,
2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

Line 2270: l_cz_imp_rules.EFF_MASK,

2266: l_cz_imp_rules.EFF_TO,
2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,

Line 2271: l_cz_imp_rules.CHECKOUT_USER,

2267: l_cz_imp_rules.CREATED_BY,
2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,

Line 2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,

2268: l_cz_imp_rules.LAST_UPDATED_BY,
2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,

Line 2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

2269: l_cz_imp_rules.SECURITY_MASK,
2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,

Line 2274: l_cz_imp_rules.SEQ_NBR,

2270: l_cz_imp_rules.EFF_MASK,
2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,

Line 2275: l_cz_imp_rules.EFFECTIVE_FROM,

2271: l_cz_imp_rules.CHECKOUT_USER,
2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,

Line 2276: l_cz_imp_rules.EFFECTIVE_UNTIL,

2272: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,

Line 2277: l_cz_imp_rules.PERSISTENT_RULE_ID,

2273: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

Line 2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,

2274: l_cz_imp_rules.SEQ_NBR,
2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,

Line 2279: l_cz_imp_rules.RULE_FOLDER_TYPE,

2275: l_cz_imp_rules.EFFECTIVE_FROM,
2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

Line 2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,

2276: l_cz_imp_rules.EFFECTIVE_UNTIL,
2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2284: l_cz_imp_rules.PRESENTATION_FLAG,

Line 2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

2277: l_cz_imp_rules.PERSISTENT_RULE_ID,
2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2284: l_cz_imp_rules.PRESENTATION_FLAG,
2285: l_cz_imp_rules.TEMPLATE_TOKEN,

Line 2282: l_cz_imp_rules.SIGNATURE_ID,

2278: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2284: l_cz_imp_rules.PRESENTATION_FLAG,
2285: l_cz_imp_rules.TEMPLATE_TOKEN,
2286: --l_cz_imp_rules.RULE_TEXT,

Line 2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

2279: l_cz_imp_rules.RULE_FOLDER_TYPE,
2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2284: l_cz_imp_rules.PRESENTATION_FLAG,
2285: l_cz_imp_rules.TEMPLATE_TOKEN,
2286: --l_cz_imp_rules.RULE_TEXT,
2287: G_XTN_RULE_TEXT,

Line 2284: l_cz_imp_rules.PRESENTATION_FLAG,

2280: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2284: l_cz_imp_rules.PRESENTATION_FLAG,
2285: l_cz_imp_rules.TEMPLATE_TOKEN,
2286: --l_cz_imp_rules.RULE_TEXT,
2287: G_XTN_RULE_TEXT,
2288: l_cz_imp_rules.NOTES,

Line 2285: l_cz_imp_rules.TEMPLATE_TOKEN,

2281: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2284: l_cz_imp_rules.PRESENTATION_FLAG,
2285: l_cz_imp_rules.TEMPLATE_TOKEN,
2286: --l_cz_imp_rules.RULE_TEXT,
2287: G_XTN_RULE_TEXT,
2288: l_cz_imp_rules.NOTES,
2289: l_cz_imp_rules.CLASS_NAME,

Line 2286: --l_cz_imp_rules.RULE_TEXT,

2282: l_cz_imp_rules.SIGNATURE_ID,
2283: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2284: l_cz_imp_rules.PRESENTATION_FLAG,
2285: l_cz_imp_rules.TEMPLATE_TOKEN,
2286: --l_cz_imp_rules.RULE_TEXT,
2287: G_XTN_RULE_TEXT,
2288: l_cz_imp_rules.NOTES,
2289: l_cz_imp_rules.CLASS_NAME,
2290: l_cz_imp_rules.INSTANTIATION_SCOPE,

Line 2288: l_cz_imp_rules.NOTES,

2284: l_cz_imp_rules.PRESENTATION_FLAG,
2285: l_cz_imp_rules.TEMPLATE_TOKEN,
2286: --l_cz_imp_rules.RULE_TEXT,
2287: G_XTN_RULE_TEXT,
2288: l_cz_imp_rules.NOTES,
2289: l_cz_imp_rules.CLASS_NAME,
2290: l_cz_imp_rules.INSTANTIATION_SCOPE,
2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,

Line 2289: l_cz_imp_rules.CLASS_NAME,

2285: l_cz_imp_rules.TEMPLATE_TOKEN,
2286: --l_cz_imp_rules.RULE_TEXT,
2287: G_XTN_RULE_TEXT,
2288: l_cz_imp_rules.NOTES,
2289: l_cz_imp_rules.CLASS_NAME,
2290: l_cz_imp_rules.INSTANTIATION_SCOPE,
2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,

Line 2290: l_cz_imp_rules.INSTANTIATION_SCOPE,

2286: --l_cz_imp_rules.RULE_TEXT,
2287: G_XTN_RULE_TEXT,
2288: l_cz_imp_rules.NOTES,
2289: l_cz_imp_rules.CLASS_NAME,
2290: l_cz_imp_rules.INSTANTIATION_SCOPE,
2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,

Line 2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,

2287: G_XTN_RULE_TEXT,
2288: l_cz_imp_rules.NOTES,
2289: l_cz_imp_rules.CLASS_NAME,
2290: l_cz_imp_rules.INSTANTIATION_SCOPE,
2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,

Line 2292: l_cz_imp_rules.MUTABLE_FLAG,

2288: l_cz_imp_rules.NOTES,
2289: l_cz_imp_rules.CLASS_NAME,
2290: l_cz_imp_rules.INSTANTIATION_SCOPE,
2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,

Line 2293: l_cz_imp_rules.SEEDED_FLAG,

2289: l_cz_imp_rules.CLASS_NAME,
2290: l_cz_imp_rules.INSTANTIATION_SCOPE,
2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,

Line 2294: l_cz_imp_rules.UI_DEF_ID,

2290: l_cz_imp_rules.INSTANTIATION_SCOPE,
2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,

Line 2295: l_cz_imp_rules.UI_PAGE_ID,

2291: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,

Line 2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,

2292: l_cz_imp_rules.MUTABLE_FLAG,
2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,

Line 2297: l_cz_imp_rules.MESSAGE,

2293: l_cz_imp_rules.SEEDED_FLAG,
2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,

Line 2298: l_cz_imp_rules.RUN_ID,

2294: l_cz_imp_rules.UI_DEF_ID,
2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

Line 2299: l_cz_imp_rules.DISPOSITION,

2295: l_cz_imp_rules.UI_PAGE_ID,
2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

Line 2300: l_cz_imp_rules.REC_STATUS,

2296: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2304: l_cz_imp_rules.IMPORT_PROG_VERSION,

Line 2301: l_cz_imp_rules.FSK_DEVL_PROJECT,

2297: l_cz_imp_rules.MESSAGE,
2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2304: l_cz_imp_rules.IMPORT_PROG_VERSION,
2305: l_cz_imp_rules.FSK_COMPONENT_ID,

Line 2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

2298: l_cz_imp_rules.RUN_ID,
2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2304: l_cz_imp_rules.IMPORT_PROG_VERSION,
2305: l_cz_imp_rules.FSK_COMPONENT_ID,
2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

Line 2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

2299: l_cz_imp_rules.DISPOSITION,
2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2304: l_cz_imp_rules.IMPORT_PROG_VERSION,
2305: l_cz_imp_rules.FSK_COMPONENT_ID,
2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2307: );

Line 2304: l_cz_imp_rules.IMPORT_PROG_VERSION,

2300: l_cz_imp_rules.REC_STATUS,
2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2304: l_cz_imp_rules.IMPORT_PROG_VERSION,
2305: l_cz_imp_rules.FSK_COMPONENT_ID,
2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2307: );
2308: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2305: l_cz_imp_rules.FSK_COMPONENT_ID,

2301: l_cz_imp_rules.FSK_DEVL_PROJECT,
2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2304: l_cz_imp_rules.IMPORT_PROG_VERSION,
2305: l_cz_imp_rules.FSK_COMPONENT_ID,
2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2307: );
2308: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

2302: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2303: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2304: l_cz_imp_rules.IMPORT_PROG_VERSION,
2305: l_cz_imp_rules.FSK_COMPONENT_ID,
2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2307: );
2308: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2310: G_MODULE||l_api_name,

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

2307: );
2308: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2310: G_MODULE||l_api_name,
2311: '170: After Insert into cz_imp_rules' || '='||l_intent);
2312: END IF;
2313:
2314: END IF; -- check extn rule exists
2315:

Line 2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;

2406: l_api_name CONSTANT VARCHAR2(30) := 'attach_extension_rule_tmpl';
2407: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2408: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;
2413: l_rule_description cz_imp_rules.desc_text%TYPE;
2414: l_rule_text cz_imp_rules.rule_text%TYPE;

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

2407: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
2408: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;
2413: l_rule_description cz_imp_rules.desc_text%TYPE;
2414: l_rule_text cz_imp_rules.rule_text%TYPE;
2415: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;

Line 2412: l_rule_name cz_imp_rules.NAME%TYPE;

2408: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;
2413: l_rule_description cz_imp_rules.desc_text%TYPE;
2414: l_rule_text cz_imp_rules.rule_text%TYPE;
2415: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2416: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;

Line 2413: l_rule_description cz_imp_rules.desc_text%TYPE;

2409: l_intent okc_xprt_rule_hdrs_all.intent%TYPE;
2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;
2413: l_rule_description cz_imp_rules.desc_text%TYPE;
2414: l_rule_text cz_imp_rules.rule_text%TYPE;
2415: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2416: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2417:

Line 2414: l_rule_text cz_imp_rules.rule_text%TYPE;

2410: l_deleted_flag cz_imp_rules.deleted_flag%TYPE;
2411: l_seq_nbr cz_imp_rules.seq_nbr%TYPE := 0;
2412: l_rule_name cz_imp_rules.NAME%TYPE;
2413: l_rule_description cz_imp_rules.desc_text%TYPE;
2414: l_rule_text cz_imp_rules.rule_text%TYPE;
2415: l_model_id cz_imp_localized_texts.MODEL_ID%TYPE;
2416: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2417:
2418: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

Line 2420: l_cz_imp_rules cz_imp_rules%ROWTYPE;

2416: l_model_osr cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
2417:
2418: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
2419:
2420: l_cz_imp_rules cz_imp_rules%ROWTYPE;
2421:
2422: BEGIN
2423: -- start debug log
2424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2547: -- Populate the cz_imp_rules record

2543: END LOOP;
2544: CLOSE csr_installed_languages;
2545:
2546:
2547: -- Populate the cz_imp_rules record
2548: l_seq_nbr := l_seq_nbr + 1;
2549:
2550: l_cz_imp_rules.RULE_ID := NULL;
2551: l_cz_imp_rules.SUB_CONS_ID := NULL;

Line 2550: l_cz_imp_rules.RULE_ID := NULL;

2546:
2547: -- Populate the cz_imp_rules record
2548: l_seq_nbr := l_seq_nbr + 1;
2549:
2550: l_cz_imp_rules.RULE_ID := NULL;
2551: l_cz_imp_rules.SUB_CONS_ID := NULL;
2552: l_cz_imp_rules.REASON_ID := NULL;
2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;

Line 2551: l_cz_imp_rules.SUB_CONS_ID := NULL;

2547: -- Populate the cz_imp_rules record
2548: l_seq_nbr := l_seq_nbr + 1;
2549:
2550: l_cz_imp_rules.RULE_ID := NULL;
2551: l_cz_imp_rules.SUB_CONS_ID := NULL;
2552: l_cz_imp_rules.REASON_ID := NULL;
2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;

Line 2552: l_cz_imp_rules.REASON_ID := NULL;

2548: l_seq_nbr := l_seq_nbr + 1;
2549:
2550: l_cz_imp_rules.RULE_ID := NULL;
2551: l_cz_imp_rules.SUB_CONS_ID := NULL;
2552: l_cz_imp_rules.REASON_ID := NULL;
2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

Line 2553: l_cz_imp_rules.AMOUNT_ID := NULL;

2549:
2550: l_cz_imp_rules.RULE_ID := NULL;
2551: l_cz_imp_rules.SUB_CONS_ID := NULL;
2552: l_cz_imp_rules.REASON_ID := NULL;
2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule

Line 2554: l_cz_imp_rules.GRID_ID := NULL;

2550: l_cz_imp_rules.RULE_ID := NULL;
2551: l_cz_imp_rules.SUB_CONS_ID := NULL;
2552: l_cz_imp_rules.REASON_ID := NULL;
2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;

Line 2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;

2551: l_cz_imp_rules.SUB_CONS_ID := NULL;
2552: l_cz_imp_rules.REASON_ID := NULL;
2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check

Line 2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;

2552: l_cz_imp_rules.REASON_ID := NULL;
2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;

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

2553: l_cz_imp_rules.AMOUNT_ID := NULL;
2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;

Line 2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;

2554: l_cz_imp_rules.GRID_ID := NULL;
2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule

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

2555: l_cz_imp_rules.RULE_FOLDER_ID := NULL;
2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule

Line 2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;

2556: l_cz_imp_rules.DEVL_PROJECT_ID := l_model_id;
2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;

Line 2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;

2557: l_cz_imp_rules.INVALID_FLAG := '0'; --Default value for valid rule
2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule

Line 2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule

2558: l_cz_imp_rules.DESC_TEXT := l_rule_description;
2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule

Line 2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule

2559: l_cz_imp_rules.NAME := l_rule_name; -- check
2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;

Line 2564: l_cz_imp_rules.COMPONENT_ID := NULL;

2560: l_cz_imp_rules.ANTECEDENT_ID := NULL;
2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;

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

2561: l_cz_imp_rules.CONSEQUENT_ID := NULL;
2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

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

2562: l_cz_imp_rules.RULE_TYPE := 300; -- Extension Rule
2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check

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

2563: l_cz_imp_rules.EXPR_RULE_TYPE := NULL; --1; --Needed for Extension rule
2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;

Line 2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;

2564: l_cz_imp_rules.COMPONENT_ID := NULL;
2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;

Line 2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;

2565: l_cz_imp_rules.REASON_TYPE := 0; -- Value in reason_id corresponds to Name of Rule
2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

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

2566: l_cz_imp_rules.DISABLED_FLAG := '0'; -- Indicates enabled rule
2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 2571: l_cz_imp_rules.EFF_FROM := NULL;

2567: l_cz_imp_rules.ORIG_SYS_REF := G_XTN_RULE_OSR||l_intent;
2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;

Line 2572: l_cz_imp_rules.EFF_TO := NULL;

2568: l_cz_imp_rules.CREATION_DATE := SYSDATE;
2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;

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

2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;

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

2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2575: l_cz_imp_rules.SECURITY_MASK := NULL;

2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

Line 2576: l_cz_imp_rules.EFF_MASK := NULL;

2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;

Line 2577: l_cz_imp_rules.CHECKOUT_USER := NULL;

2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

Line 2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;

2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;

Line 2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;

2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;

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

2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;

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

2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;

Line 2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;

2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL

Line 2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;

2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;

Line 2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;

2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;

Line 2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;

2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value

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

2583: l_cz_imp_rules.PERSISTENT_RULE_ID := NULL;
2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;

Line 2588: l_cz_imp_rules.SIGNATURE_ID := NULL;

2584: l_cz_imp_rules.EFFECTIVITY_SET_ID := NULL;
2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;

Line 2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;

2585: l_cz_imp_rules.RULE_FOLDER_TYPE := NULL;
2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;

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

2586: l_cz_imp_rules.UNSATISFIED_MSG_ID := NULL;
2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;

Line 2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;

2587: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE := '0'; -- Changed from NULL
2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule

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

2588: l_cz_imp_rules.SIGNATURE_ID := NULL;
2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;

Line 2593: l_cz_imp_rules.NOTES := NULL;

2589: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG := NULL;
2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value

Line 2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;

2590: l_cz_imp_rules.PRESENTATION_FLAG := NULL; --'0'; --Default value
2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule

Line 2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule

2591: l_cz_imp_rules.TEMPLATE_TOKEN := NULL;
2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;

Line 2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;

2592: -- l_cz_imp_rules.RULE_TEXT := G_XTN_RULE_TEXT;
2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;

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

2593: l_cz_imp_rules.NOTES := NULL;
2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;

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

2594: l_cz_imp_rules.CLASS_NAME := G_XTN_RULE_CLASS_NAME;
2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;

Line 2599: l_cz_imp_rules.UI_DEF_ID := NULL;

2595: l_cz_imp_rules.INSTANTIATION_SCOPE := 1; -- Needed for Extension rule
2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid

Line 2600: l_cz_imp_rules.UI_PAGE_ID := NULL;

2596: l_cz_imp_rules.MODEL_REF_EXPL_ID := NULL;
2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;

Line 2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;

2597: l_cz_imp_rules.MUTABLE_FLAG := '0'; --Default value
2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;

Line 2602: l_cz_imp_rules.MESSAGE := NULL;

2598: l_cz_imp_rules.SEEDED_FLAG := NULL; --Seeded CX rule
2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

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

2599: l_cz_imp_rules.UI_DEF_ID := NULL;
2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;

Line 2604: l_cz_imp_rules.DISPOSITION := NULL;

2600: l_cz_imp_rules.UI_PAGE_ID := NULL;
2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

Line 2605: l_cz_imp_rules.REC_STATUS := NULL;

2601: l_cz_imp_rules.UI_PAGE_ELEMENT_ID := NULL;
2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;

Line 2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;

2602: l_cz_imp_rules.MESSAGE := NULL;
2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;

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

2603: l_cz_imp_rules.RUN_ID := p_run_id; -- Input runid
2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2611: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

Line 2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;

2604: l_cz_imp_rules.DISPOSITION := NULL;
2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2611: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2612:

Line 2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;

2605: l_cz_imp_rules.REC_STATUS := NULL;
2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2611: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2612:
2613:

Line 2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;

2606: l_cz_imp_rules.FSK_DEVL_PROJECT := l_model_osr;
2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2611: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2612:
2613:
2614: -- Insert into cz_imp_rules

Line 2611: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;

2607: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1 := G_XTN_RULE_OSR||l_intent;
2608: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2 := NULL;
2609: l_cz_imp_rules.IMPORT_PROG_VERSION := NULL;
2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2611: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2612:
2613:
2614: -- Insert into cz_imp_rules
2615:

Line 2614: -- Insert into cz_imp_rules

2610: l_cz_imp_rules.FSK_COMPONENT_ID := NULL;
2611: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID := NULL;
2612:
2613:
2614: -- Insert into cz_imp_rules
2615:
2616: INSERT INTO cz_imp_rules
2617: (
2618: RULE_ID,

Line 2616: INSERT INTO cz_imp_rules

2612:
2613:
2614: -- Insert into cz_imp_rules
2615:
2616: INSERT INTO cz_imp_rules
2617: (
2618: RULE_ID,
2619: SUB_CONS_ID,
2620: REASON_ID,

Line 2683: l_cz_imp_rules.RULE_ID,

2679: FSK_MODEL_REF_EXPL_ID
2680: )
2681: VALUES
2682: (
2683: l_cz_imp_rules.RULE_ID,
2684: l_cz_imp_rules.SUB_CONS_ID,
2685: l_cz_imp_rules.REASON_ID,
2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,

Line 2684: l_cz_imp_rules.SUB_CONS_ID,

2680: )
2681: VALUES
2682: (
2683: l_cz_imp_rules.RULE_ID,
2684: l_cz_imp_rules.SUB_CONS_ID,
2685: l_cz_imp_rules.REASON_ID,
2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,

Line 2685: l_cz_imp_rules.REASON_ID,

2681: VALUES
2682: (
2683: l_cz_imp_rules.RULE_ID,
2684: l_cz_imp_rules.SUB_CONS_ID,
2685: l_cz_imp_rules.REASON_ID,
2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,

Line 2686: l_cz_imp_rules.AMOUNT_ID,

2682: (
2683: l_cz_imp_rules.RULE_ID,
2684: l_cz_imp_rules.SUB_CONS_ID,
2685: l_cz_imp_rules.REASON_ID,
2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,

Line 2687: l_cz_imp_rules.GRID_ID,

2683: l_cz_imp_rules.RULE_ID,
2684: l_cz_imp_rules.SUB_CONS_ID,
2685: l_cz_imp_rules.REASON_ID,
2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,

Line 2688: l_cz_imp_rules.RULE_FOLDER_ID,

2684: l_cz_imp_rules.SUB_CONS_ID,
2685: l_cz_imp_rules.REASON_ID,
2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,

Line 2689: l_cz_imp_rules.DEVL_PROJECT_ID,

2685: l_cz_imp_rules.REASON_ID,
2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,

Line 2690: l_cz_imp_rules.INVALID_FLAG,

2686: l_cz_imp_rules.AMOUNT_ID,
2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,

Line 2691: l_cz_imp_rules.DESC_TEXT,

2687: l_cz_imp_rules.GRID_ID,
2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,

Line 2692: l_cz_imp_rules.NAME,

2688: l_cz_imp_rules.RULE_FOLDER_ID,
2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,

Line 2693: l_cz_imp_rules.ANTECEDENT_ID,

2689: l_cz_imp_rules.DEVL_PROJECT_ID,
2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,

Line 2694: l_cz_imp_rules.CONSEQUENT_ID,

2690: l_cz_imp_rules.INVALID_FLAG,
2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,

Line 2695: l_cz_imp_rules.RULE_TYPE,

2691: l_cz_imp_rules.DESC_TEXT,
2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,

Line 2696: l_cz_imp_rules.EXPR_RULE_TYPE,

2692: l_cz_imp_rules.NAME,
2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,

Line 2697: l_cz_imp_rules.COMPONENT_ID,

2693: l_cz_imp_rules.ANTECEDENT_ID,
2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,

Line 2698: l_cz_imp_rules.REASON_TYPE,

2694: l_cz_imp_rules.CONSEQUENT_ID,
2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,

Line 2699: l_cz_imp_rules.DISABLED_FLAG,

2695: l_cz_imp_rules.RULE_TYPE,
2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,

Line 2700: l_cz_imp_rules.ORIG_SYS_REF,

2696: l_cz_imp_rules.EXPR_RULE_TYPE,
2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,

Line 2701: l_cz_imp_rules.CREATION_DATE,

2697: l_cz_imp_rules.COMPONENT_ID,
2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,

Line 2702: l_cz_imp_rules.LAST_UPDATE_DATE,

2698: l_cz_imp_rules.REASON_TYPE,
2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,

Line 2703: l_cz_imp_rules.DELETED_FLAG,

2699: l_cz_imp_rules.DISABLED_FLAG,
2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,

Line 2704: l_cz_imp_rules.EFF_FROM,

2700: l_cz_imp_rules.ORIG_SYS_REF,
2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,

Line 2705: l_cz_imp_rules.EFF_TO,

2701: l_cz_imp_rules.CREATION_DATE,
2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,

Line 2706: l_cz_imp_rules.CREATED_BY,

2702: l_cz_imp_rules.LAST_UPDATE_DATE,
2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,

Line 2707: l_cz_imp_rules.LAST_UPDATED_BY,

2703: l_cz_imp_rules.DELETED_FLAG,
2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,

Line 2708: l_cz_imp_rules.SECURITY_MASK,

2704: l_cz_imp_rules.EFF_FROM,
2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

Line 2709: l_cz_imp_rules.EFF_MASK,

2705: l_cz_imp_rules.EFF_TO,
2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,

Line 2710: l_cz_imp_rules.CHECKOUT_USER,

2706: l_cz_imp_rules.CREATED_BY,
2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,

Line 2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,

2707: l_cz_imp_rules.LAST_UPDATED_BY,
2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,

Line 2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,

2708: l_cz_imp_rules.SECURITY_MASK,
2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,

Line 2713: l_cz_imp_rules.SEQ_NBR,

2709: l_cz_imp_rules.EFF_MASK,
2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,

Line 2714: l_cz_imp_rules.EFFECTIVE_FROM,

2710: l_cz_imp_rules.CHECKOUT_USER,
2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,

Line 2715: l_cz_imp_rules.EFFECTIVE_UNTIL,

2711: l_cz_imp_rules.LAST_UPDATE_LOGIN,
2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,

Line 2716: l_cz_imp_rules.PERSISTENT_RULE_ID,

2712: l_cz_imp_rules.EFFECTIVE_USAGE_MASK,
2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

Line 2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,

2713: l_cz_imp_rules.SEQ_NBR,
2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,

Line 2718: l_cz_imp_rules.RULE_FOLDER_TYPE,

2714: l_cz_imp_rules.EFFECTIVE_FROM,
2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

Line 2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,

2715: l_cz_imp_rules.EFFECTIVE_UNTIL,
2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2723: l_cz_imp_rules.PRESENTATION_FLAG,

Line 2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,

2716: l_cz_imp_rules.PERSISTENT_RULE_ID,
2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2723: l_cz_imp_rules.PRESENTATION_FLAG,
2724: l_cz_imp_rules.TEMPLATE_TOKEN,

Line 2721: l_cz_imp_rules.SIGNATURE_ID,

2717: l_cz_imp_rules.EFFECTIVITY_SET_ID,
2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2723: l_cz_imp_rules.PRESENTATION_FLAG,
2724: l_cz_imp_rules.TEMPLATE_TOKEN,
2725: --l_cz_imp_rules.RULE_TEXT,

Line 2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,

2718: l_cz_imp_rules.RULE_FOLDER_TYPE,
2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2723: l_cz_imp_rules.PRESENTATION_FLAG,
2724: l_cz_imp_rules.TEMPLATE_TOKEN,
2725: --l_cz_imp_rules.RULE_TEXT,
2726: G_XTN_RULE_TEXT,

Line 2723: l_cz_imp_rules.PRESENTATION_FLAG,

2719: l_cz_imp_rules.UNSATISFIED_MSG_ID,
2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2723: l_cz_imp_rules.PRESENTATION_FLAG,
2724: l_cz_imp_rules.TEMPLATE_TOKEN,
2725: --l_cz_imp_rules.RULE_TEXT,
2726: G_XTN_RULE_TEXT,
2727: l_cz_imp_rules.NOTES,

Line 2724: l_cz_imp_rules.TEMPLATE_TOKEN,

2720: l_cz_imp_rules.UNSATISFIED_MSG_SOURCE,
2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2723: l_cz_imp_rules.PRESENTATION_FLAG,
2724: l_cz_imp_rules.TEMPLATE_TOKEN,
2725: --l_cz_imp_rules.RULE_TEXT,
2726: G_XTN_RULE_TEXT,
2727: l_cz_imp_rules.NOTES,
2728: l_cz_imp_rules.CLASS_NAME,

Line 2725: --l_cz_imp_rules.RULE_TEXT,

2721: l_cz_imp_rules.SIGNATURE_ID,
2722: l_cz_imp_rules.TEMPLATE_PRIMITIVE_FLAG,
2723: l_cz_imp_rules.PRESENTATION_FLAG,
2724: l_cz_imp_rules.TEMPLATE_TOKEN,
2725: --l_cz_imp_rules.RULE_TEXT,
2726: G_XTN_RULE_TEXT,
2727: l_cz_imp_rules.NOTES,
2728: l_cz_imp_rules.CLASS_NAME,
2729: l_cz_imp_rules.INSTANTIATION_SCOPE,

Line 2727: l_cz_imp_rules.NOTES,

2723: l_cz_imp_rules.PRESENTATION_FLAG,
2724: l_cz_imp_rules.TEMPLATE_TOKEN,
2725: --l_cz_imp_rules.RULE_TEXT,
2726: G_XTN_RULE_TEXT,
2727: l_cz_imp_rules.NOTES,
2728: l_cz_imp_rules.CLASS_NAME,
2729: l_cz_imp_rules.INSTANTIATION_SCOPE,
2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,

Line 2728: l_cz_imp_rules.CLASS_NAME,

2724: l_cz_imp_rules.TEMPLATE_TOKEN,
2725: --l_cz_imp_rules.RULE_TEXT,
2726: G_XTN_RULE_TEXT,
2727: l_cz_imp_rules.NOTES,
2728: l_cz_imp_rules.CLASS_NAME,
2729: l_cz_imp_rules.INSTANTIATION_SCOPE,
2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,

Line 2729: l_cz_imp_rules.INSTANTIATION_SCOPE,

2725: --l_cz_imp_rules.RULE_TEXT,
2726: G_XTN_RULE_TEXT,
2727: l_cz_imp_rules.NOTES,
2728: l_cz_imp_rules.CLASS_NAME,
2729: l_cz_imp_rules.INSTANTIATION_SCOPE,
2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,

Line 2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,

2726: G_XTN_RULE_TEXT,
2727: l_cz_imp_rules.NOTES,
2728: l_cz_imp_rules.CLASS_NAME,
2729: l_cz_imp_rules.INSTANTIATION_SCOPE,
2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,

Line 2731: l_cz_imp_rules.MUTABLE_FLAG,

2727: l_cz_imp_rules.NOTES,
2728: l_cz_imp_rules.CLASS_NAME,
2729: l_cz_imp_rules.INSTANTIATION_SCOPE,
2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,

Line 2732: l_cz_imp_rules.SEEDED_FLAG,

2728: l_cz_imp_rules.CLASS_NAME,
2729: l_cz_imp_rules.INSTANTIATION_SCOPE,
2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,

Line 2733: l_cz_imp_rules.UI_DEF_ID,

2729: l_cz_imp_rules.INSTANTIATION_SCOPE,
2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,

Line 2734: l_cz_imp_rules.UI_PAGE_ID,

2730: l_cz_imp_rules.MODEL_REF_EXPL_ID,
2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,

Line 2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,

2731: l_cz_imp_rules.MUTABLE_FLAG,
2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,

Line 2736: l_cz_imp_rules.MESSAGE,

2732: l_cz_imp_rules.SEEDED_FLAG,
2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,

Line 2737: l_cz_imp_rules.RUN_ID,

2733: l_cz_imp_rules.UI_DEF_ID,
2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

Line 2738: l_cz_imp_rules.DISPOSITION,

2734: l_cz_imp_rules.UI_PAGE_ID,
2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

Line 2739: l_cz_imp_rules.REC_STATUS,

2735: l_cz_imp_rules.UI_PAGE_ELEMENT_ID,
2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2743: l_cz_imp_rules.IMPORT_PROG_VERSION,

Line 2740: l_cz_imp_rules.FSK_DEVL_PROJECT,

2736: l_cz_imp_rules.MESSAGE,
2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2743: l_cz_imp_rules.IMPORT_PROG_VERSION,
2744: l_cz_imp_rules.FSK_COMPONENT_ID,

Line 2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,

2737: l_cz_imp_rules.RUN_ID,
2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2743: l_cz_imp_rules.IMPORT_PROG_VERSION,
2744: l_cz_imp_rules.FSK_COMPONENT_ID,
2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

Line 2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,

2738: l_cz_imp_rules.DISPOSITION,
2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2743: l_cz_imp_rules.IMPORT_PROG_VERSION,
2744: l_cz_imp_rules.FSK_COMPONENT_ID,
2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2746: );

Line 2743: l_cz_imp_rules.IMPORT_PROG_VERSION,

2739: l_cz_imp_rules.REC_STATUS,
2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2743: l_cz_imp_rules.IMPORT_PROG_VERSION,
2744: l_cz_imp_rules.FSK_COMPONENT_ID,
2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2746: );
2747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2744: l_cz_imp_rules.FSK_COMPONENT_ID,

2740: l_cz_imp_rules.FSK_DEVL_PROJECT,
2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2743: l_cz_imp_rules.IMPORT_PROG_VERSION,
2744: l_cz_imp_rules.FSK_COMPONENT_ID,
2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2746: );
2747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID

2741: l_cz_imp_rules.FSK_LOCALIZED_TEXT_1,
2742: l_cz_imp_rules.FSK_LOCALIZED_TEXT_2,
2743: l_cz_imp_rules.IMPORT_PROG_VERSION,
2744: l_cz_imp_rules.FSK_COMPONENT_ID,
2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2746: );
2747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2749: G_MODULE||l_api_name,

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

2746: );
2747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2749: G_MODULE||l_api_name,
2750: '170: After Insert into cz_imp_rules' || '='||l_intent);
2751: END IF;
2752:
2753: END IF; -- check extn rule exists
2754: