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_RULE_PVT dependencies on CN_RULES

Line 30: from cn_rulesets

26: l_api_name CONSTANT VARCHAR2(30) := 'valid_Rule';
27:
28: cursor get_rulesets_rec is
29: select module_type
30: from cn_rulesets
31: where ruleset_id = p_rule_rec.ruleset_id and
32: org_id=p_rule_rec.org_id;
33:
34: l_ruleset_rec get_rulesets_rec%ROWTYPE;

Line 96: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,

92: -- the sibling level and within the branch
93: --=============================================================================
94:
95: FUNCTION validate_rule_name
96: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
97: p_parent_rule_id IN cn_rules.rule_id%TYPE,
98: p_rule_name IN cn_rules.name%TYPE,
99: p_org_id IN cn_rules.org_id%TYPE,
100: p_loading_status IN VARCHAR2,

Line 97: p_parent_rule_id IN cn_rules.rule_id%TYPE,

93: --=============================================================================
94:
95: FUNCTION validate_rule_name
96: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
97: p_parent_rule_id IN cn_rules.rule_id%TYPE,
98: p_rule_name IN cn_rules.name%TYPE,
99: p_org_id IN cn_rules.org_id%TYPE,
100: p_loading_status IN VARCHAR2,
101: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS

Line 98: p_rule_name IN cn_rules.name%TYPE,

94:
95: FUNCTION validate_rule_name
96: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
97: p_parent_rule_id IN cn_rules.rule_id%TYPE,
98: p_rule_name IN cn_rules.name%TYPE,
99: p_org_id IN cn_rules.org_id%TYPE,
100: p_loading_status IN VARCHAR2,
101: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
102:

Line 99: p_org_id IN cn_rules.org_id%TYPE,

95: FUNCTION validate_rule_name
96: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
97: p_parent_rule_id IN cn_rules.rule_id%TYPE,
98: p_rule_name IN cn_rules.name%TYPE,
99: p_org_id IN cn_rules.org_id%TYPE,
100: p_loading_status IN VARCHAR2,
101: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
102:
103: CURSOR check_siblings_cur IS

Line 105: FROM cn_rules_hierarchy cnrh,

101: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
102:
103: CURSOR check_siblings_cur IS
104: SELECT count(*) cnt
105: FROM cn_rules_hierarchy cnrh,
106: cn_rules cnr
107: WHERE cnrh.parent_rule_id = p_parent_rule_id
108: AND cnr.ruleset_id = p_ruleset_id
109: AND cnrh.rule_id = cnr.rule_id

Line 106: cn_rules cnr

102:
103: CURSOR check_siblings_cur IS
104: SELECT count(*) cnt
105: FROM cn_rules_hierarchy cnrh,
106: cn_rules cnr
107: WHERE cnrh.parent_rule_id = p_parent_rule_id
108: AND cnr.ruleset_id = p_ruleset_id
109: AND cnrh.rule_id = cnr.rule_id
110: AND cnr.name = p_rule_name

Line 117: CURSOR check_parents_cur (p_parent_rule_id cn_rules.rule_id%TYPE)IS

113:
114: l_check_siblings_rec check_siblings_cur%ROWTYPE;
115:
116:
117: CURSOR check_parents_cur (p_parent_rule_id cn_rules.rule_id%TYPE)IS
118: SELECT cnrh.parent_rule_id,
119: cnr.name
120: FROM cn_rules_hierarchy cnrh,
121: cn_rules cnr

Line 120: FROM cn_rules_hierarchy cnrh,

116:
117: CURSOR check_parents_cur (p_parent_rule_id cn_rules.rule_id%TYPE)IS
118: SELECT cnrh.parent_rule_id,
119: cnr.name
120: FROM cn_rules_hierarchy cnrh,
121: cn_rules cnr
122: WHERE cnr.ruleset_id = p_ruleset_id
123: AND cnrh.rule_id = p_parent_rule_id
124: AND cnrh.rule_id = cnr.rule_id

Line 121: cn_rules cnr

117: CURSOR check_parents_cur (p_parent_rule_id cn_rules.rule_id%TYPE)IS
118: SELECT cnrh.parent_rule_id,
119: cnr.name
120: FROM cn_rules_hierarchy cnrh,
121: cn_rules cnr
122: WHERE cnr.ruleset_id = p_ruleset_id
123: AND cnrh.rule_id = p_parent_rule_id
124: AND cnrh.rule_id = cnr.rule_id
125: AND cnrh.org_id=cnr.org_id

Line 130: l_current_parent_rule_id cn_rules_hierarchy.parent_rule_id%TYPE;

126: AND cnr.org_id=p_org_id;
127:
128: l_check_parents_rec check_parents_cur%ROWTYPE;
129:
130: l_current_parent_rule_id cn_rules_hierarchy.parent_rule_id%TYPE;
131:
132: l_api_name VARCHAR2(30) := 'validate_rule_name';
133:
134: BEGIN

Line 322: FROM cn_rulesets

318:
319: --Now check if the ruleset exists.
320: SELECT count(1)
321: INTO l_count
322: FROM cn_rulesets
323: WHERE ruleset_id = p_rule_rec.ruleset_id
324: AND org_id= p_rule_rec.org_id;
325:
326: IF l_count = 0

Line 341: FROM cn_rules

337:
338: --Validate the parent rule
339: SELECT count(1)
340: INTO l_count
341: FROM cn_rules
342: WHERE rule_id = p_rule_rec.parent_rule_id and
343: org_id=p_rule_rec.org_id;
344:
345: --Fetch rule_id into l_rule_id

Line 346: SELECT Decode(p_rule_rec.rule_id, NULL,cn_rules_s.NEXTVAL, p_rule_rec.rule_id)

342: WHERE rule_id = p_rule_rec.parent_rule_id and
343: org_id=p_rule_rec.org_id;
344:
345: --Fetch rule_id into l_rule_id
346: SELECT Decode(p_rule_rec.rule_id, NULL,cn_rules_s.NEXTVAL, p_rule_rec.rule_id)
347: INTO l_rule_id
348: FROM dual;
349:
350: --Since this is a new rule, validate the rule name before inserting

Line 373: FROM cn_rules_hierarchy

369: IF p_rule_rec.sequence_number IS NULL
370: then
371: SELECT nvl(MAX(nvl(sequence_number, 0)),0) + 1
372: INTO l_sequence_number
373: FROM cn_rules_hierarchy
374: WHERE ruleset_id = p_rule_rec.ruleset_id;
375: ELSE
376: l_sequence_number := p_rule_rec.sequence_number;
377: END IF;

Line 408: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_rule_rec.ruleset_id,

404: p_rule_rec.org_id);
405:
406: x_rule_id := l_rule_id;
407:
408: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_rule_rec.ruleset_id,
409: x_ruleset_status_in => l_ruleset_status,
410: x_org_id => p_rule_rec.org_id);
411:
412: -- End of API body.

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 646: FROM cn_rulesets

642:
643: --Now check if the ruleset exists.
644: SELECT count(1)
645: INTO l_count
646: FROM cn_rulesets
647: WHERE ruleset_id = p_rule_rec.ruleset_id;
648:
649: IF l_count = 0
650: THEN

Line 669: FROM cn_rules

665:
666: --Validate the parent rule
667: SELECT count(1)
668: INTO l_count
669: FROM cn_rules
670: WHERE rule_id = p_rule_rec.parent_rule_id and
671: org_id=p_rule_rec.org_id;
672: IF l_count = 0
673: THEN

Line 688: FROM cn_rules

684:
685:
686: SELECT COUNT(1)
687: INTO l_count
688: FROM cn_rules
689: WHERE rule_id = p_old_rule_rec.rule_id
690: and org_id=p_rule_rec.org_id;
691: IF l_count = 0
692: THEN

Line 756: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_rule_rec.ruleset_id,

752: g_last_update_login,
753: p_rule_rec.org_id,
754: p_rule_rec.object_version_no);
755:
756: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_rule_rec.ruleset_id,
757: x_ruleset_status_in => l_ruleset_status,
758: x_org_id => p_rule_rec.org_id);
759:
760: -- End of API body.

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;

Line 892: FROM cn_rules_hierarchy

888: SELECT COUNT(1)
889: INTO l_count
890: FROM
891: ( SELECT rule_id ,ruleset_id
892: FROM cn_rules_hierarchy
893: WHERE ruleset_id=Nvl(p_ruleset_id ,-1002) and org_id=p_org_id
894: CONNECT BY PRIOR rule_id = parent_rule_id
895: START WITH rule_id = Nvl(p_rule_id, -1002)
896: )a WHERE EXISTS

Line 918: FROM cn_rules

914: END IF;
915:
916: SELECT COUNT(1)
917: INTO l_count
918: FROM cn_rules
919: WHERE ruleset_id = p_ruleset_id
920: AND rule_id = p_rule_id and
921: org_id=p_org_id;
922:

Line 939: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_ruleset_id,

935: END IF;
936:
937: cn_syin_rules_pkg.delete_row(p_rule_id, p_ruleset_id,p_org_id);
938:
939: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_ruleset_id,
940: x_ruleset_status_in => l_ruleset_status,
941: x_org_id => p_org_id);
942:
943:

Line 1003: p_ruleset_name IN cn_rulesets_all_tl.name%TYPE,

999: p_validation_level IN NUMBER,
1000: x_return_status OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY NUMBER,
1002: x_msg_data OUT NOCOPY VARCHAR2,
1003: p_ruleset_name IN cn_rulesets_all_tl.name%TYPE,
1004: p_start_record IN NUMBER,
1005: p_increment_count IN NUMBER,
1006: p_order_by IN VARCHAR2,
1007: x_rule_tbl OUT NOCOPY rule_tbl_type,

Line 1011: p_org_id IN cn_rulesets_all_tl.org_id%TYPE

1007: x_rule_tbl OUT NOCOPY rule_tbl_type,
1008: x_total_records OUT NOCOPY NUMBER,
1009: x_status OUT NOCOPY VARCHAR2,
1010: x_loading_status OUT NOCOPY VARCHAR2,
1011: p_org_id IN cn_rulesets_all_tl.org_id%TYPE
1012: ) IS
1013:
1014: TYPE rulecurtype IS ref CURSOR;
1015: rule_cur rulecurtype;

Line 1023: l_ruleset_id cn_rulesets.ruleset_id%TYPE;

1019: l_api_version CONSTANT NUMBER := 1.0;
1020:
1021:
1022:
1023: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1024: l_rule_id cn_rules.rule_id%TYPE;
1025: l_rule_name cn_rules.name%TYPE;
1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;

Line 1024: l_rule_id cn_rules.rule_id%TYPE;

1020:
1021:
1022:
1023: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1024: l_rule_id cn_rules.rule_id%TYPE;
1025: l_rule_name cn_rules.name%TYPE;
1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;
1028: l_expense_ccid cn_rules.expense_ccid%TYPE;

Line 1025: l_rule_name cn_rules.name%TYPE;

1021:
1022:
1023: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1024: l_rule_id cn_rules.rule_id%TYPE;
1025: l_rule_name cn_rules.name%TYPE;
1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;
1028: l_expense_ccid cn_rules.expense_ccid%TYPE;
1029: l_liability_ccid cn_rules.liability_ccid%TYPE;

Line 1026: l_ruleset_name cn_rulesets.name%TYPE;

1022:
1023: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1024: l_rule_id cn_rules.rule_id%TYPE;
1025: l_rule_name cn_rules.name%TYPE;
1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;
1028: l_expense_ccid cn_rules.expense_ccid%TYPE;
1029: l_liability_ccid cn_rules.liability_ccid%TYPE;
1030: l_org_id cn_rules.org_id%TYPE;

Line 1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;

1023: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1024: l_rule_id cn_rules.rule_id%TYPE;
1025: l_rule_name cn_rules.name%TYPE;
1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;
1028: l_expense_ccid cn_rules.expense_ccid%TYPE;
1029: l_liability_ccid cn_rules.liability_ccid%TYPE;
1030: l_org_id cn_rules.org_id%TYPE;
1031: l_expense_ccid_disp varchar2(2000);

Line 1028: l_expense_ccid cn_rules.expense_ccid%TYPE;

1024: l_rule_id cn_rules.rule_id%TYPE;
1025: l_rule_name cn_rules.name%TYPE;
1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;
1028: l_expense_ccid cn_rules.expense_ccid%TYPE;
1029: l_liability_ccid cn_rules.liability_ccid%TYPE;
1030: l_org_id cn_rules.org_id%TYPE;
1031: l_expense_ccid_disp varchar2(2000);
1032: l_liability_ccid_disp varchar2(2000);

Line 1029: l_liability_ccid cn_rules.liability_ccid%TYPE;

1025: l_rule_name cn_rules.name%TYPE;
1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;
1028: l_expense_ccid cn_rules.expense_ccid%TYPE;
1029: l_liability_ccid cn_rules.liability_ccid%TYPE;
1030: l_org_id cn_rules.org_id%TYPE;
1031: l_expense_ccid_disp varchar2(2000);
1032: l_liability_ccid_disp varchar2(2000);
1033: l_revenue_class_name cn_revenue_classes.name%TYPE;

Line 1030: l_org_id cn_rules.org_id%TYPE;

1026: l_ruleset_name cn_rulesets.name%TYPE;
1027: l_revenue_class_id cn_rules.revenue_class_id%TYPE;
1028: l_expense_ccid cn_rules.expense_ccid%TYPE;
1029: l_liability_ccid cn_rules.liability_ccid%TYPE;
1030: l_org_id cn_rules.org_id%TYPE;
1031: l_expense_ccid_disp varchar2(2000);
1032: l_liability_ccid_disp varchar2(2000);
1033: l_revenue_class_name cn_revenue_classes.name%TYPE;
1034:

Line 1047: FROM cn_rulesets rset, cn_rules rule

1043: rule.revenue_class_id,
1044: rule.expense_ccid,
1045: rule.liability_id,
1046: rule.org_id
1047: FROM cn_rulesets rset, cn_rules rule
1048: WHERE rset.ruleset_id = rule.ruleset_id AND
1049: rset.org_id=rule.org_id AND
1050: rset.org_id=:B1 AND
1051: upper(rset.name) like upper(:B2) ';