APPS.CN_RULES_DISP_PUB dependencies on CN_RULES

Line 1: PACKAGE BODY cn_rules_disp_pub AS

1: PACKAGE BODY cn_rules_disp_pub AS
2: --$Header: cnprulb.pls 115.6 2002/11/21 21:06:23 hlchen ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_RULES_DISP_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnrulb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_RULES_DISP_PUB';

1: PACKAGE BODY cn_rules_disp_pub AS
2: --$Header: cnprulb.pls 115.6 2002/11/21 21:06:23 hlchen ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_RULES_DISP_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnrulb.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;

Line 56: FROM cn_rules cnr, cn_revenue_classes cnrc

52:
53: CURSOR rules_cur1(l_parent_rule_id NUMBER, l_ruleset_id NUMBER) IS
54: SELECT 0 rule_level, cnr.name rule_name, cnrc.name revenue_class,
55: cnr.rule_id rule_id
56: FROM cn_rules cnr, cn_revenue_classes cnrc
57: WHERE cnr.rule_id = Nvl(l_parent_rule_id,-1002)
58: AND cnr.ruleset_id = Nvl(l_ruleset_id,-1002)
59: AND cnr.revenue_class_id = cnrc.revenue_class_id (+)
60: AND cnr.rule_id IN (SELECT rule_id FROM cn_rules_hierarchy);

Line 60: AND cnr.rule_id IN (SELECT rule_id FROM cn_rules_hierarchy);

56: FROM cn_rules cnr, cn_revenue_classes cnrc
57: WHERE cnr.rule_id = Nvl(l_parent_rule_id,-1002)
58: AND cnr.ruleset_id = Nvl(l_ruleset_id,-1002)
59: AND cnr.revenue_class_id = cnrc.revenue_class_id (+)
60: AND cnr.rule_id IN (SELECT rule_id FROM cn_rules_hierarchy);
61:
62: CURSOR rules_cur(l_parent_rule_id NUMBER, l_ruleset_id NUMBER) IS
63: SELECT a.rule_level rule_level,cnr.name rule_name,
64: cnrc.name revenue_class, a.rule_id rule_id

Line 68: FROM cn_rules_hierarchy

64: cnrc.name revenue_class, a.rule_id rule_id
65: FROM
66: (
67: SELECT level rule_level, rule_id, parent_rule_id, sequence_number
68: FROM cn_rules_hierarchy
69: WHERE ruleset_id=Nvl(l_ruleset_id,-1002)
70: CONNECT BY PRIOR rule_id = parent_rule_id
71: START WITH parent_rule_id = Nvl(l_parent_rule_id, -1002)
72: ) a , cn_rules cnr, cn_revenue_classes cnrc

Line 72: ) a , cn_rules cnr, cn_revenue_classes cnrc

68: FROM cn_rules_hierarchy
69: WHERE ruleset_id=Nvl(l_ruleset_id,-1002)
70: CONNECT BY PRIOR rule_id = parent_rule_id
71: START WITH parent_rule_id = Nvl(l_parent_rule_id, -1002)
72: ) a , cn_rules cnr, cn_revenue_classes cnrc
73: WHERE a.rule_id = cnr.rule_id
74: AND cnr.ruleset_id = Nvl(l_ruleset_id,-1002)
75: AND cnr.revenue_class_id = cnrc.revenue_class_id (+);
76:

Line 338: END cn_rules_disp_pub;

334: p_encoded => FND_API.G_FALSE
335: );
336:
337: END;
338: END cn_rules_disp_pub;