APPS.CN_RULE_PVT dependencies on CN_RULES_ALL

Line 542: from cn_rules_all where rule_id = p_old_rule_rec.rule_id

538: -- API body
539:
540: -- Check for object version number mismatch
541: select object_version_number into l_object_version_number
542: from cn_rules_all where rule_id = p_old_rule_rec.rule_id
543: and org_id = p_old_rule_rec.org_id;
544:
545: if (l_object_version_number <> p_rule_rec.object_version_no) then
546: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');

Line 850: p_rule_id IN cn_rules_all_b.rule_id%TYPE,

846: x_return_status OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: x_loading_status OUT NOCOPY VARCHAR2,
850: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
851: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
852: p_org_id IN cn_rules_all_b.org_id%TYPE
853: ) IS
854:

Line 851: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,

847: x_msg_count OUT NOCOPY NUMBER,
848: x_msg_data OUT NOCOPY VARCHAR2,
849: x_loading_status OUT NOCOPY VARCHAR2,
850: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
851: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
852: p_org_id IN cn_rules_all_b.org_id%TYPE
853: ) IS
854:
855: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';

Line 852: p_org_id IN cn_rules_all_b.org_id%TYPE

848: x_msg_data OUT NOCOPY VARCHAR2,
849: x_loading_status OUT NOCOPY VARCHAR2,
850: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
851: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
852: p_org_id IN cn_rules_all_b.org_id%TYPE
853: ) IS
854:
855: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';
856: l_api_version CONSTANT NUMBER := 1.0;