[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_TAX
Source
1 PACKAGE OKL_PROCESS_TAX AS
2 /* $Header: OKLRTAXS.pls 120.4 2006/02/07 21:26:17 sechawla noship $ */
3
4 /*=======================================================================+
5 | Declare Global Variables
6 +=======================================================================*/
7
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PROCESS_TAX';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12 G_INVALID_VALUE1 CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
13 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18
19
20 /*=======================================================================+
21 | Declare PUBLIC Data Types and Variables
22 +=======================================================================*/
23
24 TYPE okl_tax_rec_type IS RECORD (
25 contract_id NUMBER,
26 trx_id NUMBER,
27 trx_date DATE,
28 line_type VARCHAR2(50),
29 date_from DATE,
30 date_to DATE);
31
32 TYPE okl_tax_tbl_type IS TABLE OF okl_tax_rec_type INDEX BY BINARY_INTEGER;
33
34
35
36
37
38 /*========================================================================
39 | PUBLIC PROCEDURE Create_Tax_Schedule
40 |
41 | DESCRIPTION
42 | This procedure will query all streams for a contract, pass the stream amounts to
43 | the Global Tax Engine for calculating tax for each of the amounts and create tax schedules in
44 | OKL_TAX_LINES
45 |
46 | PSEUDO CODE/LOGIC
47 |
48 | PARAMETERS
49 | p_contract_id IN Contract Identifier
50 | p_request_date IN Schedule Request Date
51 | p_date_from IN Date From
52 | p_date_to IN Date To
53 | x_return_status OUT Return Status
54 | KNOWN ISSUES
55 |
56 |
57 | NOTES
58 | Any interesting aspect of the code in the package body which needs
59 | to be stated.
60 |
61 | MODIFICATION HISTORY
62 | Date Author Description of Changes
63 | 24-MAY-2004 RKUTTIYA Created
64 |
65 *=======================================================================*/
66
67
68 PROCEDURE Create_Tax_Schedule( p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_tax_in_rec IN okl_tax_rec_type);
74
75 PROCEDURE Create_Tax_Schedule( p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_tax_in_tbl IN okl_tax_tbl_type);
81
82 END OKL_PROCESS_TAX;
83
84