41: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RULE_EXTRACT_PUB';
42: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
43: ---------------------------------------------------------------------------
44: --structures to hold rule code records
45: SUBTYPE rule_rec_type is OKL_RULE_EXTRACT_PVT.rule_rec_type;
46: SUBTYPE rule_tbl_type is OKL_RULE_EXTRACT_PVT.rule_tbl_type;
47: --structures to hold subclass-rulegroup records
48: SUBTYPE sc_rg_rec_type is OKL_RULE_EXTRACT_PVT.sc_rg_rec_type;
49: SUBTYPE sc_rg_tbl_type is OKL_RULE_EXTRACT_PVT.sc_rg_tbl_type;
42: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
43: ---------------------------------------------------------------------------
44: --structures to hold rule code records
45: SUBTYPE rule_rec_type is OKL_RULE_EXTRACT_PVT.rule_rec_type;
46: SUBTYPE rule_tbl_type is OKL_RULE_EXTRACT_PVT.rule_tbl_type;
47: --structures to hold subclass-rulegroup records
48: SUBTYPE sc_rg_rec_type is OKL_RULE_EXTRACT_PVT.sc_rg_rec_type;
49: SUBTYPE sc_rg_tbl_type is OKL_RULE_EXTRACT_PVT.sc_rg_tbl_type;
50: --structures to hold rule group - rules records
44: --structures to hold rule code records
45: SUBTYPE rule_rec_type is OKL_RULE_EXTRACT_PVT.rule_rec_type;
46: SUBTYPE rule_tbl_type is OKL_RULE_EXTRACT_PVT.rule_tbl_type;
47: --structures to hold subclass-rulegroup records
48: SUBTYPE sc_rg_rec_type is OKL_RULE_EXTRACT_PVT.sc_rg_rec_type;
49: SUBTYPE sc_rg_tbl_type is OKL_RULE_EXTRACT_PVT.sc_rg_tbl_type;
50: --structures to hold rule group - rules records
51: SUBTYPE rg_rules_rec_type is OKL_RULE_EXTRACT_PVT.rg_rules_rec_type;
52: SUBTYPE rg_rules_tbl_type is OKL_RULE_EXTRACT_PVT.rg_rules_tbl_type;
45: SUBTYPE rule_rec_type is OKL_RULE_EXTRACT_PVT.rule_rec_type;
46: SUBTYPE rule_tbl_type is OKL_RULE_EXTRACT_PVT.rule_tbl_type;
47: --structures to hold subclass-rulegroup records
48: SUBTYPE sc_rg_rec_type is OKL_RULE_EXTRACT_PVT.sc_rg_rec_type;
49: SUBTYPE sc_rg_tbl_type is OKL_RULE_EXTRACT_PVT.sc_rg_tbl_type;
50: --structures to hold rule group - rules records
51: SUBTYPE rg_rules_rec_type is OKL_RULE_EXTRACT_PVT.rg_rules_rec_type;
52: SUBTYPE rg_rules_tbl_type is OKL_RULE_EXTRACT_PVT.rg_rules_tbl_type;
53: --structures to hold rule-segment records
47: --structures to hold subclass-rulegroup records
48: SUBTYPE sc_rg_rec_type is OKL_RULE_EXTRACT_PVT.sc_rg_rec_type;
49: SUBTYPE sc_rg_tbl_type is OKL_RULE_EXTRACT_PVT.sc_rg_tbl_type;
50: --structures to hold rule group - rules records
51: SUBTYPE rg_rules_rec_type is OKL_RULE_EXTRACT_PVT.rg_rules_rec_type;
52: SUBTYPE rg_rules_tbl_type is OKL_RULE_EXTRACT_PVT.rg_rules_tbl_type;
53: --structures to hold rule-segment records
54: --this will hold the retreived metadata for rendering of
55: --rule segments
48: SUBTYPE sc_rg_rec_type is OKL_RULE_EXTRACT_PVT.sc_rg_rec_type;
49: SUBTYPE sc_rg_tbl_type is OKL_RULE_EXTRACT_PVT.sc_rg_tbl_type;
50: --structures to hold rule group - rules records
51: SUBTYPE rg_rules_rec_type is OKL_RULE_EXTRACT_PVT.rg_rules_rec_type;
52: SUBTYPE rg_rules_tbl_type is OKL_RULE_EXTRACT_PVT.rg_rules_tbl_type;
53: --structures to hold rule-segment records
54: --this will hold the retreived metadata for rendering of
55: --rule segments
56: SUBTYPE rul_segment_rec_type is OKL_RULE_EXTRACT_PVT.rul_segment_rec_type;
52: SUBTYPE rg_rules_tbl_type is OKL_RULE_EXTRACT_PVT.rg_rules_tbl_type;
53: --structures to hold rule-segment records
54: --this will hold the retreived metadata for rendering of
55: --rule segments
56: SUBTYPE rul_segment_rec_type is OKL_RULE_EXTRACT_PVT.rul_segment_rec_type;
57: SUBTYPE rule_segment_tbl_type is OKL_RULE_EXTRACT_PVT.rule_segment_tbl_type;
58: -- bug 3029276.
59: --structures to hold rule-segment records
60: --this will hold the retreived metadata for rendering of
53: --structures to hold rule-segment records
54: --this will hold the retreived metadata for rendering of
55: --rule segments
56: SUBTYPE rul_segment_rec_type is OKL_RULE_EXTRACT_PVT.rul_segment_rec_type;
57: SUBTYPE rule_segment_tbl_type is OKL_RULE_EXTRACT_PVT.rule_segment_tbl_type;
58: -- bug 3029276.
59: --structures to hold rule-segment records
60: --this will hold the retreived metadata for rendering of
61: --rule segments and also to hold ids and names for each segment.
58: -- bug 3029276.
59: --structures to hold rule-segment records
60: --this will hold the retreived metadata for rendering of
61: --rule segments and also to hold ids and names for each segment.
62: SUBTYPE rule_segment_rec_type2 is OKL_RULE_EXTRACT_PVT.rule_segment_rec_type2;
63: SUBTYPE rule_segment_tbl_type2 is OKL_RULE_EXTRACT_PVT.rule_segment_tbl_type2;
64:
65: --start of comments
66: --API Name : Get_Subclass_Rgs
59: --structures to hold rule-segment records
60: --this will hold the retreived metadata for rendering of
61: --rule segments and also to hold ids and names for each segment.
62: SUBTYPE rule_segment_rec_type2 is OKL_RULE_EXTRACT_PVT.rule_segment_rec_type2;
63: SUBTYPE rule_segment_tbl_type2 is OKL_RULE_EXTRACT_PVT.rule_segment_tbl_type2;
64:
65: --start of comments
66: --API Name : Get_Subclass_Rgs
67: --Description :API to fetch all the rule groups attached to a subclass