[Home] [Help]
PACKAGE: APPS.OKL_FUNDING_CHECKLIST_PVT
Source
1 PACKAGE OKL_FUNDING_CHECKLIST_PVT AS
2 /* $Header: OKLRCLFS.pls 120.1 2005/05/27 17:26:05 cklee noship $ */
3 ----------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ----------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FUNDING_CHECKLIST_PVT';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8
9 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12 G_EXCEPTION_ERROR EXCEPTION;
13 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
18
19 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
20 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
21 G_UI_DATE_MASK VARCHAR2(15) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
22 G_OKL_LLA_INVALID_DATE_FORMAT CONSTANT VARCHAR2(30) := 'OKL_LLA_INVALID_DATE_FORMAT';
23 G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
24 G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
25 G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
26 G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28
29 ----------------------------------------------------------------------------
30 -- Data Structures
31 ----------------------------------------------------------------------------
32
33 TYPE rulv_rec_type IS RECORD (
34 id NUMBER := OKC_API.G_MISS_NUM,
35 -- object_version_number NUMBER := OKC_API.G_MISS_NUM,
36 -- sfwt_flag OKC_RULES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
37 object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
38 -- object2_id1 OKC_RULES_V.OBJECT2_ID1%TYPE := OKC_API.G_MISS_CHAR,
39 -- object3_id1 OKC_RULES_V.OBJECT3_ID1%TYPE := OKC_API.G_MISS_CHAR,
40 object1_id2 OKC_RULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
41 -- object2_id2 OKC_RULES_V.OBJECT2_ID2%TYPE := OKC_API.G_MISS_CHAR,
42 -- object3_id2 OKC_RULES_V.OBJECT3_ID2%TYPE := OKC_API.G_MISS_CHAR,
43 -- jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44 -- jtot_object2_code OKC_RULES_V.JTOT_OBJECT2_CODE%TYPE := OKC_API.G_MISS_CHAR,
45 -- jtot_object3_code OKC_RULES_V.JTOT_OBJECT3_CODE%TYPE := OKC_API.G_MISS_CHAR,
46 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
47 rgp_id NUMBER := OKC_API.G_MISS_NUM,
48 -- priority NUMBER := OKC_API.G_MISS_NUM,
49 -- std_template_yn OKC_RULES_V.STD_TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
50 -- comments OKC_RULES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
51 -- warn_yn OKC_RULES_V.WARN_YN%TYPE := OKC_API.G_MISS_CHAR,
52 -- attribute_category OKC_RULES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53 -- attribute1 OKC_RULES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54 -- attribute2 OKC_RULES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55 -- attribute3 OKC_RULES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56 -- attribute4 OKC_RULES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57 -- attribute5 OKC_RULES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58 -- attribute6 OKC_RULES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59 -- attribute7 OKC_RULES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60 -- attribute8 OKC_RULES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61 -- attribute9 OKC_RULES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62 -- attribute10 OKC_RULES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63 -- attribute11 OKC_RULES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64 -- attribute12 OKC_RULES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65 -- attribute13 OKC_RULES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66 -- attribute14 OKC_RULES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67 -- attribute15 OKC_RULES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68 -- created_by NUMBER := OKC_API.G_MISS_NUM,
69 -- creation_date OKC_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70 -- last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71 -- last_update_date OKC_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72 -- last_update_login NUMBER := OKC_API.G_MISS_NUM,
73 --text OKC_RULES_V.TEXT%TYPE := NULL,
74 rule_information_category OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75 rule_information1 OKC_RULES_V.RULE_INFORMATION1%TYPE := OKC_API.G_MISS_CHAR,
76 rule_information2 OKC_RULES_V.RULE_INFORMATION2%TYPE := OKC_API.G_MISS_CHAR,
77 rule_information3 OKC_RULES_V.RULE_INFORMATION3%TYPE := OKC_API.G_MISS_CHAR,
78 rule_information4 OKC_RULES_V.RULE_INFORMATION4%TYPE := OKC_API.G_MISS_CHAR,
79 rule_information5 OKC_RULES_V.RULE_INFORMATION5%TYPE := OKC_API.G_MISS_CHAR,
80 rule_information6 OKC_RULES_V.RULE_INFORMATION6%TYPE := OKC_API.G_MISS_CHAR,
81 rule_information7 OKC_RULES_V.RULE_INFORMATION7%TYPE := OKC_API.G_MISS_CHAR,
82 rule_information8 OKC_RULES_V.RULE_INFORMATION8%TYPE := OKC_API.G_MISS_CHAR,
83 rule_information9 OKC_RULES_V.RULE_INFORMATION9%TYPE := OKC_API.G_MISS_CHAR,
84 rule_information10 OKC_RULES_V.RULE_INFORMATION10%TYPE := OKC_API.G_MISS_CHAR,
85 rule_information11 OKC_RULES_V.RULE_INFORMATION11%TYPE := OKC_API.G_MISS_CHAR,
86 rule_information12 OKC_RULES_V.RULE_INFORMATION12%TYPE := OKC_API.G_MISS_CHAR,
87 rule_information13 OKC_RULES_V.RULE_INFORMATION13%TYPE := OKC_API.G_MISS_CHAR,
88 rule_information14 OKC_RULES_V.RULE_INFORMATION14%TYPE := OKC_API.G_MISS_CHAR,
89 rule_information15 OKC_RULES_V.RULE_INFORMATION15%TYPE := OKC_API.G_MISS_CHAR,
90 -- template_yn OKC_RULES_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
91 -- ans_set_jtot_object_code OKC_RULES_B.ans_set_jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
92 -- ans_set_jtot_object_id1 OKC_RULES_B.ans_set_jtot_object_id1%TYPE := OKC_API.G_MISS_CHAR,
93 -- ans_set_jtot_object_id2 OKC_RULES_B.ans_set_jtot_object_id2%TYPE := OKC_API.G_MISS_CHAR,
94 display_sequence NUMBER:= OKC_API.G_MISS_NUM
95 );
96
97 g_miss_rulv_rec rulv_rec_type;
98
99 TYPE rulv_tbl_type IS TABLE OF rulv_rec_type INDEX BY BINARY_INTEGER;
100 ----------------------------------------------------------------------------
101 -- Global Exception
102 ----------------------------------------------------------------------------
103 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
104
105 ----------------------------------------------------------------------------
106 -- Procedures and Functions
107 ------------------------------------------------------------------------------
108 ----------------------------------------------------------------------------------
109 -- Start of comments
110 --
111 -- Procedure Name : create_funding_chklst
112 -- Description : wrapper api for create funding checklists associated
113 -- with credit line contract ID
114 -- Business Rules :
115 -- Parameters :
116 -- Version : 1.0
117 -- End of comments
118 ----------------------------------------------------------------------------------
119 PROCEDURE create_funding_chklst(
120 p_api_version IN NUMBER
121 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_msg_count OUT NOCOPY NUMBER
124 ,x_msg_data OUT NOCOPY VARCHAR2
125 ,p_rulv_tbl IN rulv_tbl_type
126 ,x_rulv_tbl OUT NOCOPY rulv_tbl_type
127 );
128
129 ----------------------------------------------------------------------------------
130 -- Start of comments
131 --
132 -- Procedure Name : update_funding_chklst
133 -- Description : wrapper api for update funding checklists associated
134 -- with credit line contract ID
135 -- Business Rules :
136 -- Parameters :
137 -- Version : 1.0
138 -- End of comments
139 ----------------------------------------------------------------------------------
140 PROCEDURE update_funding_chklst(
141 p_api_version IN NUMBER
142 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
143 ,x_return_status OUT NOCOPY VARCHAR2
144 ,x_msg_count OUT NOCOPY NUMBER
145 ,x_msg_data OUT NOCOPY VARCHAR2
146 ,p_rulv_tbl IN rulv_tbl_type
147 ,x_rulv_tbl OUT NOCOPY rulv_tbl_type
148 );
149
150 ----------------------------------------------------------------------------------
151 -- Start of comments
152 --
153 -- Procedure Name : delete_funding_chklst
154 -- Description : wrapper api for delete funding checklists associated
155 -- with credit line contract ID
156 -- Business Rules :
157 -- Parameters :
158 -- Version : 1.0
159 -- End of comments
160 ----------------------------------------------------------------------------------
161 PROCEDURE delete_funding_chklst(
162 p_api_version IN NUMBER
163 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
164 ,x_return_status OUT NOCOPY VARCHAR2
165 ,x_msg_count OUT NOCOPY NUMBER
166 ,x_msg_data OUT NOCOPY VARCHAR2
167 ,p_rulv_tbl IN rulv_tbl_type
168 );
169
170 ----------------------------------------------------------------------------------
171 -- Start of comments
172 --
173 -- Procedure Name : approve_funding_request
174 -- Description : wrapper api for update_funding_header with status = 'APPROVE'
175 -- Business Rules :
176 -- Parameters :
177 -- Version : 1.0
178 -- End of comments
179 ----------------------------------------------------------------------------------
180 PROCEDURE approve_funding_request(
181 p_api_version IN NUMBER
182 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
183 ,x_return_status OUT NOCOPY VARCHAR2
184 ,x_msg_count OUT NOCOPY NUMBER
185 ,x_msg_data OUT NOCOPY VARCHAR2
186 ,p_fund_req_id IN okl_trx_ap_invoices_b.id%TYPE
187 );
188
189 ----------------------------------------------------------------------------------
190 -- Start of comments
191 --
192 -- Procedure Name : approve_funding_chklst
193 -- Description : set funding checklists status to "Active"
194 -- Business Rules :
195 -- Parameters :
196 -- Version : 1.0
197 -- End of comments
198 ----------------------------------------------------------------------------------
199 PROCEDURE approve_funding_chklst(
200 p_api_version IN NUMBER
201 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
202 ,x_return_status OUT NOCOPY VARCHAR2
203 ,x_msg_count OUT NOCOPY NUMBER
204 ,x_msg_data OUT NOCOPY VARCHAR2
205 ,p_rulv_rec IN rulv_rec_type
206 );
207
208 END OKL_FUNDING_CHECKLIST_PVT;