[Home] [Help]
4: --global variables
5: -----------------------------------------------
6: G_API_TYPE CONSTANT VARCHAR2(5) := '_PVT';
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_RULE_APIS_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: G_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_ERROR';
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_UNEXP_ERROR';
11: ------------------------------------------------
12: -- record structure for rule group
88: -- fetches data for line
89: --End of comments
90:
91: Procedure Get_Contract_Rgs(p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
93: p_chr_id IN NUMBER,
94: p_cle_id IN NUMBER,
95: p_rgd_code IN VARCHAR2 default Null,
96: x_return_status OUT NOCOPY VARCHAR2,
103: --Description : Gets all or specific rules for a rule group
104: -- End of Comments
105:
106: Procedure Get_Contract_Rules(p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
108: p_rgpv_rec IN rgpv_rec_type,
109: p_rdf_code IN VARCHAR2 default Null,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
123: -- p_rule_info : segment column value default Null
124: -- End of Comments
125:
126: Procedure Get_rule_Information (p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
128: p_rdf_code IN VARCHAR2,
129: p_appl_col_name IN VARCHAR2,
130: p_rule_info IN VARCHAR2 default Null,
131: x_return_status OUT NOCOPY VARCHAR2,
142: -- Also returns the select clause associated with the jtf_object
143: -- End of Comments
144:
145: Procedure Get_jtot_object(p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
147: p_object_code IN VARCHAR2,
148: p_id1 IN VARCHAR2 default null,
149: p_id2 IN VARCHAR2 default null,
150: x_return_status OUT NOCOPY VARCHAR2,
167: --Description : Fetches the displayed values of all rule segments
168: --End of Comments
169:
170: Procedure Get_Rule_disp_value (p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172: p_rulv_rec IN Rulv_rec_type,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
183: -- to be passed as p_rdf_name
184: --End of Comments
185:
186: Procedure Get_rule_Segment_Value(p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_chr_id IN NUMBER,
214: -- RULE_INFORMATION15. Segment Numbers 16, 17 and 18 are mapped
215: -- to jtot_object1, jtot_object2 and jtot_object3 respectively
216: --End of Comments
217: Procedure Get_rule_Segment_Value(p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_chr_id IN NUMBER,