[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_REBOOK_PVT
Source
1 PACKAGE OKL_CONTRACT_REBOOK_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRBKS.pls 120.5.12010000.2 2008/10/20 18:37:56 apaul ship $*/
3
4 G_INVALID_VALUE CONSTANT VARCHAR2(1000) := 'OKL_INVALID_VALUE';
5 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(1000) := 'OKL_UNEXPECTED_ERROR';
6 G_LLA_CHR_ID CONSTANT VARCHAR2(1000) := 'OKL_LLA_CHR_ID';
7 G_LLA_NO_ORIG_REFERENCE CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_ORIG_REFERENCE';
8 G_LLA_NO_STREAM CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_STREAM';
9 G_LLA_NO_STREAM_ELEMENT CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_STREAM_ELEMENT';
10
11 subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
12
13 PROCEDURE Report_Error(
14 x_msg_count OUT NOCOPY NUMBER,
15 x_msg_data OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE sync_rebook_orig_contract(
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
25 );
26
27 PROCEDURE create_txn_contract(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
34 p_rebook_reason_code IN VARCHAR2,
35 p_rebook_description IN VARCHAR2,
36 p_trx_date IN DATE,
37 x_tcnv_rec OUT NOCOPY tcnv_rec_type,
38 x_rebook_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
39 );
40
41 PROCEDURE sync_rebook_stream(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
48 p_stream_status IN OKL_STREAMS.SAY_CODE%TYPE
49 );
50
51 PROCEDURE create_rebook_contract(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
58 x_rebook_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE,
59 p_rbk_date IN DATE DEFAULT NULL
60 );
61
62 --Bug# 4212626: start
63 PROCEDURE link_streams(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_khr_id IN NUMBER
70 );
71
72 PROCEDURE create_billing_adjustment(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_rbk_khr_id IN NUMBER,
79 p_orig_khr_id IN NUMBER,
80 p_trx_id IN NUMBER,
81 p_trx_date IN DATE
82 );
83
84
85 -- dedey, Bug#4264314
86 /*
87 *
88 PROCEDURE create_accrual_adjustment(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_rbk_khr_id IN NUMBER,
95 p_orig_khr_id IN NUMBER,
96 p_trx_id IN NUMBER,
97 p_trx_date IN DATE
98 );
99 --Bug# 4212626: end
100 */
101
102 --Added new input parameters p_trx_tbl_code and p_trx_type by for Bug# 6344223
103 PROCEDURE calc_accrual_adjustment(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_rbk_khr_id IN NUMBER,
110 p_orig_khr_id IN NUMBER,
111 p_trx_id IN NUMBER,
112 p_trx_date IN DATE,
113 x_accrual_rec OUT NOCOPY OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type,
114 x_stream_tbl OUT NOCOPY OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type,
115 p_trx_tbl_code IN VARCHAR2 DEFAULT 'TCN',
116 p_trx_type IN VARCHAR2 DEFAULT 'CRB'
117 );
118 -- dedey, Bug#4264314
119
120 -- Bug# 4775555: Start
121 PROCEDURE create_inv_disb_adjustment(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_orig_khr_id IN NUMBER
128 ) ;
129
130 PROCEDURE link_inv_accrual_streams(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_khr_id IN NUMBER
137 ) ;
138
139 --Added new input parameters p_trx_tbl_code and p_trx_type for Bug# 6344223
140 PROCEDURE calc_inv_acc_adjustment(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_orig_khr_id IN NUMBER,
147 p_trx_id IN NUMBER,
148 p_trx_date IN DATE,
149 x_inv_accrual_rec OUT NOCOPY OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type,
150 x_inv_stream_tbl OUT NOCOPY OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type,
151 p_trx_tbl_code IN VARCHAR2 DEFAULT 'TCN',
152 p_trx_type IN VARCHAR2 DEFAULT 'CRB',
153 p_product_id IN NUMBER DEFAULT NULL -- MGAAP
154 ) ;
155 -- Bug# 4775555: End
156
157 END OKL_CONTRACT_REBOOK_PVT;