APPS.CN_RULE_PUB dependencies on CN_RULE_PVT

Line 62: --SK l_rule_rec cn_rule_pvt.rule_rec_type;

58: l_api_name CONSTANT VARCHAR2(30) := 'Create_Rule';
59: l_api_version CONSTANT NUMBER := 1.0;
60: l_loading_status VARCHAR2(4000);
61: l_count NUMBER;
62: --SK l_rule_rec cn_rule_pvt.rule_rec_type;
63: l_rule_rec_pvt cn_rule_pvt.rule_rec_type;
64: l_bind_data_id NUMBER;
65: l_return_code VARCHAR2(1);
66:

Line 63: l_rule_rec_pvt cn_rule_pvt.rule_rec_type;

59: l_api_version CONSTANT NUMBER := 1.0;
60: l_loading_status VARCHAR2(4000);
61: l_count NUMBER;
62: --SK l_rule_rec cn_rule_pvt.rule_rec_type;
63: l_rule_rec_pvt cn_rule_pvt.rule_rec_type;
64: l_bind_data_id NUMBER;
65: l_return_code VARCHAR2(1);
66:
67:

Line 382: cn_rule_pvt.create_rule

378: WHERE ruleset_id = l_rule_rec_pvt.ruleset_id
379: AND parent_rule_id = l_rule_rec_pvt.parent_rule_id and
380: org_id=l_rule_rec_pvt.org_id;
381:
382: cn_rule_pvt.create_rule
383: (p_api_version => p_api_version,
384: p_init_msg_list => p_init_msg_list,
385: p_commit => p_commit,
386: p_validation_level => p_validation_level,

Line 632: l_rule_rec_pvt cn_rule_pvt.rule_rec_type;

628:
629: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';
630: l_api_version CONSTANT NUMBER := 1.0;
631: l_count NUMBER;
632: l_rule_rec_pvt cn_rule_pvt.rule_rec_type;
633: l_old_rule_rec_pvt cn_rule_pvt.rule_rec_type;
634:
635:
636:

Line 633: l_old_rule_rec_pvt cn_rule_pvt.rule_rec_type;

629: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';
630: l_api_version CONSTANT NUMBER := 1.0;
631: l_count NUMBER;
632: l_rule_rec_pvt cn_rule_pvt.rule_rec_type;
633: l_old_rule_rec_pvt cn_rule_pvt.rule_rec_type;
634:
635:
636:
637: --

Line 1025: cn_rule_pvt.update_rule

1021: THEN
1022: FOR j IN parent_rules(l_rule_rec_pvt.ruleset_id,l_rule_rec_pvt.org_id)
1023: LOOP
1024: l_rule_rec_pvt.parent_rule_id := j.rule_id;
1025: cn_rule_pvt.update_rule
1026: (p_api_version => p_api_version,
1027: p_init_msg_list => p_init_msg_list,
1028: p_commit => p_commit,
1029: p_validation_level => p_validation_level,

Line 1046: cn_rule_pvt.update_rule

1042: END IF;
1043: END LOOP;
1044: ELSE
1045: l_rule_rec_pvt.parent_rule_id := i.parent_rule_id;
1046: cn_rule_pvt.update_rule
1047: (p_api_version => p_api_version,
1048: p_init_msg_list => p_init_msg_list,
1049: p_commit => p_commit,
1050: p_validation_level => p_validation_level,

Line 1451: cn_rule_pvt.delete_rule

1447:
1448:
1449: FOR i IN get_rules(l_ruleset_id,l_org_id)
1450: LOOP
1451: cn_rule_pvt.delete_rule
1452: (p_api_version => p_api_version,
1453: p_init_msg_list => p_init_msg_list,
1454: p_commit => p_commit,
1455: p_validation_level => p_validation_level,