[Home] [Help]
PACKAGE: APPS.OKL_MULTI_GAAP_PVT
Source
1 PACKAGE OKL_MULTI_GAAP_PVT AS
2 /* $Header: OKLRGAPS.pls 120.5 2006/07/11 09:46:31 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ae_lines_rec_type IS RECORD (ccid OKL_AE_TMPT_LNES.code_combination_id%TYPE,
7 line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE,
8 crd_code OKL_AE_TMPT_LNES.crd_code%TYPE);
9
10 TYPE asset_deprn_rec_type IS RECORD
11 (category_name VARCHAR2(2000),
12 accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE,
13 deprn_amount NUMBER);
14
15 TYPE rep_prd_summary_rec_type IS RECORD
16 (product_name OKL_PRODUCTS_V.name%TYPE,
17 stream_type OKL_STRM_TYPE_V.name%TYPE,
18 currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE,
19 accrual_activity OKL_TRX_CONTRACTS.accrual_activity%TYPE,
20 total_amount NUMBER);
21
22 TYPE asset_deprn_tbl_type IS TABLE OF asset_deprn_rec_type INDEX BY BINARY_INTEGER;
23
24 TYPE ae_lines_tbl_type IS TABLE OF ae_lines_rec_type INDEX BY BINARY_INTEGER;
25
26 TYPE rep_prd_summary_tbl_type IS TABLE OF rep_prd_summary_rec_type INDEX BY BINARY_INTEGER;
27
28 ---------------------------------------------------------------------------
29 -- GLOBAL MESSAGE CONSTANTS
30 ---------------------------------------------------------------------------
31 G_COL_NAME_TOKEN CONSTANT VARCHAR2(2000) := OKL_API.G_COL_NAME_TOKEN;
32 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(2000) := 'OKL_UNEXPECTED_ERROR';
33 G_SQLERRM_TOKEN CONSTANT VARCHAR2(2000) := 'SQLerrm';
34 G_SQLCODE_TOKEN CONSTANT VARCHAR2(2000) := 'SQLcode';
35 G_REQUIRED_VALUE CONSTANT VARCHAR2(2000) := 'OKL_REQUIRED_VALUE';
36 G_NO_MATCHING_RECORD CONSTANT VARCHAR2(2000) := 'OKL_LLA_NO_MATCHING_RECORD';
37 G_CONTRACT_NUMBER_TOKEN CONSTANT VARCHAR2(2000) := 'CONTRACT_NUMBER';
38 G_INVALID_VALUE CONSTANT VARCHAR2(2000) := 'OKL_CONTRACTS_INVALID_VALUE';
39
40 ---------------------------------------------------------------------------
41 -- GLOBAL EXCEPTION
42 ---------------------------------------------------------------------------
43
44
45 ---------------------------------------------------------------------------
46
47 ---------------------------------------------------------------------------
48 -- GLOBAL VARIABLES
49 ---------------------------------------------------------------------------
50 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_MULTI_GAAP_PVT';
51 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
52 ---------------------------------------------------------------------------
53 -- Procedures and Functions
54 ---------------------------------------------------------------------------
55
56 FUNCTION SUBMIT_MULTI_GAAP(
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_api_version IN NUMBER,
61 p_date_from IN DATE,
62 p_date_to IN DATE,
63 p_batch_name IN VARCHAR2 ) RETURN NUMBER;
64
65 FUNCTION CHECK_MULTI_GAAP(p_khr_id IN NUMBER) RETURN VARCHAR2;
66
67
68 PROCEDURE MULTI_GAAP_SUPPORT(errbuf OUT NOCOPY VARCHAR2
69 ,retcode OUT NOCOPY NUMBER
70 ,p_period_from IN VARCHAR2
71 ,p_period_to IN VARCHAR2
72 ,p_batch_name IN VARCHAR2);
73
74 FUNCTION get_category_name(p_category_id IN NUMBER) RETURN VARCHAR2;
75
76 END OKL_MULTI_GAAP_PVT;