APPS.CN_RULEATTRIBUTE_PVT dependencies on CN_OBJECTS

Line 24: FROM cn_objects

20: l_api_name VARCHAR2(30) := 'Check_Attr_Types';
21:
22: cursor get_cn_obj_curs IS
23: SELECT *
24: FROM cn_objects
25: WHERE object_id = p_column_id
26: AND table_id IN (-11803,-16134) AND
27: ORG_ID=p_org_id;
28:

Line 270: p_object_name IN cn_objects.name%TYPE,

266: (p_not_flag IN cn_attribute_rules.not_flag%TYPE := FND_API.G_MISS_CHAR,
267: p_value_1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_value_2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_data_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_object_name IN cn_objects.name%TYPE,
271: p_rule_id IN cn_rules.rule_id%TYPE,
272: p_org_id IN cn_attribute_rules.org_id%TYPE,
273: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE := NULL,
274: x_attribute_rule_id OUT NOCOPY cn_attribute_rules.attribute_rule_id%TYPE,

Line 350: FROM cn_objects

346: --Check to see if the attribute rule exists
347: BEGIN
348: SELECT object_id
349: INTO l_object_column
350: FROM cn_objects
351: WHERE name = p_object_name AND org_id=p_org_id
352: AND table_id IN (-11803,-16134);
353: EXCEPTION
354: WHEN no_data_found then

Line 733: FROM cn_objects

729: END IF;
730:
731: SELECT object_id
732: INTO l_object_id
733: FROM cn_objects
734: WHERE name = p_RuleAttribute_rec.object_name and
735: org_id=p_RuleAttribute_rec.org_id
736: AND table_id IN (-11803,-16134);
737:

Line 1125: FROM cn_objects

1121: END IF;
1122:
1123: SELECT object_id
1124: INTO l_object_id
1125: FROM cn_objects
1126: WHERE name = p_RuleAttribute_rec.object_name AND org_id=p_RuleAttribute_rec.org_id
1127: AND table_id IN (-11803,-16134);
1128:
1129: IF p_RuleAttribute_rec.data_flag IN ( 'O' , 'R') THEN

Line 1583: l_valueset_id cn_objects.value_set_id%TYPE;

1579: l_valueset_r fnd_vset.valueset_r;
1580: l_table_r fnd_vset.table_r;
1581: l_valueset_dr fnd_vset.valueset_dr;
1582: l_select_stmt VARCHAR2(4000);
1583: l_valueset_id cn_objects.value_set_id%TYPE;
1584:
1585: l_count NUMBER := 0;
1586: lov_return BOOLEAN;
1587: l_ret INTEGER;

Line 1592: FROM cn_objects

1588: l_cursor_num INTEGER;
1589:
1590: CURSOR c_get_valueset_id IS
1591: SELECT value_set_id
1592: FROM cn_objects
1593: WHERE object_id = p_column_id
1594: AND name = p_column_name
1595: AND object_type = 'COL'
1596: AND org_id=p_org_id