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,
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;