1 PACKAGE OKL_ACCRUAL_SEC_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRASCS.pls 120.6.12020000.2 2012/08/07 11:19:42 bkatraga ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7
8 ---------------------------------------------------------------------------
9 -- GLOBAL MESSAGE CONSTANTS
10 ---------------------------------------------------------------------------
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
12 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
14 G_CONTRACT_NUMBER_TOKEN CONSTANT VARCHAR2(200) := 'CONTRACT_NUMBER';
15
16 ---------------------------------------------------------------------------
17 -- GLOBAL VARIABLES
18 ---------------------------------------------------------------------------
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCRUAL_SEC_PVT';
20 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
21 ---------------------------------------------------------------------------
22 -- Procedures and Functions
23 ---------------------------------------------------------------------------
24
25 TYPE p_line_id_rec_type IS RECORD(
26 id OKC_K_LINES_B.ID%TYPE);
27
28 TYPE p_line_id_tbl_type IS TABLE OF p_line_id_rec_type
29 INDEX BY BINARY_INTEGER;
30
31 TYPE p_accrual_adjustment_rec_type IS RECORD(
32 line_id OKC_K_LINES_B.ID%TYPE,
33 sty_id OKL_STRM_TYPE_B.ID%TYPE,
34 amount NUMBER);
35
36 TYPE p_accrual_adjustment_tbl_type IS TABLE OF p_accrual_adjustment_rec_type
37 INDEX BY BINARY_INTEGER;
38
39
40 PROCEDURE CREATE_STREAMS(p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_khr_id IN NUMBER,
46 --sosharma added Bug 6691554, Added for generating streams on transient pool submission
47 p_mode IN VARCHAR2 DEFAULT NULL);
48
49 PROCEDURE CANCEL_STREAMS(p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_khr_id IN NUMBER,
55 p_cancel_date IN DATE);
56
57 PROCEDURE DELETE_STREAMS(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_khr_id IN NUMBER,
64 p_cancel_date IN DATE);
65
66 /* Commented as TA requirement changed
67 PROCEDURE Create_Adjustment_Streams(
68 p_api_version IN NUMBER
69 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 ,p_contract_id IN NUMBER
74 ,p_line_id_tbl IN p_line_id_tbl_type
75 ,p_adjustment_date IN DATE);
76 */
77 PROCEDURE Get_Accrual_Adjustment(
78 p_api_version IN NUMBER
79 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 ,p_contract_id IN NUMBER
84 ,p_line_id_tbl IN p_line_id_tbl_type
85 ,p_adjustment_date IN DATE
86 ,x_accrual_adjustment_tbl OUT NOCOPY p_accrual_adjustment_tbl_type
87 ,p_product_id IN NUMBER DEFAULT NULL); -- MGAAP
88
89 END OKL_ACCRUAL_SEC_PVT;