DBA Data[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;