[Home] [Help]
PACKAGE: APPS.OKL_GENERATE_ACCRUALS_PUB
Source
1 PACKAGE OKL_GENERATE_ACCRUALS_PUB AS
2 /* $Header: OKLPACRS.pls 120.5.12010000.3 2008/10/20 19:40:45 apaul ship $ */
3
4 SUBTYPE accrual_rec_type IS OKL_GENERATE_ACCRUALS_PVT.accrual_rec_type;
5 SUBTYPE acceleration_rec_type IS OKL_GENERATE_ACCRUALS_PVT.acceleration_rec_type;
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GENERATE_ACCRUALS_PUB';
11 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
12 ---------------------------------------------------------------------------
13 -- Procedures and Functions
14 ---------------------------------------------------------------------------
15 FUNCTION SUBMIT_ACCRUALS(
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2,
19 p_api_version IN NUMBER,
20 p_accrual_date IN DATE,
21 p_batch_name IN VARCHAR2 ) RETURN NUMBER;
22
23
24 FUNCTION CALCULATE_CNTRCT_REC(p_ctr_id IN OKC_K_HEADERS_B.id%TYPE) RETURN NUMBER;
25
26 PROCEDURE VALIDATE_ACCRUAL_RULE(x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 ,x_result OUT NOCOPY VARCHAR2
30 ,p_ctr_id IN OKL_K_HEADERS.ID%TYPE);
31
32 PROCEDURE CATCHUP_ACCRUALS (
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2,
35 p_catchup_rec IN accrual_rec_type,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
40 x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
41 p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY'); --MGAAP 7263041);
42
43 PROCEDURE REVERSE_ACCRUALS (
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2,
46 p_reverse_rec IN accrual_rec_type,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_tcnv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type,
51 x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type);
52
53 PROCEDURE REVERSE_ACCRUALS (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_khr_id IN NUMBER,
60 p_reversal_date IN DATE,
61 p_accounting_date IN DATE,
62 p_reverse_from IN DATE,
63 p_reverse_to IN DATE,
64 p_tcn_type IN VARCHAR2);
65
66 PROCEDURE REVERSE_ALL_ACCRUALS (
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2,
69 p_khr_id IN NUMBER,
70 p_reverse_date IN DATE,
71 p_description IN VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75
76 PROCEDURE ACCELERATE_ACCRUALS (
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_acceleration_rec IN acceleration_rec_type,
83 p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY', --MGAAP 7263041
84 x_trx_number OUT NOCOPY OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE); --MGAAP 7263041
85
86
87 END OKL_GENERATE_ACCRUALS_PUB;