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.CN_RULEATTRIBUTE_PVT dependencies on CN_ATTRIBUTE_RULES

Line 29: l_value cn_attribute_rules.column_value%TYPE;

25: WHERE object_id = p_column_id
26: AND table_id IN (-11803,-16134) AND
27: ORG_ID=p_org_id;
28:
29: l_value cn_attribute_rules.column_value%TYPE;
30: l_date_value DATE;
31:
32: cursor get_rules IS
33: SELECT name

Line 171: from cn_attribute_rules where attribute_rule_id=c_attribute_rule_id and org_id=c_org_id;

167: low_value,
168: high_value,
169: column_value,
170: not_flag
171: from cn_attribute_rules where attribute_rule_id=c_attribute_rule_id and org_id=c_org_id;
172:
173:
174: begin
175: x_attribute_rule_id :=l_attribute_rule_id;

Line 224: from cn_attribute_rules where attribute_rule_id=c_attribute_rule_id and org_id=c_org_id;

220: low_value,
221: high_value,
222: column_value,
223: not_flag
224: from cn_attribute_rules where attribute_rule_id=c_attribute_rule_id and org_id=c_org_id;
225:
226:
227: begin
228: l_rendered := 1;

Line 266: (p_not_flag IN cn_attribute_rules.not_flag%TYPE := FND_API.G_MISS_CHAR,

262: -- History
263: -- 10-AUG-98 Ram Kalyanasundaram Created
264: --=============================================================================
265: FUNCTION Check_AttributeRuleParameters
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,

Line 272: p_org_id IN cn_attribute_rules.org_id%TYPE,

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,
275: p_loading_status IN VARCHAR2,
276: x_loading_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS

Line 273: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE := NULL,

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,
275: p_loading_status IN VARCHAR2,
276: x_loading_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
277:

Line 274: x_attribute_rule_id OUT NOCOPY cn_attribute_rules.attribute_rule_id%TYPE,

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,
275: p_loading_status IN VARCHAR2,
276: x_loading_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
277:
278: l_api_name VARCHAR2(30) := 'Check_AttributeRuleParameters';

Line 370: FROM cn_attribute_rules

366:
367: -- Added on 24/SEP/01
368: SELECT COUNT(*)
369: INTO l_counter
370: FROM cn_attribute_rules
371: WHERE column_id = l_object_column
372: AND column_value = p_value_1
373: AND rule_id = p_rule_id and org_id=p_org_id
374: AND ((p_attribute_rule_id IS NOT NULL AND

Line 388: -- FROM cn_attribute_rules

384: --IF l_counter = 1
385: --THEN
386: -- SELECT attribute_rule_id
387: -- INTO x_attribute_rule_id
388: -- FROM cn_attribute_rules
389: -- WHERE column_id = l_object_column
390: -- AND column_value = p_value_1
391: -- AND rule_id = p_rule_id and org_id=p_org_id
392: -- AND not_flag = nvl(l_not_flag,not_flag) ; -- Added Kumar;

Line 423: FROM cn_attribute_rules

419: END;
420:
421: SELECT COUNT(*)
422: INTO l_counter
423: FROM cn_attribute_rules
424: WHERE column_id = l_object_column
425: AND low_value = p_value_1
426: AND high_value = p_value_2
427: and org_id=p_org_id

Line 443: -- FROM cn_attribute_rules

439: -- Kumar Sivasankaran
440: --
441: -- SELECT attribute_rule_id
442: -- INTO x_attribute_rule_id
443: -- FROM cn_attribute_rules
444: -- WHERE column_id = l_object_column
445: -- AND low_value = p_value_1
446: -- AND high_value = p_value_2
447: -- AND rule_id = p_rule_id

Line 505: FROM cn_attribute_rules

501:
502:
503: SELECT COUNT(*)
504: INTO l_counter
505: FROM cn_attribute_rules
506: WHERE column_id = l_object_column
507: AND dimension_hierarchy_id = l_dim_hierarchy_id
508: AND column_value = l_hierarchy_value
509: AND rule_id = p_rule_id

Line 525: -- FROM cn_attribute_rules

521: --IF l_counter = 1
522: --THEN
523: -- SELECT attribute_rule_id
524: -- INTO x_attribute_rule_id
525: -- FROM cn_attribute_rules
526: -- WHERE column_id = l_object_column
527: -- AND dimension_hierarchy_id = l_dim_hierarchy_id
528: -- AND column_value = l_hierarchy_value
529: -- AND rule_id = p_rule_id

Line 738: SELECT Nvl(p_RuleAttribute_rec.attribute_rule_id, cn_attribute_rules_s.NEXTVAL)

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:
738: SELECT Nvl(p_RuleAttribute_rec.attribute_rule_id, cn_attribute_rules_s.NEXTVAL)
739: INTO l_attribute_rule_id
740: FROM dual;
741:
742: IF p_RuleAttribute_rec.data_flag IN ( 'O' , 'R') THEN

Line 953: l_object_version_number cn_attribute_rules.object_version_number%TYPE;

949: l_object_id NUMBER;
950: l_attribute_rule_id NUMBER;
951: l_ruleset_status VARCHAR2(100);
952:
953: l_object_version_number cn_attribute_rules.object_version_number%TYPE;
954:
955: G_LAST_UPDATE_DATE DATE := Sysdate;
956: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
957: G_CREATION_DATE DATE := Sysdate;

Line 963: FROM cn_attribute_rules

959: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
960:
961: CURSOR l_ovn_csr IS
962: SELECT object_version_number
963: FROM cn_attribute_rules
964: WHERE attribute_rule_id = p_ruleattribute_rec.attribute_rule_id
965: AND ruleset_id = p_ruleattribute_rec.ruleset_id
966: AND rule_id = p_ruleattribute_rec.rule_id
967: AND ORG_ID=p_RuleAttribute_rec.org_id;

Line 1351: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,

1347: x_return_status OUT NOCOPY VARCHAR2,
1348: x_msg_count OUT NOCOPY NUMBER,
1349: x_msg_data OUT NOCOPY VARCHAR2,
1350: x_loading_status OUT NOCOPY VARCHAR2,
1351: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
1352: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
1353: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
1354: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
1355: ) IS

Line 1352: p_rule_id IN cn_attribute_rules.rule_id%TYPE,

1348: x_msg_count OUT NOCOPY NUMBER,
1349: x_msg_data OUT NOCOPY VARCHAR2,
1350: x_loading_status OUT NOCOPY VARCHAR2,
1351: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
1352: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
1353: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
1354: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
1355: ) IS
1356:

Line 1353: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,

1349: x_msg_data OUT NOCOPY VARCHAR2,
1350: x_loading_status OUT NOCOPY VARCHAR2,
1351: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
1352: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
1353: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
1354: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
1355: ) IS
1356:
1357:

Line 1354: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE

1350: x_loading_status OUT NOCOPY VARCHAR2,
1351: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
1352: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
1353: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
1354: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
1355: ) IS
1356:
1357:
1358: l_api_name CONSTANT VARCHAR2(30) := 'Delete_RuleAttribute';

Line 1366: l_object_version_number cn_attribute_rules.object_version_number%TYPE;

1362: l_org_id NUMBER;
1363:
1364: l_ruleset_status VARCHAR2(100);
1365:
1366: l_object_version_number cn_attribute_rules.object_version_number%TYPE;
1367:
1368: G_LAST_UPDATE_DATE DATE := Sysdate;
1369: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1370: G_CREATION_DATE DATE := Sysdate;

Line 1376: FROM cn_attribute_rules

1372: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1373:
1374: CURSOR l_ovn_csr IS
1375: SELECT object_version_number
1376: FROM cn_attribute_rules
1377: WHERE attribute_rule_id = p_attribute_rule_id
1378: AND ruleset_id = p_ruleset_id
1379: AND rule_id = p_rule_id;
1380:

Line 1434: FROM cn_attribute_rules

1430: END IF;
1431:
1432: SELECT COUNT(1)
1433: INTO l_count
1434: FROM cn_attribute_rules
1435: WHERE attribute_rule_id = p_attribute_rule_id
1436: AND ruleset_id = p_ruleset_id
1437: AND rule_id = p_rule_id;
1438:

Line 1440: FROM cn_attribute_rules

1436: AND ruleset_id = p_ruleset_id
1437: AND rule_id = p_rule_id;
1438:
1439: select org_id into l_org_id
1440: FROM cn_attribute_rules
1441: WHERE attribute_rule_id = p_attribute_rule_id
1442: AND ruleset_id = p_ruleset_id
1443: AND rule_id = p_rule_id;
1444: