1 Package okl_contract_book_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLRBKGS.pls 120.6 2010/07/23 18:05:24 smadhava ship $ */
3
4 -- Global variables for user hooks
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_BOOK_PVT';
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7
8 SUCCESS_MESSAGE EXCEPTION;
9
10 Cursor old_csr( chrId NUMBER) IS
11 Select chr.ORIG_SYSTEM_SOURCE_CODE,
12 chr.ORIG_SYSTEM_ID1,
13 chr.ORIG_SYSTEM_REFERENCE1,
14 khr.deal_type
15 from okc_k_headers_v chr,
16 okl_k_headers khr
17 where khr.id = chr.id
18 and chr.id = chrId;
19
20 Cursor rbk_csr( origId Number, rbkId NUMBER) IS
21 SELECT DATE_TRANSACTION_OCCURRED
22 FROM okl_trx_contracts trx,
23 okl_trx_types_tl trx_type
24 WHERE trx.khr_id_old = origId
25 AND trx.khr_id_new = rbkId
26 AND trx.tsu_code = 'ENTERED'
27 AND trx.tcn_type = 'TRBK'
28 AND trx.rbr_code IS NOT NULL
29 AND trx_type.NAME = 'Rebook'
30 AND trx_type.LANGUAGE = 'US'
31 AND trx.try_id = trx_type.id;
32
33
34 Procedure execute_qa_check_list(
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_qcl_id IN NUMBER,
41 p_chr_id IN NUMBER,
42 p_call_mode IN VARCHAR2 DEFAULT 'ACTUAL',
43 x_msg_tbl OUT NOCOPY OKL_QA_CHECK_PUB.msg_tbl_type);
44
45 Procedure generate_streams(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 p_chr_id IN VARCHAR2,
49 p_generation_context IN VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 x_trx_number OUT NOCOPY NUMBER,
54 x_trx_status OUT NOCOPY VARCHAR2);
55
56 PROCEDURE generate_journal_entries(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
59 p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
60 p_contract_id IN NUMBER,
61 p_transaction_type IN VARCHAR2,
62 p_draft_yn IN VARCHAR2 DEFAULT Okc_Api.G_TRUE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67
68 Procedure submit_for_approval(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_chr_id IN VARCHAR2);
75
76 -------------------------------------------------
77 --Bug# 2566822 : Approval WF/AME integration
78 -- This api will be called by the WF/AME to
79 -- do post approval tasks after the contract has
80 -- been approved
81 --------------------------------------------------
82 Procedure post_approval_process(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_chr_id IN VARCHAR2,
89 p_call_mode IN VARCHAR2 DEFAULT NULL,
90 x_process_status OUT NOCOPY VARCHAR2 -- Bug#9873432
91 );
92
93 -------------------------------------------------
94 --Bug# 2566822 : Approval WF/AME integration
95 -- This api will be called by mass rebook and k import
96 -- to approve the contract directly irrecpective
97 -- of the profile option value for contract approval
98 -- path
99 --------------------------------------------------
100 Procedure Approve_Contract(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_chr_id IN VARCHAR2);
107
108
109 Procedure activate_contract(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_chr_id IN VARCHAR2);
116
117 ----------------------------------------------------------------
118 --Bug# 3556674 : validate contract api to be called as an api to
119 -- run qa check list
120 -----------------------------------------------------------------
121 Procedure validate_contract(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_qcl_id IN NUMBER,
128 p_chr_id IN NUMBER,
129 p_call_mode IN VARCHAR2 DEFAULT 'ACTUAL',
130 x_msg_tbl OUT NOCOPY OKL_QA_CHECK_PUB.msg_tbl_type);
131
132 ----------------------------------------------------------------
133 --Bug# 3556674 : generate_draft_accounting to be called as an api to
134 -- generate draft 'Booking' accounting entries
135 -----------------------------------------------------------------
136 Procedure generate_draft_accounting(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_chr_id IN NUMBER);
143
144 -----------------------------------------------------------------------------
145 -- PROCEDURE calculate_upfront_tax
146 -----------------------------------------------------------------------------
147 -- Start of comments
148 --
149 -- Procedure Name : calculate_upfront_tax
150 -- Description : Procedure will be called to calculate upfront tax during
151 -- online and batch contract activation.
152 -- Business Rules :
153 -- Parameters : p_chr_id
154 -- Version : 1.0
155 -- History : 24-Apr-2007 rpillay Created
156 -- End of comments
157
158 PROCEDURE calculate_upfront_tax(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_chr_id IN VARCHAR2,
165 x_process_status OUT NOCOPY VARCHAR2);
166
167
168 -----------------------------------------------------------------------------
169 -- PROCEDURE approve_activate_contract
170 -----------------------------------------------------------------------------
171 -- Start of comments
172 --
173 -- Procedure Name : approve_activate_contract
174 -- Description : Procedure will be called from Submit button on Contract Booking UI and
175 -- from OKL_CONTRACT_BOOK_PVT.post_approval_process and Batch booking.
176 -- This procedure will submit the contract for approval.
177 -- If the contract has been approved, this will process contract activation
178 -- Business Rules :
179 -- Parameters : p_chr_id
180 -- Version : 1.0
181 -- History : 24-Apr-2007 rpillay Created
182 -- End of comments
183
184 PROCEDURE approve_activate_contract(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_chr_id IN VARCHAR2,
191 x_process_status OUT NOCOPY VARCHAR2);
192
193 End okl_contract_book_PVT;
194