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_DEVELOPER_UTILS_PVT dependencies on CZ_RULES

Line 15: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;

11: currPSSeqVal CZ_PS_NODES.ps_node_id%TYPE:=0;
12: currentPSNode CZ_PS_NODES.ps_node_id%TYPE:=mINCREMENT;
13:
14: -- FOR MODEL REPORT, storing default seeded data in static data 5404051
15: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
16: TYPE tTemplateToken IS TABLE OF cz_rules.template_token%TYPE INDEX BY BINARY_INTEGER;
17: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
18:
19: h_RuleName tRuleName;

Line 16: TYPE tTemplateToken IS TABLE OF cz_rules.template_token%TYPE INDEX BY BINARY_INTEGER;

12: currentPSNode CZ_PS_NODES.ps_node_id%TYPE:=mINCREMENT;
13:
14: -- FOR MODEL REPORT, storing default seeded data in static data 5404051
15: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
16: TYPE tTemplateToken IS TABLE OF cz_rules.template_token%TYPE INDEX BY BINARY_INTEGER;
17: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
18:
19: h_RuleName tRuleName;
20: h_TemplateToken tTemplateToken;

Line 17: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;

13:
14: -- FOR MODEL REPORT, storing default seeded data in static data 5404051
15: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
16: TYPE tTemplateToken IS TABLE OF cz_rules.template_token%TYPE INDEX BY BINARY_INTEGER;
17: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
18:
19: h_RuleName tRuleName;
20: h_TemplateToken tTemplateToken;
21: h_RuleId tRuleId;

Line 386: UPDATE CZ_RULES

382: l_position INTEGER := 1;
383:
384: BEGIN
385:
386: UPDATE CZ_RULES
387: SET rule_text = EMPTY_CLOB()
388: WHERE rule_id = p_rule_id;
389:
390: SELECT rule_text INTO l_clob_loc FROM CZ_RULES

Line 390: SELECT rule_text INTO l_clob_loc FROM CZ_RULES

386: UPDATE CZ_RULES
387: SET rule_text = EMPTY_CLOB()
388: WHERE rule_id = p_rule_id;
389:
390: SELECT rule_text INTO l_clob_loc FROM CZ_RULES
391: WHERE rule_id = p_rule_id;
392:
393: DBMS_LOB.OPEN(l_clob_loc,DBMS_LOB.lob_readwrite);
394:

Line 420: SELECT rule_text INTO l_clob_loc FROM CZ_RULES

416: --automatically - examples in Oracle Doc do not call FREETEMPORARY.
417: --Also, Oracle Doc says that calls to OPEN-CLOSE are not required. It
418: --seems that DBMS successfully manages LOBs.
419:
420: SELECT rule_text INTO l_clob_loc FROM CZ_RULES
421: WHERE rule_id = p_rule_id;
422:
423: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_clob_loc);
424: --vsingava 18th Dec '08 bug7316397

Line 533: SELECT devl_project_id INTO l_model_id FROM CZ_RULES

529: END get_Property;
530:
531: BEGIN
532:
533: SELECT devl_project_id INTO l_model_id FROM CZ_RULES
534: WHERE rule_id=p_rule_id;
535:
536: l_rule_text_str := get_String_From_CLOB();
537:

Line 1175: FROM cz_rules

1171: -- cursor to load all rules in this project
1172: -------------------------------------------
1173: CURSOR l_model_rules_csr is
1174: SELECT rule_id, rule_folder_id, rule_type, component_id, model_ref_expl_id
1175: FROM cz_rules
1176: WHERE devl_project_id = l_model_id
1177: AND deleted_flag = '0'
1178: AND rule_type IN (RULE_TYPE_EXPRESSION,RULE_TYPE_COMPAT_TABLE,RULE_TYPE_DESIGNCHART,RULE_TYPE_JAVA_METHOD);
1179: ------------------------------------------------------------------------

Line 1184: FROM cz_expression_nodes e, cz_rules r, cz_ps_nodes p

1180: -- cursor to load all participating ps nodes in a expression or CX rule
1181: ------------------------------------------------------------------------
1182: CURSOR l_rule_nodes_csr (iRuleId NUMBER) IS
1183: SELECT DISTINCT e.ps_node_id, p.devl_project_id, e.model_ref_expl_id
1184: FROM cz_expression_nodes e, cz_rules r, cz_ps_nodes p
1185: WHERE e.deleted_flag = '0'
1186: AND r.deleted_flag = '0'
1187: AND p.deleted_flag = '0'
1188: AND p.ps_node_id = e.ps_node_id

Line 1197: FROM cz_des_chart_features f, cz_rules r, cz_ps_nodes p

1193: -- cursor to load all participating ps nodes in design chart or explicit comp rule
1194: ----------------------------------------------------------------------------------
1195: CURSOR l_rule_nodes_csr2 (iRuleId NUMBER) IS
1196: SELECT DISTINCT f.feature_id, p.devl_project_id, f.model_ref_expl_id
1197: FROM cz_des_chart_features f, cz_rules r, cz_ps_nodes p
1198: WHERE f.deleted_flag = '0'
1199: AND r.deleted_flag = '0'
1200: AND p.deleted_flag = '0'
1201: AND p.ps_node_id = f.feature_id

Line 1419: -- update component_id in cz_rules

1415: l_index := l_persistent_tbl.NEXT(l_index);
1416: END LOOP;
1417:
1418: --
1419: -- update component_id in cz_rules
1420: --
1421:
1422: l_index := l_ps_nodes_tbl.FIRST;
1423: LOOP

Line 1427: UPDATE cz_rules

1423: LOOP
1424: IF l_index IS NULL THEN
1425: EXIT;
1426: END IF;
1427: UPDATE cz_rules
1428: SET component_id = l_ps_nodes_tbl(l_index)
1429: WHERE rule_id = l_new_rule_id
1430: AND component_id = l_index
1431: AND deleted_flag = '0';

Line 1460: -- update model_ref_expl_id in cz_rules

1456:
1457: IF (l_rule_type_tbl(i) = RULE_TYPE_JAVA_METHOD) THEN
1458:
1459: --
1460: -- update model_ref_expl_id in cz_rules
1461: --
1462:
1463: l_index := l_expl_nodes_tbl.FIRST;
1464: LOOP

Line 1469: UPDATE cz_rules

1465: IF l_index IS NULL THEN
1466: EXIT;
1467: END IF;
1468:
1469: UPDATE cz_rules
1470: SET model_ref_expl_id = l_expl_nodes_tbl(l_index)
1471: WHERE model_ref_expl_id = l_index
1472: AND rule_id = l_new_rule_id;
1473:

Line 1504: -- update model_ref_expl_id in cz_rules

1500:
1501: IF (l_rule_type_tbl(i) = RULE_TYPE_JAVA_METHOD) THEN
1502:
1503: --
1504: -- update model_ref_expl_id in cz_rules
1505: --
1506:
1507: l_index := l_expl_nodes_all_tbl.FIRST;
1508: LOOP

Line 1513: UPDATE cz_rules

1509: IF l_index IS NULL THEN
1510: EXIT;
1511: END IF;
1512:
1513: UPDATE cz_rules
1514: SET model_ref_expl_id = l_expl_nodes_all_tbl(l_index)
1515: WHERE model_ref_expl_id = l_index
1516: AND rule_id = l_new_rule_id;
1517:

Line 1703: l_seeded_flag cz_rules.seeded_flag%TYPE;

1699: l_new_rfl_id NUMBER;
1700: l_rule_type NUMBER;
1701: l_reference_ps_node_id NUMBER;
1702: l_persistent_node_id NUMBER;
1703: l_seeded_flag cz_rules.seeded_flag%TYPE;
1704:
1705: l_new_exprnode_tbl t_num_array_tbl_type;
1706: l_new_parent_exprnode_tbl t_num_array_tbl_type;
1707: l_exprnode_tbl t_num_array_tbl_type;

Line 1734: FROM CZ_RULES

1730: x_return_status := FND_API.G_RET_STS_SUCCESS;
1731:
1732: SELECT devl_project_id,rule_folder_id, rule_type, seeded_flag
1733: INTO l_model_id,l_rule_folder_id, l_rule_type, l_seeded_flag
1734: FROM CZ_RULES
1735: WHERE rule_id=p_rule_id AND deleted_flag='0';
1736:
1737: IF (l_seeded_flag = '1' AND l_rule_type NOT IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
1738: RULE_TYPE_CAPTION, RULE_TYPE_JAVA_SYS_PROP)) THEN

Line 1775: l_new_rule_id := allocateId('CZ_RULES_S');

1771: RAISE INVALID_FOLDER_ID_EXCP;
1772: END IF;
1773: END IF;
1774:
1775: l_new_rule_id := allocateId('CZ_RULES_S');
1776: x_out_new_rule_id := l_new_rule_id;
1777:
1778: FOR i IN (SELECT * FROM CZ_RULES
1779: WHERE rule_id=p_rule_id AND deleted_flag='0')

Line 1778: FOR i IN (SELECT * FROM CZ_RULES

1774:
1775: l_new_rule_id := allocateId('CZ_RULES_S');
1776: x_out_new_rule_id := l_new_rule_id;
1777:
1778: FOR i IN (SELECT * FROM CZ_RULES
1779: WHERE rule_id=p_rule_id AND deleted_flag='0')
1780: LOOP
1781: IF i.reason_id IS NOT NULL THEN
1782: l_text_id := i.reason_id;

Line 1831: FROM CZ_RULES

1827: END IF;
1828:
1829: SELECT NVL(MAX(seq_nbr),0)+1
1830: INTO l_new_seq_nbr
1831: FROM CZ_RULES
1832: WHERE rule_folder_id=l_new_rfl_id AND deleted_flag='0';
1833:
1834: IF l_object_type='RSQ' THEN
1835: IF i.EFFECTIVITY_SET_ID IS NULL OR i.EFFECTIVITY_SET_ID=-1 THEN

Line 1940: FROM cz_rules

1936:
1937: l_class_seq := i.class_seq;
1938: IF i.rule_class IS NOT NULL AND i.rule_class IN (RULE_CLASS_DEFAULT, RULE_CLASS_SEARCH_DECISION) THEN
1939: SELECT max(nvl(class_seq,0))+1 INTO l_class_seq
1940: FROM cz_rules
1941: WHERE deleted_flag = '0' AND devl_project_id = l_devl_project_id
1942: AND rule_class = i.rule_class;
1943: END IF;
1944:

Line 1945: INSERT INTO CZ_RULES(

1941: WHERE deleted_flag = '0' AND devl_project_id = l_devl_project_id
1942: AND rule_class = i.rule_class;
1943: END IF;
1944:
1945: INSERT INTO CZ_RULES(
1946: RULE_ID,
1947: SUB_CONS_ID,
1948: REASON_ID,
1949: AMOUNT_ID,

Line 3983: UPDATE CZ_RULES

3979: UPDATE cz_ui_defs
3980: SET deleted_flag = '1'
3981: WHERE ui_def_id = p_ui_def_id;
3982:
3983: UPDATE CZ_RULES
3984: SET deleted_flag = '1'
3985: WHERE ui_def_id = p_ui_def_id;
3986:
3987: UPDATE CZ_LOCALIZED_TEXTS

Line 4354: UPDATE cz_rules

4350: ----------------------------------
4351: -- delete the rules in this folder
4352: ----------------------------------
4353:
4354: UPDATE cz_rules
4355: SET deleted_flag = '1'
4356: WHERE rule_folder_id = p_rule_sequence_id;
4357:
4358: -------------------------

Line 5485: FROM cz_rules

5481:
5482: IF ( p_id_type = G_RULE_TYPE ) THEN
5483:
5484: SELECT rule_folder_id INTO l_rule_folder_id
5485: FROM cz_rules
5486: WHERE cz_rules.rule_id = l_element_id
5487: AND cz_rules.deleted_flag = '0';
5488:
5489:

Line 5486: WHERE cz_rules.rule_id = l_element_id

5482: IF ( p_id_type = G_RULE_TYPE ) THEN
5483:
5484: SELECT rule_folder_id INTO l_rule_folder_id
5485: FROM cz_rules
5486: WHERE cz_rules.rule_id = l_element_id
5487: AND cz_rules.deleted_flag = '0';
5488:
5489:
5490: cz_developer_utils_pvt.copy_Rule (l_element_id,

Line 5487: AND cz_rules.deleted_flag = '0';

5483:
5484: SELECT rule_folder_id INTO l_rule_folder_id
5485: FROM cz_rules
5486: WHERE cz_rules.rule_id = l_element_id
5487: AND cz_rules.deleted_flag = '0';
5488:
5489:
5490: cz_developer_utils_pvt.copy_Rule (l_element_id,
5491: l_rule_folder_id,

Line 6424: (SELECT devl_project_id FROM cz_rules

6420:
6421: SELECT name BULK COLLECT INTO l_prj_name_tbl
6422: FROM cz_devl_projects
6423: WHERE deleted_flag = '0' AND devl_project_id IN
6424: (SELECT devl_project_id FROM cz_rules
6425: WHERE effectivity_set_id = p_eff_set_id
6426: AND deleted_flag = '0'
6427: UNION ALL
6428: SELECT devl_project_id FROM cz_ps_nodes

Line 7303: FROM cz_rules

7299: BULK
7300: COLLECT
7301: INTO v_rules,
7302: v_masks_rules
7303: FROM cz_rules
7304: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
7305: AND deleted_flag = '0'
7306: ORDER BY effective_usage_mask;
7307: EXCEPTION

Line 7401: FROM cz_rules

7397: BULK
7398: COLLECT
7399: INTO v_rules,
7400: v_masks_rules
7401: FROM cz_rules
7402: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
7403: ORDER BY effective_usage_mask;
7404: EXCEPTION
7405: WHEN OTHERS THEN

Line 7461: UPDATE cz_rules

7457: v_masks_rules(i) := v_new_mask;
7458: END IF;
7459: END LOOP;
7460: FORALL i IN v_rules.FIRST..v_rules.LAST
7461: UPDATE cz_rules
7462: SET effective_usage_mask = v_masks_rules(i)
7463: WHERE rule_id = v_rules(i);
7464: END IF;
7465: EXCEPTION

Line 7886: FROM cz_rules

7882: SELECT distinct devl_project_id
7883: BULK
7884: COLLECT
7885: INTO l_eff_tbl
7886: FROM cz_rules
7887: WHERE cz_rules.effectivity_set_id = l_eff_set_ref(i)
7888: AND cz_rules.deleted_flag = '0';
7889:
7890: rec_count := l_eff_ref.COUNT;

Line 7887: WHERE cz_rules.effectivity_set_id = l_eff_set_ref(i)

7883: BULK
7884: COLLECT
7885: INTO l_eff_tbl
7886: FROM cz_rules
7887: WHERE cz_rules.effectivity_set_id = l_eff_set_ref(i)
7888: AND cz_rules.deleted_flag = '0';
7889:
7890: rec_count := l_eff_ref.COUNT;
7891: IF (l_eff_tbl.COUNT > 0) THEN

Line 7888: AND cz_rules.deleted_flag = '0';

7884: COLLECT
7885: INTO l_eff_tbl
7886: FROM cz_rules
7887: WHERE cz_rules.effectivity_set_id = l_eff_set_ref(i)
7888: AND cz_rules.deleted_flag = '0';
7889:
7890: rec_count := l_eff_ref.COUNT;
7891: IF (l_eff_tbl.COUNT > 0) THEN
7892: FOR I IN l_eff_tbl.FIRST..l_eff_tbl.LAST

Line 8229: FROM cz_rules

8225: SELECT rule_id,effective_usage_mask,devl_project_id,name
8226: BULK
8227: COLLECT
8228: INTO v_rules,v_masks_rules,l_rules_project_tbl,l_rules_name_tbl
8229: FROM cz_rules
8230: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
8231: ORDER BY effective_usage_mask;
8232: EXCEPTION
8233: WHEN OTHERS THEN

Line 8626: v_template_flag cz_rules.presentation_flag%TYPE;

8622: h_ContextPath tStringTable;
8623: h_ModelPath tStringTable;
8624: h_NodeName tStringTable;
8625:
8626: v_template_flag cz_rules.presentation_flag%TYPE;
8627: v_devl_project_id cz_rules.devl_project_id%TYPE;
8628: nLocalExprId PLS_INTEGER := 1000;
8629: nDebug PLS_INTEGER;
8630:

Line 8627: v_devl_project_id cz_rules.devl_project_id%TYPE;

8623: h_ModelPath tStringTable;
8624: h_NodeName tStringTable;
8625:
8626: v_template_flag cz_rules.presentation_flag%TYPE;
8627: v_devl_project_id cz_rules.devl_project_id%TYPE;
8628: nLocalExprId PLS_INTEGER := 1000;
8629: nDebug PLS_INTEGER;
8630:
8631: v_ExprId tExprId;

Line 8672: v_token cz_rules.template_token%TYPE;

8668:
8669: v_RuleText VARCHAR2(32767);
8670: v_Name VARCHAR2(32767);
8671: v_Index PLS_INTEGER;
8672: v_token cz_rules.template_token%TYPE;
8673: ---------------------------------------------------------------------------------------
8674: FUNCTION generate_model_path (p_ps_node_id IN NUMBER) RETURN VARCHAR2 IS
8675: v_Name VARCHAR2(32767);
8676: BEGIN

Line 9664: FROM cz_rules

9660: v_TemplateToken tTemplateToken;
9661: BEGIN
9662: --Initialize the rule data for resolving token names.
9663: SELECT rule_id, name, template_token BULK COLLECT INTO h_RuleId, v_RuleName, v_TemplateToken
9664: FROM cz_rules
9665: WHERE devl_project_id = 0
9666: AND deleted_flag = '0'
9667: AND disabled_flag = '0'
9668: AND seeded_flag = '1';

Line 9689: SELECT devl_project_id, presentation_flag INTO v_devl_project_id, v_template_flag FROM cz_rules

9685:
9686: nDebug := 1;
9687:
9688: BEGIN
9689: SELECT devl_project_id, presentation_flag INTO v_devl_project_id, v_template_flag FROM cz_rules
9690: WHERE deleted_flag = '0'
9691: AND rule_id = p_rule_id;
9692: EXCEPTION
9693: WHEN NO_DATA_FOUND THEN

Line 10468: v_inst_scope cz_rules.instantiation_scope%TYPE;

10464: v_property_name cz_properties.name%TYPE;
10465: v_item_name cz_ps_nodes.name%TYPE;
10466: v_parent_name cz_ps_nodes.name%TYPE;
10467: v_parent_id cz_ps_nodes.parent_id%TYPE;
10468: v_inst_scope cz_rules.instantiation_scope%TYPE;
10469:
10470: v_tExprId t_num_array_tbl_type;
10471: v_tExprParentId t_num_array_tbl_type;
10472: v_tExplNodeId t_num_array_tbl_type;

Line 10508: UPDATE cz_rules SET invalid_flag = '1' WHERE rule_id = p_rule_id;

10504: END;
10505: ---------------------------------------------------------------------------------------
10506: PROCEDURE mark_rule_invalid IS
10507: BEGIN
10508: UPDATE cz_rules SET invalid_flag = '1' WHERE rule_id = p_rule_id;
10509: END;
10510: ---------------------------------------------------------------------------------------
10511: PROCEDURE mark_rule_valid IS
10512: BEGIN

Line 10513: UPDATE cz_rules SET invalid_flag = '0' WHERE rule_id = p_rule_id;

10509: END;
10510: ---------------------------------------------------------------------------------------
10511: PROCEDURE mark_rule_valid IS
10512: BEGIN
10513: UPDATE cz_rules SET invalid_flag = '0' WHERE rule_id = p_rule_id;
10514: END;
10515: ---------------------------------------------------------------------------------------
10516: PROCEDURE set_status(initRuleStatus IN PLS_INTEGER) IS
10517: BEGIN

Line 10625: FROM cz_rules

10621: SELECT rule_type, component_id, model_ref_expl_id, devl_project_id, rule_folder_id, name,
10622: class_name, seeded_flag, invalid_flag, instantiation_scope
10623: INTO v_rule_type, v_component_id, v_expl_id, v_model_id, v_rule_folder_id, v_rule_name,
10624: v_class_name, v_seeded_flag, initRuleStatus, v_inst_scope
10625: FROM cz_rules
10626: WHERE rule_id = p_rule_id;
10627:
10628: IF(v_seeded_flag = '1')THEN x_run_id := 0; RETURN; END IF;
10629:

Line 11894: l_substr CZ_RULES.class_name%TYPE;

11890: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11891: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
11892:
11893: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11894: l_substr CZ_RULES.class_name%TYPE;
11895: l_output CZ_RULES.class_name%TYPE;
11896: l_reverse_string CZ_RULES.class_name%TYPE;
11897: l_reverse_pattern CZ_RULES.class_name%TYPE;
11898: l_index NUMBER;

Line 11895: l_output CZ_RULES.class_name%TYPE;

11891: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
11892:
11893: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11894: l_substr CZ_RULES.class_name%TYPE;
11895: l_output CZ_RULES.class_name%TYPE;
11896: l_reverse_string CZ_RULES.class_name%TYPE;
11897: l_reverse_pattern CZ_RULES.class_name%TYPE;
11898: l_index NUMBER;
11899: l_next_index NUMBER;

Line 11896: l_reverse_string CZ_RULES.class_name%TYPE;

11892:
11893: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11894: l_substr CZ_RULES.class_name%TYPE;
11895: l_output CZ_RULES.class_name%TYPE;
11896: l_reverse_string CZ_RULES.class_name%TYPE;
11897: l_reverse_pattern CZ_RULES.class_name%TYPE;
11898: l_index NUMBER;
11899: l_next_index NUMBER;
11900: BEGIN

Line 11897: l_reverse_pattern CZ_RULES.class_name%TYPE;

11893: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11894: l_substr CZ_RULES.class_name%TYPE;
11895: l_output CZ_RULES.class_name%TYPE;
11896: l_reverse_string CZ_RULES.class_name%TYPE;
11897: l_reverse_pattern CZ_RULES.class_name%TYPE;
11898: l_index NUMBER;
11899: l_next_index NUMBER;
11900: BEGIN
11901:

Line 11934: l_new_class_name CZ_RULES.class_name%TYPE;

11930: x_return_status OUT NOCOPY VARCHAR2,
11931: x_msg_count OUT NOCOPY NUMBER,
11932: x_msg_data OUT NOCOPY VARCHAR2
11933: ) IS
11934: l_new_class_name CZ_RULES.class_name%TYPE;
11935: BEGIN
11936:
11937: x_return_status := FND_API.g_ret_sts_success;
11938: x_msg_count := 0;

Line 11942: FROM CZ_RULES rul,

11938: x_msg_count := 0;
11939: x_msg_data := '';
11940:
11941: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id
11942: FROM CZ_RULES rul,
11943: CZ_EXPRESSION_NODES expr,
11944: CZ_SIGNATURE_ARGUMENTS args
11945: WHERE rul.rule_type = 300 AND rul.devl_project_id = p_model_id AND
11946: expr.rule_id = rul.rule_id AND expr.expr_parent_id is null AND

Line 11961: UPDATE CZ_RULES

11957: WHERE class_name = arg.java_data_type);
11958:
11959: l_new_class_name := convertClassName(i.class_name,'emu');
11960: IF l_new_class_name<>i.class_name THEN
11961: UPDATE CZ_RULES
11962: SET class_name=l_new_class_name
11963: WHERE rule_id=i.rule_id;
11964: END IF;
11965: