[Home] [Help]
523: RETURN REPLACE(l_path, FND_GLOBAL.LOCAL_CHR(7) || FND_GLOBAL.LOCAL_CHR(8), '\''');
524: END get_Path;
525:
526: FUNCTION get_Property(p_property_id IN NUMBER) RETURN VARCHAR2 IS
527: l_property_name CZ_PROPERTIES.NAME%TYPE;
528: BEGIN
529: SELECT NAME INTO l_property_name FROM CZ_PROPERTIES
530: WHERE property_id=p_property_id;
531: RETURN '"' || l_property_name || '"';
525:
526: FUNCTION get_Property(p_property_id IN NUMBER) RETURN VARCHAR2 IS
527: l_property_name CZ_PROPERTIES.NAME%TYPE;
528: BEGIN
529: SELECT NAME INTO l_property_name FROM CZ_PROPERTIES
530: WHERE property_id=p_property_id;
531: RETURN '"' || l_property_name || '"';
532: END get_Property;
533:
1084:
1085: -- Bug 12567226
1086: -- Create new text if the type is translateable text
1087: FOR pspropval IN (SELECT propval.property_id, propval.data_num_value
1088: FROM cz_properties prop, cz_ps_prop_vals propval
1089: WHERE prop.property_id = propval.property_id
1090: AND propval.ps_node_id = l_new_node_id
1091: AND prop.data_type=8
1092: AND propval.deleted_flag = 0
4928:
4929: BEGIN
4930:
4931: x_return_status := FND_API.G_RET_STS_SUCCESS;
4932: x_new_property_id := allocateId('CZ_PROPERTIES_S');
4933: l_name := copy_name(p_property_id,'PRP');
4934: INSERT INTO CZ_PROPERTIES
4935: (
4936: PROPERTY_ID
4930:
4931: x_return_status := FND_API.G_RET_STS_SUCCESS;
4932: x_new_property_id := allocateId('CZ_PROPERTIES_S');
4933: l_name := copy_name(p_property_id,'PRP');
4934: INSERT INTO CZ_PROPERTIES
4935: (
4936: PROPERTY_ID
4937: ,PROPERTY_UNIT
4938: ,DESC_TEXT
4976: ,SECURITY_MASK
4977: ,EFF_MASK
4978: ,CHECKOUT_USER
4979: ,def_num_value
4980: FROM CZ_PROPERTIES
4981: WHERE property_id=p_property_id;
4982:
4983: IF SQL%ROWCOUNT = 0 THEN
4984: RAISE INVALID_PROPERTY_ID_EXCP;
4984: RAISE INVALID_PROPERTY_ID_EXCP;
4985: END IF;
4986:
4987: -- Create new text if the type is translateable text
4988: FOR i IN (SELECT def_num_value FROM cz_properties
4989: WHERE property_id=p_property_id
4990: AND data_type=8
4991: AND def_num_value IS NOT NULL) LOOP
4992: l_text_id := i.def_num_value;
4993: l_new_intl_text_id := copy_INTL_TEXT(i.def_num_value);
4994: IF l_new_intl_text_id = -1 THEN
4995: RAISE NO_TXT_FOUND_EXCP;
4996: END IF;
4997: UPDATE cz_properties
4998: SET def_num_value=l_new_intl_text_id
4999: WHERE property_id=x_new_property_id;
5000: END LOOP;
5001:
6806: AND object_type = 'PRP'
6807: AND deleted_flag = '0'
6808: AND seeded_flag <> '1';
6809:
6810: UPDATE cz_properties
6811: SET cz_properties.deleted_flag = '1',
6812: cz_properties.name = append_name(p_property_id, 'PRP', name)
6813: WHERE property_id = p_property_id;
6814: ELSE
6807: AND deleted_flag = '0'
6808: AND seeded_flag <> '1';
6809:
6810: UPDATE cz_properties
6811: SET cz_properties.deleted_flag = '1',
6812: cz_properties.name = append_name(p_property_id, 'PRP', name)
6813: WHERE property_id = p_property_id;
6814: ELSE
6815: x_return_status := l_return_status;
6808: AND seeded_flag <> '1';
6809:
6810: UPDATE cz_properties
6811: SET cz_properties.deleted_flag = '1',
6812: cz_properties.name = append_name(p_property_id, 'PRP', name)
6813: WHERE property_id = p_property_id;
6814: ELSE
6815: x_return_status := l_return_status;
6816: x_msg_count := l_msg_count;
8650: TYPE tIntegerTable IS TABLE OF PLS_INTEGER INDEX BY VARCHAR2(15);
8651: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8652:
8653: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
8654: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
8655: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;
8656: TYPE tExprParentId IS TABLE OF cz_expression_nodes.expr_parent_id%TYPE INDEX BY BINARY_INTEGER;
8657: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
8658: TYPE tExprTemplateId IS TABLE OF cz_expression_nodes.template_id%TYPE INDEX BY BINARY_INTEGER;
9090: --We don't want to account for deleted_flag in this query because we want to parse a rule even
9091: --if it refers to a deleted property instead of ignoring the rule.
9092:
9093: BEGIN
9094: SELECT name INTO v_Name FROM cz_properties
9095: WHERE property_id = v_ExprPropertyId(j);
9096:
9097: h_PropertyName(v_ExprPropertyId(j)) := v_Name;
9098:
10511: v_model_name VARCHAR2(2000);
10512: v_seeded_flag VARCHAR2(1);
10513: v_arg_count NUMBER;
10514: v_property_value VARCHAR2(4000);
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;
10918: v_parent_name := NULL;
10919:
10920: BEGIN
10921: SELECT name INTO v_property_name
10922: FROM cz_properties
10923: WHERE deleted_flag = '0'
10924: AND property_id = v_tPropertyId(i);
10925:
10926: SELECT parent_id, name INTO v_parent_id, v_item_name
12141: -- Property must be valid
12142: -- Added Boolean data type which is num type date with value 0 and 1
12143: BEGIN
12144: SELECT name, data_type INTO l_property_name, l_data_type
12145: FROM cz_properties
12146: WHERE property_id = p_property_id
12147: AND data_type IN (1,2,3,4)
12148: AND deleted_flag = '0';
12149: EXCEPTION