[Home] [Help]
PACKAGE: APPS.OKL_ACCRUAL_DEPRN_ADJ_PVT
Source
1 PACKAGE OKL_ACCRUAL_DEPRN_ADJ_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRADAS.pls 115.4 2004/02/19 01:22:23 sgiyer noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7
8 TYPE asset_deprn_rec_type IS RECORD
9 (category_name VARCHAR2(2000),
10 period_name VARCHAR2(2000),
11 deprn_amount NUMBER);
12
13
14 TYPE asset_deprn_tbl_type IS TABLE OF asset_deprn_rec_type INDEX BY BINARY_INTEGER;
15
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL MESSAGE CONSTANTS
19 ---------------------------------------------------------------------------
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(2000) := OKL_API.G_COL_NAME_TOKEN;
21 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(2000) := 'OKL_UNEXPECTED_ERROR';
22 G_SQLERRM_TOKEN CONSTANT VARCHAR2(2000) := 'SQLerrm';
23 G_SQLCODE_TOKEN CONSTANT VARCHAR2(2000) := 'SQLcode';
24 G_REQUIRED_VALUE CONSTANT VARCHAR2(2000) := 'OKL_REQUIRED_VALUE';
25 G_NO_MATCHING_RECORD CONSTANT VARCHAR2(2000) := 'OKL_LLA_NO_MATCHING_RECORD';
26 G_CONTRACT_NUMBER_TOKEN CONSTANT VARCHAR2(2000) := 'CONTRACT_NUMBER';
27 G_INVALID_VALUE CONSTANT VARCHAR2(2000) := 'OKL_CONTRACTS_INVALID_VALUE';
28
29 ---------------------------------------------------------------------------
30 -- GLOBAL EXCEPTION
31 ---------------------------------------------------------------------------
32
33 ---------------------------------------------------------------------------
34
35 ---------------------------------------------------------------------------
36 -- GLOBAL VARIABLES
37 ---------------------------------------------------------------------------
38 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCRUAL_DEPR_ADJ_PVT';
39 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
40 ---------------------------------------------------------------------------
41 -- Procedures and Functions
42 ---------------------------------------------------------------------------
43
44 FUNCTION get_period_name(p_date IN DATE) RETURN VARCHAR2;
45
46 FUNCTION get_category_name(p_category_id IN NUMBER) RETURN VARCHAR2;
47
48 FUNCTION SUBMIT_DEPRN_ADJUSTMENT(
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_api_version IN NUMBER,
53 p_batch_name IN VARCHAR2,
54 p_date_from IN DATE,
55 p_date_to IN DATE ) RETURN NUMBER;
56
57
58 PROCEDURE ADJUST_DEPRECIATION (errbuf OUT NOCOPY VARCHAR2
59 ,retcode OUT NOCOPY NUMBER
60 ,p_batch_name IN VARCHAR2
61 ,p_period_from IN VARCHAR2
62 ,p_period_to IN VARCHAR2);
63
64
65 END OKL_ACCRUAL_DEPRN_ADJ_PVT;