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.CZ_RULE_IMPORT dependencies on CZ_IMP_RULES

Line 50: FROM cz_imp_rules

46: presentation_flag, effective_usage_mask, seq_nbr, disposition,
47: component_id, model_ref_expl_id, fsk_component_id, fsk_model_ref_expl_id,
48: instantiation_scope,
49: rule_class, class_seq,config_engine_type,accumulator_flag,top_level_constraint_flag -- Bug9467066
50: FROM cz_imp_rules
51: WHERE run_id = p_run_id
52: AND rec_status IS NULL
53: AND disposition IS NULL;
54:

Line 124: UPDATE cz_imp_rules SET

120: PROCEDURE update_table_data(p_upper_limit IN PLS_INTEGER) IS
121: BEGIN
122:
123: FORALL i IN 1..p_upper_limit
124: UPDATE cz_imp_rules SET
125: message = t_message(i),
126: seeded_flag = t_seeded_flag(i),
127: deleted_flag = t_deleted_flag(i),
128: rec_status = CZRI_RECSTATUS_CND,

Line 395: nOnlRuleId CZ_IMP_RULES.RULE_ID%TYPE;

391: x_msg_data IN OUT NOCOPY VARCHAR2) IS
392:
393: v_debug NUMBER := 7000;
394: v_error_flag PLS_INTEGER;
395: nOnlRuleId CZ_IMP_RULES.RULE_ID%TYPE;
396: nOnlDevlProjId CZ_IMP_RULES.DEVL_PROJECT_ID%TYPE;
397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;
398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;

Line 396: nOnlDevlProjId CZ_IMP_RULES.DEVL_PROJECT_ID%TYPE;

392:
393: v_debug NUMBER := 7000;
394: v_error_flag PLS_INTEGER;
395: nOnlRuleId CZ_IMP_RULES.RULE_ID%TYPE;
396: nOnlDevlProjId CZ_IMP_RULES.DEVL_PROJECT_ID%TYPE;
397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;
398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;

Line 397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;

393: v_debug NUMBER := 7000;
394: v_error_flag PLS_INTEGER;
395: nOnlRuleId CZ_IMP_RULES.RULE_ID%TYPE;
396: nOnlDevlProjId CZ_IMP_RULES.DEVL_PROJECT_ID%TYPE;
397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;
398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;

Line 398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;

394: v_error_flag PLS_INTEGER;
395: nOnlRuleId CZ_IMP_RULES.RULE_ID%TYPE;
396: nOnlDevlProjId CZ_IMP_RULES.DEVL_PROJECT_ID%TYPE;
397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;
398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;

Line 399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;

395: nOnlRuleId CZ_IMP_RULES.RULE_ID%TYPE;
396: nOnlDevlProjId CZ_IMP_RULES.DEVL_PROJECT_ID%TYPE;
397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;
398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;

Line 400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;

396: nOnlDevlProjId CZ_IMP_RULES.DEVL_PROJECT_ID%TYPE;
397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;
398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;

Line 401: nOnlName CZ_IMP_RULES.NAME%TYPE;

397: nOnlDescText CZ_IMP_RULES.DESC_TEXT%TYPE;
398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;

Line 402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;

398: nOnlOrigSysRef CZ_IMP_RULES.ORIG_SYS_REF%TYPE;
399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;
406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;

Line 403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;

399: nOnlRulefolderId CZ_IMP_RULES.RULE_FOLDER_ID%TYPE;
400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;
406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;
407: nOnlInstScope CZ_IMP_RULES.INSTANTIATION_SCOPE%TYPE;

Line 404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;

400: nOnlRuleType CZ_IMP_RULES.RULE_TYPE%TYPE;
401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;
406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;
407: nOnlInstScope CZ_IMP_RULES.INSTANTIATION_SCOPE%TYPE;
408: nOnlRuleText CZ_IMP_RULES.RULE_TEXT%TYPE;

Line 405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;

401: nOnlName CZ_IMP_RULES.NAME%TYPE;
402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;
406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;
407: nOnlInstScope CZ_IMP_RULES.INSTANTIATION_SCOPE%TYPE;
408: nOnlRuleText CZ_IMP_RULES.RULE_TEXT%TYPE;
409:

Line 406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;

402: nOnlDelFlag CZ_IMP_RULES.DELETED_FLAG%TYPE;
403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;
406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;
407: nOnlInstScope CZ_IMP_RULES.INSTANTIATION_SCOPE%TYPE;
408: nOnlRuleText CZ_IMP_RULES.RULE_TEXT%TYPE;
409:
410: CURSOR c_rec IS

Line 407: nOnlInstScope CZ_IMP_RULES.INSTANTIATION_SCOPE%TYPE;

403: nOnlMutFlag CZ_IMP_RULES.MUTABLE_FLAG%TYPE;
404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;
406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;
407: nOnlInstScope CZ_IMP_RULES.INSTANTIATION_SCOPE%TYPE;
408: nOnlRuleText CZ_IMP_RULES.RULE_TEXT%TYPE;
409:
410: CURSOR c_rec IS
411: SELECT ROWID, rule_id, name,rule_folder_id,devl_project_id, message, orig_sys_ref, rec_status, disposition,

Line 408: nOnlRuleText CZ_IMP_RULES.RULE_TEXT%TYPE;

404: nOnlDisFlag CZ_IMP_RULES.DISABLED_FLAG%TYPE;
405: nOnlInvFlag CZ_IMP_RULES.INVALID_FLAG%TYPE;
406: nOnlPreFlag CZ_IMP_RULES.PRESENTATION_FLAG%TYPE;
407: nOnlInstScope CZ_IMP_RULES.INSTANTIATION_SCOPE%TYPE;
408: nOnlRuleText CZ_IMP_RULES.RULE_TEXT%TYPE;
409:
410: CURSOR c_rec IS
411: SELECT ROWID, rule_id, name,rule_folder_id,devl_project_id, message, orig_sys_ref, rec_status, disposition,
412: fsk_localized_text_1,fsk_localized_text_2, fsk_component_id, fsk_model_ref_expl_id, rule_type, reason_id, unsatisfied_msg_id,

Line 414: FROM cz_imp_rules

410: CURSOR c_rec IS
411: SELECT ROWID, rule_id, name,rule_folder_id,devl_project_id, message, orig_sys_ref, rec_status, disposition,
412: fsk_localized_text_1,fsk_localized_text_2, fsk_component_id, fsk_model_ref_expl_id, rule_type, reason_id, unsatisfied_msg_id,
413: rule_class, class_seq,config_engine_type,accumulator_flag,top_level_constraint_flag,rule_text --Bug9467066
414: FROM cz_imp_rules
415: WHERE run_id = p_run_id
416: AND rec_status = CZRI_RECSTATUS_CND
417: AND disposition = CZRI_DISPOSITION_PASSED
418: ORDER BY devl_project_id, orig_sys_ref;

Line 463: last_orig_sys_ref cz_imp_rules.orig_sys_ref%TYPE;

459:
460:
461:
462:
463: last_orig_sys_ref cz_imp_rules.orig_sys_ref%TYPE;
464: last_project_id cz_imp_rules.devl_project_id%TYPE;
465:
466: last_id_allocated NUMBER := NULL;
467: next_id_to_use NUMBER := 0;

Line 464: last_project_id cz_imp_rules.devl_project_id%TYPE;

460:
461:
462:
463: last_orig_sys_ref cz_imp_rules.orig_sys_ref%TYPE;
464: last_project_id cz_imp_rules.devl_project_id%TYPE;
465:
466: last_id_allocated NUMBER := NULL;
467: next_id_to_use NUMBER := 0;
468: id_increment NUMBER := CZRI_RULES_INC;

Line 483: UPDATE cz_imp_rules SET

479: PROCEDURE update_table_data(p_upper_limit IN PLS_INTEGER) IS
480: BEGIN
481:
482: FORALL i IN 1..p_upper_limit
483: UPDATE cz_imp_rules SET
484: rule_id = t_rule_id(i),
485: reason_id = t_reason_id(i),
486: unsatisfied_msg_id = t_unsatisfied_msg_id(i),
487: message = t_message(i),

Line 830: FROM cz_imp_rules

826: presentation_flag, template_token, rule_text, notes, class_name, instantiation_scope,
827: mutable_flag, seeded_flag, ui_def_id, ui_page_id, ui_page_element_id, rule_folder_type,
828: disposition, message,
829: rule_class, class_seq,config_engine_type,accumulator_flag,top_level_constraint_flag --Bug9467066
830: FROM cz_imp_rules
831: WHERE run_id = p_run_id
832: AND rec_status = CZRI_RECSTATUS_KRS
833: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY);
834:

Line 836: SELECT ROWID FROM cz_imp_rules

832: AND rec_status = CZRI_RECSTATUS_KRS
833: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY);
834:
835: CURSOR c_rec_nochange IS
836: SELECT ROWID FROM cz_imp_rules
837: WHERE run_id = p_run_id
838: AND rec_status = CZRI_RECSTATUS_KRS
839: AND disposition = CZRI_DISPOSITION_NOCHANGE;
840:

Line 898: UPDATE cz_imp_rules SET

894: --We updating rec_status to XFR, not OK, because the rules still have to be parsed.
895: --When parsed successfully, the status will be changed to OK.
896:
897: FORALL i IN 1..p_upper_limit
898: UPDATE cz_imp_rules SET
899: message = t_message(i),
900: rec_status = CZRI_RECSTATUS_XFR,
901: disposition = t_disposition(i)
902: WHERE ROWID = t_rowid(i);

Line 910: UPDATE cz_imp_rules SET

906: PROCEDURE update_table_data_nochange(p_upper_limit IN PLS_INTEGER) IS -- Meant to change the rec_status of no change records to 'OK'
907: BEGIN
908:
909: FORALL i IN 1..p_upper_limit
910: UPDATE cz_imp_rules SET
911: rec_status = CZRI_RECSTATUS_OK
912: WHERE ROWID = t_rowid(i) ;
913: END;
914: ---------------------------------------------------------------------------------------

Line 1320: -- FROM cz_devl_projects,cz_imp_rules

1316: IF(NOT insert_online_data(t_rowid.COUNT))THEN
1317: --Bug9467066
1318: -- SELECT cz_devl_projects.config_engine_type
1319: -- INTO t_config_engine_type
1320: -- FROM cz_devl_projects,cz_imp_rules
1321: -- WHERE cz_imp_rules.devl_project_id = cz_devl_projects.devl_project_id
1322: -- AND cz_imp_rules.run_id = p_run_id;
1323: --Bug9467066
1324: FOR i IN 1..t_rowid.COUNT LOOP

Line 1321: -- WHERE cz_imp_rules.devl_project_id = cz_devl_projects.devl_project_id

1317: --Bug9467066
1318: -- SELECT cz_devl_projects.config_engine_type
1319: -- INTO t_config_engine_type
1320: -- FROM cz_devl_projects,cz_imp_rules
1321: -- WHERE cz_imp_rules.devl_project_id = cz_devl_projects.devl_project_id
1322: -- AND cz_imp_rules.run_id = p_run_id;
1323: --Bug9467066
1324: FOR i IN 1..t_rowid.COUNT LOOP
1325:

Line 1322: -- AND cz_imp_rules.run_id = p_run_id;

1318: -- SELECT cz_devl_projects.config_engine_type
1319: -- INTO t_config_engine_type
1320: -- FROM cz_devl_projects,cz_imp_rules
1321: -- WHERE cz_imp_rules.devl_project_id = cz_devl_projects.devl_project_id
1322: -- AND cz_imp_rules.run_id = p_run_id;
1323: --Bug9467066
1324: FOR i IN 1..t_rowid.COUNT LOOP
1325:
1326: IF(t_disposition(i) = CZRI_DISPOSITION_INSERT)THEN

Line 1540: FROM cz_imp_rules

1536:
1537: v_debug NUMBER := 9000;
1538: BEGIN
1539: FOR c_stat IN (SELECT disposition, rec_status, COUNT(*) as records
1540: FROM cz_imp_rules
1541: WHERE run_id = p_run_id
1542: AND rec_status IS NOT NULL
1543: AND disposition IS NOT NULL
1544: GROUP BY disposition, rec_status) LOOP

Line 1547: VALUES (p_run_id, 'CZ_IMP_RULES', c_stat.disposition, c_stat.rec_status, c_stat.records);

1543: AND disposition IS NOT NULL
1544: GROUP BY disposition, rec_status) LOOP
1545:
1546: INSERT INTO cz_xfr_run_results (run_id, imp_table, disposition, rec_status, records)
1547: VALUES (p_run_id, 'CZ_IMP_RULES', c_stat.disposition, c_stat.rec_status, c_stat.records);
1548: END LOOP;
1549:
1550: COMMIT;
1551: EXCEPTION

Line 2543: UPDATE cz_imp_rules SET run_id = p_run_id

2539: IF(p_run_id IS NULL)THEN
2540:
2541: SELECT cz_xfr_run_infos_s.NEXTVAL INTO p_run_id FROM DUAL;
2542:
2543: UPDATE cz_imp_rules SET run_id = p_run_id
2544: WHERE disposition IS NULL
2545: AND rec_status IS NULL
2546: AND run_id IS NULL;
2547:

Line 2559: (SELECT NULL FROM cz_imp_rules WHERE run_id = p_run_id);

2555:
2556: BEGIN
2557:
2558: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2559: (SELECT NULL FROM cz_imp_rules WHERE run_id = p_run_id);
2560:
2561: EXCEPTION
2562: WHEN NO_DATA_FOUND THEN
2563: v_error_flag := 0;

Line 2620: (SELECT NULL FROM cz_imp_rules

2616:
2617: BEGIN
2618:
2619: SELECT 1 INTO v_error_flag FROM DUAL WHERE EXISTS
2620: (SELECT NULL FROM cz_imp_rules
2621: WHERE run_id = p_run_id
2622: AND rec_status = CZRI_RECSTATUS_XFR
2623: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY));
2624:

Line 2702: FROM cz_imp_rules

2698: SELECT distinct devl_project_id
2699: BULK
2700: COLLECT
2701: INTO l_model_id_tbl
2702: FROM cz_imp_rules
2703: WHERE rec_status IS NULL
2704: AND disposition IS NULL
2705: AND run_id IS NULL;
2706: ELSE

Line 2711: FROM cz_imp_rules

2707: SELECT distinct devl_project_id
2708: BULK
2709: COLLECT
2710: INTO l_model_id_tbl
2711: FROM cz_imp_rules
2712: WHERE rec_status IS NULL
2713: AND disposition IS NULL
2714: AND run_id = p_run_id;
2715: END IF;

Line 2772: FROM cz_imp_rules

2768:
2769: CURSOR c_rec IS
2770: SELECT ROWID,devl_project_id,last_update_login, reason_type, name, desc_text,
2771: decode(reason_type, 0, name, 2, desc_text) text_str, disposition, reason_id,rule_id
2772: FROM cz_imp_rules
2773: WHERE run_id = p_run_id
2774: AND rec_status = CZRI_RECSTATUS_XFR
2775: AND disposition IN (CZRI_DISPOSITION_INSERT, CZRI_DISPOSITION_MODIFY)
2776: AND reason_type IN (0,2)