APPS.CN_RULE_PVT dependencies on CN_RULESETS

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 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 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 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 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 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 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 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) ';