1 Package okl_contract_book_PVT as
2 /* $Header: OKLRBKGS.pls 120.5 2007/05/14 18:30:47 rpillay 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
91 -------------------------------------------------
92 --Bug# 2566822 : Approval WF/AME integration
93 -- This api will be called by mass rebook and k import
94 -- to approve the contract directly irrecpective
95 -- of the profile option value for contract approval
96 -- path
97 --------------------------------------------------
98 Procedure Approve_Contract(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_chr_id IN VARCHAR2);
105
106
107 Procedure activate_contract(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_chr_id IN VARCHAR2);
114
115 ----------------------------------------------------------------
116 --Bug# 3556674 : validate contract api to be called as an api to
117 -- run qa check list
118 -----------------------------------------------------------------
119 Procedure validate_contract(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_qcl_id IN NUMBER,
126 p_chr_id IN NUMBER,
127 p_call_mode IN VARCHAR2 DEFAULT 'ACTUAL',
128 x_msg_tbl OUT NOCOPY OKL_QA_CHECK_PUB.msg_tbl_type);
129
130 ----------------------------------------------------------------
131 --Bug# 3556674 : generate_draft_accounting to be called as an api to
132 -- generate draft 'Booking' accounting entries
133 -----------------------------------------------------------------
134 Procedure generate_draft_accounting(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_chr_id IN NUMBER);
141
142 -----------------------------------------------------------------------------
143 -- PROCEDURE calculate_upfront_tax
144 -----------------------------------------------------------------------------
145 -- Start of comments
146 --
147 -- Procedure Name : calculate_upfront_tax
148 -- Description : Procedure will be called to calculate upfront tax during
149 -- online and batch contract activation.
150 -- Business Rules :
151 -- Parameters : p_chr_id
152 -- Version : 1.0
153 -- History : 24-Apr-2007 rpillay Created
154 -- End of comments
155
156 PROCEDURE calculate_upfront_tax(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_chr_id IN VARCHAR2,
163 x_process_status OUT NOCOPY VARCHAR2);
164
165
166 -----------------------------------------------------------------------------
167 -- PROCEDURE approve_activate_contract
168 -----------------------------------------------------------------------------
169 -- Start of comments
170 --
171 -- Procedure Name : approve_activate_contract
172 -- Description : Procedure will be called from Submit button on Contract Booking UI and
173 -- from OKL_CONTRACT_BOOK_PVT.post_approval_process and Batch booking.
174 -- This procedure will submit the contract for approval.
175 -- If the contract has been approved, this will process contract activation
176 -- Business Rules :
177 -- Parameters : p_chr_id
178 -- Version : 1.0
179 -- History : 24-Apr-2007 rpillay Created
180 -- End of comments
181
182 PROCEDURE approve_activate_contract(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_chr_id IN VARCHAR2,
189 x_process_status OUT NOCOPY VARCHAR2);
190
191 End okl_contract_book_PVT;
192