[Home] [Help]
PACKAGE: APPS.OKL_RULE_EXTRACT_PVT
Source
1 Package OKL_RULE_EXTRACT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRREXS.pls 120.1.12020000.2 2012/11/30 04:44:56 racheruv ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
7 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
8 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
9 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
10 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
11 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
14 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
15 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
16 G_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_ERROR';
17 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
19 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
20 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
21 ------------------------------------------------------------------------------------
22 -- GLOBAL EXCEPTION
23 ---------------------------------------------------------------------------
24 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
25 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
26 G_API_VERSION CONSTANT NUMBER := 1.0;
27 G_SCOPE CONSTANT VARCHAR2(4) := '_PVT';
28 -- GLOBAL VARIABLES
29 ---------------------------------------------------------------------------
30 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RULE_EXTRACT_PVT';
31 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32 ---------------------------------------------------------------------------
33 --structures to hold rule code records
34 Type rule_rec_type is record ( rgs_code FND_DESCR_FLEX_COL_USAGE_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE := OKC_API.G_MISS_CHAR,
35 application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
36 column_seq_num VARCHAR2(3) := OKC_API.G_MISS_CHAR);
37 Type rule_tbl_type is table of rule_rec_type index by BINARY_INTEGER;
38 --structures to hold subclass-rulegroup records
39 Type sc_rg_rec_type is record (scs_code OKC_SUBCLASS_RG_DEFS.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40 rgd_code OKC_SUBCLASS_RG_DEFS.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
41 meaning FND_LOOKUPS.MEANING%TYPE := OKC_API.G_MISS_CHAR,
42 description FND_LOOKUPS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
43 Type sc_rg_tbl_type is table of sc_rg_Rec_Type index by BINARY_INTEGER;
44 --structures to hold rule group - rules records
45 Type rg_rules_rec_type is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
46 rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
47 application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
48 column_seq_num VARCHAR2(3) := OKC_API.G_MISS_CHAR,
49 optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
50 min_cardinality VARCHAR2(9) := OKC_API.G_MISS_CHAR,
51 max_cardinality VARCHAR2(9) := OKC_API.G_MISS_CHAR);
52 Type rg_rules_tbl_type is table of rg_rules_rec_type index by BINARY_INTEGER;
53 --structures to hold rule-segment records
54 --this will hold the retreived metadata for rendering of
55 --rule segments
56 Type rul_segment_rec_type is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
57 rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
58 application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
59 end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
60 sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
61 enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62 displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63 required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64 default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
65 left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
66 select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
67 from_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
68 where_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
69 order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
70 object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
71 longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
72 format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
73 id1_col varchar2(30),
74 id2_col varchar2(30),
75 rule_info_col varchar2(30),
76 name_col varchar2(30),
77 value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
78 additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE);
79 Type rule_segment_tbl_type is table of rul_segment_rec_type index by BINARY_INTEGER;
80
81 -- bug 3029276
82 Type rule_segment_rec_type2 is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
83 rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
84 application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
85 end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
86 sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
87 enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88 displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
89 required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90 default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
91 left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
92 select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
93 from_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
94 where_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
95 order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
96 object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
97 longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
98 format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
99 id1_col varchar2(30),
100 id2_col varchar2(30),
101 rule_info_col varchar2(30),
102 name_col varchar2(30),
103 value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
104 additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,
105 x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
106 x_id2 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
107 x_name VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
108 x_desc VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
109 x_segment_status VARCHAR2(7) := 'VALID'
110 );
111 Type rule_segment_tbl_type2 is table of rule_segment_rec_type2 index by BINARY_INTEGER;
112
113 subtype rulv_rec_type is OKL_RULE_PUB.rulv_rec_type;
114 --------------------------
115
116
117
118 --start of comments
119 --API Name : Get_Subclass_Rgs
120 --Description :API to fetch all the rule groups attached to a subclass
121 --end of comments
122 PROCEDURE Get_subclass_Rgs (p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_chr_id IN Varchar2,
128 x_sc_rg_tbl OUT NOCOPY sc_rg_tbl_type);
129 --start of comments
130 --API Name : Get_Rg_Rules
131 --Description : API to fetch all the rules attached to a rule group
132 --end of comments
133 PROCEDURE Get_Rg_Rules (p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_rgd_code IN Varchar2,
139 x_rg_rules_tbl OUT NOCOPY rg_rules_tbl_type);
140 --start of comments
141 --API Name : Get_Rule_Def
142 --Description : API to fetch rule definition - metadata for each rule segment
143 --end of comments
144 PROCEDURE Get_Rule_Def (p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_rgd_code IN VARCHAR2,
150 p_rgs_code IN VARCHAR2,
151 p_buy_or_sell IN VARCHAR2,
152 x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type);
153
154 -- bug 3029276
155
156 PROCEDURE Get_Rules_Metadata (p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_rgd_code IN VARCHAR2,
162 p_rgs_code IN VARCHAR2,
163 p_buy_or_sell IN VARCHAR2,
164 p_contract_id IN OKC_K_HEADERS_B.ID%TYPE := OKC_API.G_MISS_NUM,
165 p_line_id IN OKC_K_LINES_B.ID%TYPE := OKC_API.G_MISS_NUM,
166 p_party_id IN OKC_K_PARTY_ROLES_B.ID%TYPE := OKC_API.G_MISS_NUM,
167 p_template_table IN VARCHAR2,
168 p_rule_id_column IN VARCHAR2,
169 p_entity_column IN VARCHAR2,
170 x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type2);
171
172 ---------- -- end bug 3029276
173
174 End OKL_RULE_EXTRACT_PVT;