[Home] [Help]
PACKAGE: APPS.OKL_LA_SALES_TAX_PVT
Source
1 PACKAGE OKL_LA_SALES_TAX_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSTXS.pls 120.4 2007/05/24 22:31:17 rpillay ship $ */
3
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 g_api_type CONSTANT VARCHAR2(4) := '_PVT';
7 g_pkg_name CONSTANT VARCHAR2(30) := 'OKL_LA_SALES_TAX_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_BILLED CONSTANT VARCHAR2(30) := 'BILLED';
10 G_FINANCED CONSTANT VARCHAR2(30) := 'FINANCE';
11 G_CAPITALIZED CONSTANT VARCHAR2(30) := 'CAPITALIZE';
12 G_QA_SUCCESS CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_QA_SUCCESS';
13
14 ---------------------------------------------------------------------------
15 -----------------------------------------------------------------------------------
16 -- GLOBAL MESSAGE CONSTANTS
17 -----------------------------------------------------------------------------------
18 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
21 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
22 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
24 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
25 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
26 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
27 ------------------------------------------------------------------------------------
28 -- GLOBAL EXCEPTION
29 ------------------------------------------------------------------------------------
30 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
31 G_EXCEPTION_STOP_VALIDATION EXCEPTION;
32 -----------------------------------------------------------------------------------
33 -- GLOBAL VARIABLES
34 -----------------------------------------------------------------------------------
35 -- G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
36 G_API_VERSION CONSTANT NUMBER := 1.0;
37 G_SCOPE CONSTANT VARCHAR2(4) := '_PVT';
38
39 subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
40 subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
41 subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
42
43 subtype rgr_rec_type IS okl_rgrp_rules_process_pvt.rgr_rec_type;
44
45 PROCEDURE create_sales_tax_rules(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_chr_id IN NUMBER,
52 p_cle_id IN NUMBER);
53
54 PROCEDURE sync_contract_sales_tax(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_chr_id IN NUMBER);
61 /*
62 PROCEDURE sync_contract_sales_tax(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_chr_id IN NUMBER,
69 p_cle_id IN NUMBER);
70
71 PROCEDURE validate_rules(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_chr_id IN NUMBER,
78 p_rgr_rec IN rgr_rec_type);
79 */
80
81 -- Main Sales Tax API to be called LLA Processes
82 PROCEDURE process_sales_tax(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
85 p_commit IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
86 p_contract_id IN NUMBER,
87 p_transaction_type IN VARCHAR2,
88 p_transaction_id IN NUMBER DEFAULT NULL,
89 p_transaction_date IN DATE DEFAULT NULL,
90 p_rbk_contract_id IN NUMBER DEFAULT NULL,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2);
94
95 PROCEDURE check_sales_tax(
96 p_chr_id IN NUMBER,
97 x_return_status OUT NOCOPY VARCHAR2
98 );
99 --Bug#4658944 ramurt
100 PROCEDURE check_sales_tax_asset_rules(
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 NUMBER,
107 p_line_id IN NUMBER,
108 p_rule_group_id IN NUMBER,
109 p_rgr_rec IN rgr_rec_type);
110
111 -----------------------------------------------------------------------------
112 -- PROCEDURE validate_upfront_tax_fee
113 -----------------------------------------------------------------------------
114 -- Start of comments
115 --
116 -- Procedure Name : validate_upfront_tax_fee
117 -- Description : Procedure will be called to validate upfront tax fee and
118 -- payments during online and batch contract activation.
119 -- Business Rules :
120 -- Parameters : p_chr_id
121 -- Version : 1.0
122 -- History : 24-Apr-2007 rpillay Created
123 -- End of comments
124
125 PROCEDURE validate_upfront_tax_fee(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_chr_id IN VARCHAR2);
132
133
134 -----------------------------------------------------------------------------
135 -- PROCEDURE process_tax_override
136 -----------------------------------------------------------------------------
137 -- Start of comments
138 --
139 -- Procedure Name : process_tax_override
140 -- Description : Procedure will be called to update upfront tax fee and
141 -- covered asset lines, and the contract and process statuses
142 -- when upfront tax overrides are performed.
143 -- Business Rules :
144 -- Parameters : p_chr_id
145 -- p_transaction_id
146 -- Version : 1.0
147 -- History : 24-Apr-2007 rpillay Created
148 -- End of comments
149 PROCEDURE process_tax_override(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
152 p_chr_id IN NUMBER,
153 p_transaction_id IN NUMBER,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2
157 );
158
159 -----------------------------------------------------------------------------
160 -- PROCEDURE get_upfront_tax
161 -----------------------------------------------------------------------------
162 -- Start of comments
163 --
164 -- Procedure Name : get_upfront_tax
165 -- Description : Function will be called to fetch the upfront tax amount
166 -- that has been Capitalized, Billed or Financed.
167 -- Business Rules :
168 -- Parameters : p_chr_id
169 -- p_tax_treatment
170 -- Version : 1.0
171 -- History : 10-May-2007 rpillay Created
172 -- End of comments
173 FUNCTION get_upfront_tax(p_chr_id IN NUMBER,
174 p_tax_treatment IN VARCHAR2)
175 RETURN NUMBER;
176
177 END OKL_LA_SALES_TAX_PVT;