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 536: SELECT devl_project_id INTO l_model_id FROM CZ_RULES

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

Line 1203: FROM cz_rules

1199: -- cursor to load all rules in this project
1200: -------------------------------------------
1201: CURSOR l_model_rules_csr is
1202: SELECT rule_id, rule_folder_id, rule_type, component_id, model_ref_expl_id
1203: FROM cz_rules
1204: WHERE devl_project_id = l_model_id
1205: AND deleted_flag = '0'
1206: AND rule_type IN (RULE_TYPE_EXPRESSION,RULE_TYPE_COMPAT_TABLE,RULE_TYPE_DESIGNCHART,RULE_TYPE_JAVA_METHOD);
1207: ------------------------------------------------------------------------

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

1208: -- cursor to load all participating ps nodes in a expression or CX rule
1209: ------------------------------------------------------------------------
1210: CURSOR l_rule_nodes_csr (iRuleId NUMBER) IS
1211: SELECT DISTINCT e.ps_node_id, p.devl_project_id, e.model_ref_expl_id
1212: FROM cz_expression_nodes e, cz_rules r, cz_ps_nodes p
1213: WHERE e.deleted_flag = '0'
1214: AND r.deleted_flag = '0'
1215: AND p.deleted_flag = '0'
1216: AND p.ps_node_id = e.ps_node_id

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

1221: -- cursor to load all participating ps nodes in design chart or explicit comp rule
1222: ----------------------------------------------------------------------------------
1223: CURSOR l_rule_nodes_csr2 (iRuleId NUMBER) IS
1224: SELECT DISTINCT f.feature_id, p.devl_project_id, f.model_ref_expl_id
1225: FROM cz_des_chart_features f, cz_rules r, cz_ps_nodes p
1226: WHERE f.deleted_flag = '0'
1227: AND r.deleted_flag = '0'
1228: AND p.deleted_flag = '0'
1229: AND p.ps_node_id = f.feature_id

Line 1447: -- update component_id in cz_rules

1443: l_index := l_persistent_tbl.NEXT(l_index);
1444: END LOOP;
1445:
1446: --
1447: -- update component_id in cz_rules
1448: --
1449:
1450: l_index := l_ps_nodes_tbl.FIRST;
1451: LOOP

Line 1455: UPDATE cz_rules

1451: LOOP
1452: IF l_index IS NULL THEN
1453: EXIT;
1454: END IF;
1455: UPDATE cz_rules
1456: SET component_id = l_ps_nodes_tbl(l_index)
1457: WHERE rule_id = l_new_rule_id
1458: AND component_id = l_index
1459: AND deleted_flag = '0';

Line 1488: -- update model_ref_expl_id in cz_rules

1484:
1485: IF (l_rule_type_tbl(i) = RULE_TYPE_JAVA_METHOD) THEN
1486:
1487: --
1488: -- update model_ref_expl_id in cz_rules
1489: --
1490:
1491: l_index := l_expl_nodes_tbl.FIRST;
1492: LOOP

Line 1497: UPDATE cz_rules

1493: IF l_index IS NULL THEN
1494: EXIT;
1495: END IF;
1496:
1497: UPDATE cz_rules
1498: SET model_ref_expl_id = l_expl_nodes_tbl(l_index)
1499: WHERE model_ref_expl_id = l_index
1500: AND rule_id = l_new_rule_id;
1501:

Line 1532: -- update model_ref_expl_id in cz_rules

1528:
1529: IF (l_rule_type_tbl(i) = RULE_TYPE_JAVA_METHOD) THEN
1530:
1531: --
1532: -- update model_ref_expl_id in cz_rules
1533: --
1534:
1535: l_index := l_expl_nodes_all_tbl.FIRST;
1536: LOOP

Line 1541: UPDATE cz_rules

1537: IF l_index IS NULL THEN
1538: EXIT;
1539: END IF;
1540:
1541: UPDATE cz_rules
1542: SET model_ref_expl_id = l_expl_nodes_all_tbl(l_index)
1543: WHERE model_ref_expl_id = l_index
1544: AND rule_id = l_new_rule_id;
1545:

Line 1731: l_seeded_flag cz_rules.seeded_flag%TYPE;

1727: l_new_rfl_id NUMBER;
1728: l_rule_type NUMBER;
1729: l_reference_ps_node_id NUMBER;
1730: l_persistent_node_id NUMBER;
1731: l_seeded_flag cz_rules.seeded_flag%TYPE;
1732:
1733: l_new_exprnode_tbl t_int_array_tbl_type_idx_vc2;--t_num_array_tbl_type;
1734: l_new_parent_exprnode_tbl t_int_array_tbl_type_idx_vc2;--t_num_array_tbl_type;
1735: l_exprnode_tbl t_int_array_tbl_type_idx_vc2;--t_num_array_tbl_type; Not used anywhere.

Line 1762: FROM CZ_RULES

1758: x_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: SELECT devl_project_id,rule_folder_id, rule_type, seeded_flag
1761: INTO l_model_id,l_rule_folder_id, l_rule_type, l_seeded_flag
1762: FROM CZ_RULES
1763: WHERE rule_id=p_rule_id AND deleted_flag='0';
1764:
1765: IF (l_seeded_flag = '1' AND l_rule_type NOT IN (RULE_TYPE_DISPLAY_CONDITION, RULE_TYPE_ENABLED_CONDITION,
1766: RULE_TYPE_CAPTION, RULE_TYPE_JAVA_SYS_PROP)) THEN

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

1799: RAISE INVALID_FOLDER_ID_EXCP;
1800: END IF;
1801: END IF;
1802:
1803: l_new_rule_id := allocateId('CZ_RULES_S');
1804: x_out_new_rule_id := l_new_rule_id;
1805:
1806: FOR i IN (SELECT * FROM CZ_RULES
1807: WHERE rule_id=p_rule_id AND deleted_flag='0')

Line 1806: FOR i IN (SELECT * FROM CZ_RULES

1802:
1803: l_new_rule_id := allocateId('CZ_RULES_S');
1804: x_out_new_rule_id := l_new_rule_id;
1805:
1806: FOR i IN (SELECT * FROM CZ_RULES
1807: WHERE rule_id=p_rule_id AND deleted_flag='0')
1808: LOOP
1809: IF i.reason_id IS NOT NULL THEN
1810: l_text_id := i.reason_id;

Line 1859: FROM CZ_RULES

1855: END IF;
1856:
1857: SELECT NVL(MAX(seq_nbr),0)+1
1858: INTO l_new_seq_nbr
1859: FROM CZ_RULES
1860: WHERE rule_folder_id=l_new_rfl_id AND deleted_flag='0';
1861:
1862: IF l_object_type='RSQ' THEN
1863: IF i.EFFECTIVITY_SET_ID IS NULL OR i.EFFECTIVITY_SET_ID=-1 THEN

Line 1968: FROM cz_rules

1964:
1965: l_class_seq := i.class_seq;
1966: IF i.rule_class IS NOT NULL AND i.rule_class IN (RULE_CLASS_DEFAULT, RULE_CLASS_SEARCH_DECISION) THEN
1967: SELECT max(nvl(class_seq,0))+1 INTO l_class_seq
1968: FROM cz_rules
1969: WHERE deleted_flag = '0' AND devl_project_id = l_devl_project_id
1970: AND rule_class = i.rule_class;
1971: END IF;
1972:

Line 1973: INSERT INTO CZ_RULES(

1969: WHERE deleted_flag = '0' AND devl_project_id = l_devl_project_id
1970: AND rule_class = i.rule_class;
1971: END IF;
1972:
1973: INSERT INTO CZ_RULES(
1974: RULE_ID,
1975: SUB_CONS_ID,
1976: REASON_ID,
1977: AMOUNT_ID,

Line 4011: UPDATE CZ_RULES

4007: UPDATE cz_ui_defs
4008: SET deleted_flag = '1'
4009: WHERE ui_def_id = p_ui_def_id;
4010:
4011: UPDATE CZ_RULES
4012: SET deleted_flag = '1'
4013: WHERE ui_def_id = p_ui_def_id;
4014:
4015: UPDATE CZ_LOCALIZED_TEXTS

Line 4382: UPDATE cz_rules

4378: ----------------------------------
4379: -- delete the rules in this folder
4380: ----------------------------------
4381:
4382: UPDATE cz_rules
4383: SET deleted_flag = '1'
4384: WHERE rule_folder_id = p_rule_sequence_id;
4385:
4386: -------------------------

Line 5514: FROM cz_rules

5510:
5511: IF ( p_id_type = G_RULE_TYPE ) THEN
5512:
5513: SELECT rule_folder_id INTO l_rule_folder_id
5514: FROM cz_rules
5515: WHERE cz_rules.rule_id = l_element_id
5516: AND cz_rules.deleted_flag = '0';
5517:
5518:

Line 5515: WHERE cz_rules.rule_id = l_element_id

5511: IF ( p_id_type = G_RULE_TYPE ) THEN
5512:
5513: SELECT rule_folder_id INTO l_rule_folder_id
5514: FROM cz_rules
5515: WHERE cz_rules.rule_id = l_element_id
5516: AND cz_rules.deleted_flag = '0';
5517:
5518:
5519: cz_developer_utils_pvt.copy_Rule (l_element_id,

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

5512:
5513: SELECT rule_folder_id INTO l_rule_folder_id
5514: FROM cz_rules
5515: WHERE cz_rules.rule_id = l_element_id
5516: AND cz_rules.deleted_flag = '0';
5517:
5518:
5519: cz_developer_utils_pvt.copy_Rule (l_element_id,
5520: l_rule_folder_id,

Line 6453: (SELECT devl_project_id FROM cz_rules

6449:
6450: SELECT name BULK COLLECT INTO l_prj_name_tbl
6451: FROM cz_devl_projects
6452: WHERE deleted_flag = '0' AND devl_project_id IN
6453: (SELECT devl_project_id FROM cz_rules
6454: WHERE effectivity_set_id = p_eff_set_id
6455: AND deleted_flag = '0'
6456: UNION ALL
6457: SELECT devl_project_id FROM cz_ps_nodes

Line 7356: FROM cz_rules

7352: BULK
7353: COLLECT
7354: INTO v_rules,
7355: v_masks_rules
7356: FROM cz_rules
7357: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
7358: AND deleted_flag = '0'
7359: ORDER BY effective_usage_mask;
7360: EXCEPTION

Line 7454: FROM cz_rules

7450: BULK
7451: COLLECT
7452: INTO v_rules,
7453: v_masks_rules
7454: FROM cz_rules
7455: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
7456: ORDER BY effective_usage_mask;
7457: EXCEPTION
7458: WHEN OTHERS THEN

Line 7514: UPDATE cz_rules

7510: v_masks_rules(i) := v_new_mask;
7511: END IF;
7512: END LOOP;
7513: FORALL i IN v_rules.FIRST..v_rules.LAST
7514: UPDATE cz_rules
7515: SET effective_usage_mask = v_masks_rules(i)
7516: WHERE rule_id = v_rules(i);
7517: END IF;
7518: EXCEPTION

Line 7944: FROM cz_rules

7940: SELECT distinct devl_project_id
7941: BULK
7942: COLLECT
7943: INTO l_eff_tbl
7944: FROM cz_rules
7945: WHERE cz_rules.effectivity_set_id = l_eff_set_ref(i)
7946: AND cz_rules.deleted_flag = '0';
7947:
7948: rec_count := l_eff_ref.COUNT;

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

7941: BULK
7942: COLLECT
7943: INTO l_eff_tbl
7944: FROM cz_rules
7945: WHERE cz_rules.effectivity_set_id = l_eff_set_ref(i)
7946: AND cz_rules.deleted_flag = '0';
7947:
7948: rec_count := l_eff_ref.COUNT;
7949: IF (l_eff_tbl.COUNT > 0) THEN

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

7942: COLLECT
7943: INTO l_eff_tbl
7944: FROM cz_rules
7945: WHERE cz_rules.effectivity_set_id = l_eff_set_ref(i)
7946: AND cz_rules.deleted_flag = '0';
7947:
7948: rec_count := l_eff_ref.COUNT;
7949: IF (l_eff_tbl.COUNT > 0) THEN
7950: FOR I IN l_eff_tbl.FIRST..l_eff_tbl.LAST

Line 8338: FROM cz_rules

8334: SELECT rule_id,effective_usage_mask,devl_project_id,name
8335: BULK
8336: COLLECT
8337: INTO v_rules,v_masks_rules,l_rules_project_tbl,l_rules_name_tbl
8338: FROM cz_rules
8339: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
8340: ORDER BY effective_usage_mask;
8341: EXCEPTION
8342: WHEN OTHERS THEN

Line 8677: v_template_flag cz_rules.presentation_flag%TYPE;

8673: h_ContextPath tStringTable;
8674: h_ModelPath tStringTable;
8675: h_NodeName tStringTable;
8676:
8677: v_template_flag cz_rules.presentation_flag%TYPE;
8678: v_devl_project_id cz_rules.devl_project_id%TYPE;
8679: nLocalExprId PLS_INTEGER := 1000;
8680: nDebug PLS_INTEGER;
8681:

Line 8678: v_devl_project_id cz_rules.devl_project_id%TYPE;

8674: h_ModelPath tStringTable;
8675: h_NodeName tStringTable;
8676:
8677: v_template_flag cz_rules.presentation_flag%TYPE;
8678: v_devl_project_id cz_rules.devl_project_id%TYPE;
8679: nLocalExprId PLS_INTEGER := 1000;
8680: nDebug PLS_INTEGER;
8681:
8682: v_ExprId tExprId;

Line 8723: v_token cz_rules.template_token%TYPE;

8719:
8720: v_RuleText VARCHAR2(32767);
8721: v_Name VARCHAR2(32767);
8722: v_Index PLS_INTEGER;
8723: v_token cz_rules.template_token%TYPE;
8724: ---------------------------------------------------------------------------------------
8725: FUNCTION generate_model_path (p_ps_node_id IN NUMBER) RETURN VARCHAR2 IS
8726: v_Name VARCHAR2(32767);
8727: BEGIN

Line 9715: FROM cz_rules

9711: v_TemplateToken tTemplateToken;
9712: BEGIN
9713: --Initialize the rule data for resolving token names.
9714: SELECT rule_id, name, template_token BULK COLLECT INTO h_RuleId, v_RuleName, v_TemplateToken
9715: FROM cz_rules
9716: WHERE devl_project_id = 0
9717: AND deleted_flag = '0'
9718: AND disabled_flag = '0'
9719: AND seeded_flag = '1';

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

9736:
9737: nDebug := 1;
9738:
9739: BEGIN
9740: SELECT devl_project_id, presentation_flag INTO v_devl_project_id, v_template_flag FROM cz_rules
9741: WHERE deleted_flag = '0'
9742: AND rule_id = p_rule_id;
9743: EXCEPTION
9744: WHEN NO_DATA_FOUND THEN

Line 10519: v_inst_scope cz_rules.instantiation_scope%TYPE;

10515: v_property_name cz_properties.name%TYPE;
10516: v_item_name cz_ps_nodes.name%TYPE;
10517: v_parent_name cz_ps_nodes.name%TYPE;
10518: v_parent_id cz_ps_nodes.parent_id%TYPE;
10519: v_inst_scope cz_rules.instantiation_scope%TYPE;
10520:
10521: v_tExprId t_num_array_tbl_type;
10522: v_tExprParentId t_num_array_tbl_type;
10523: v_tExplNodeId t_num_array_tbl_type;

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

10556: END;
10557: ---------------------------------------------------------------------------------------
10558: PROCEDURE mark_rule_invalid IS
10559: BEGIN
10560: UPDATE cz_rules SET invalid_flag = '1' WHERE rule_id = p_rule_id;
10561: END;
10562: ---------------------------------------------------------------------------------------
10563: PROCEDURE mark_rule_valid IS
10564: BEGIN

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

10561: END;
10562: ---------------------------------------------------------------------------------------
10563: PROCEDURE mark_rule_valid IS
10564: BEGIN
10565: UPDATE cz_rules SET invalid_flag = '0' WHERE rule_id = p_rule_id;
10566: END;
10567: ---------------------------------------------------------------------------------------
10568: PROCEDURE set_status(initRuleStatus IN PLS_INTEGER) IS
10569: BEGIN

Line 10677: FROM cz_rules

10673: SELECT rule_type, component_id, model_ref_expl_id, devl_project_id, rule_folder_id, name,
10674: class_name, seeded_flag, invalid_flag, instantiation_scope
10675: INTO v_rule_type, v_component_id, v_expl_id, v_model_id, v_rule_folder_id, v_rule_name,
10676: v_class_name, v_seeded_flag, initRuleStatus, v_inst_scope
10677: FROM cz_rules
10678: WHERE rule_id = p_rule_id;
10679:
10680: IF(v_seeded_flag = '1')THEN x_run_id := 0; RETURN; END IF;
10681:

Line 11968: l_substr CZ_RULES.class_name%TYPE;

11964: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11965: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
11966:
11967: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11968: l_substr CZ_RULES.class_name%TYPE;
11969: l_output CZ_RULES.class_name%TYPE;
11970: l_reverse_string CZ_RULES.class_name%TYPE;
11971: l_reverse_pattern CZ_RULES.class_name%TYPE;
11972: l_index NUMBER;

Line 11969: l_output CZ_RULES.class_name%TYPE;

11965: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
11966:
11967: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11968: l_substr CZ_RULES.class_name%TYPE;
11969: l_output CZ_RULES.class_name%TYPE;
11970: l_reverse_string CZ_RULES.class_name%TYPE;
11971: l_reverse_pattern CZ_RULES.class_name%TYPE;
11972: l_index NUMBER;
11973: l_next_index NUMBER;

Line 11970: l_reverse_string CZ_RULES.class_name%TYPE;

11966:
11967: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11968: l_substr CZ_RULES.class_name%TYPE;
11969: l_output CZ_RULES.class_name%TYPE;
11970: l_reverse_string CZ_RULES.class_name%TYPE;
11971: l_reverse_pattern CZ_RULES.class_name%TYPE;
11972: l_index NUMBER;
11973: l_next_index NUMBER;
11974: BEGIN

Line 11971: l_reverse_pattern CZ_RULES.class_name%TYPE;

11967: FUNCTION convertClassName(p_class_name IN VARCHAR2,p_pattern IN VARCHAR2) RETURN VARCHAR2 IS
11968: l_substr CZ_RULES.class_name%TYPE;
11969: l_output CZ_RULES.class_name%TYPE;
11970: l_reverse_string CZ_RULES.class_name%TYPE;
11971: l_reverse_pattern CZ_RULES.class_name%TYPE;
11972: l_index NUMBER;
11973: l_next_index NUMBER;
11974: BEGIN
11975:

Line 12008: l_new_class_name CZ_RULES.class_name%TYPE;

12004: x_return_status OUT NOCOPY VARCHAR2,
12005: x_msg_count OUT NOCOPY NUMBER,
12006: x_msg_data OUT NOCOPY VARCHAR2
12007: ) IS
12008: l_new_class_name CZ_RULES.class_name%TYPE;
12009: BEGIN
12010:
12011: x_return_status := FND_API.g_ret_sts_success;
12012: x_msg_count := 0;

Line 12016: FROM CZ_RULES rul,

12012: x_msg_count := 0;
12013: x_msg_data := '';
12014:
12015: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id
12016: FROM CZ_RULES rul,
12017: CZ_EXPRESSION_NODES expr,
12018: CZ_SIGNATURE_ARGUMENTS args
12019: WHERE rul.rule_type = 300 AND rul.devl_project_id = p_model_id AND
12020: expr.rule_id = rul.rule_id AND expr.expr_parent_id is null AND

Line 12035: UPDATE CZ_RULES

12031: WHERE class_name = arg.java_data_type);
12032:
12033: l_new_class_name := convertClassName(i.class_name,'emu');
12034: IF l_new_class_name<>i.class_name THEN
12035: UPDATE CZ_RULES
12036: SET class_name=l_new_class_name
12037: WHERE rule_id=i.rule_id;
12038: END IF;
12039: