3: ----------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INTERNAL_BILLING_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INTERNAL_BILLING_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INTERNAL_BILLING_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
22: G_OKL_LLA_INVALID_DATE_FORMAT CONSTANT VARCHAR2(30) := 'OKL_LLA_INVALID_DATE_FORMAT';
23: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
24: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
25: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: ----------------------------------------------------------------------------
30: -- Data Structures
23: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
24: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
25: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: ----------------------------------------------------------------------------
30: -- Data Structures
31: ----------------------------------------------------------------------------
101: -- End of comments
102: ----------------------------------------------------------------------------------
103: PROCEDURE CREATE_BILLING_TRX(
104: p_api_version IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_taiv_rec IN okl_tai_pvt.taiv_rec_type
134: -- End of comments
135: ----------------------------------------------------------------------------------
136: PROCEDURE Get_Invoice_format(
137: p_api_version IN NUMBER
138: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
139: ,x_return_status OUT NOCOPY VARCHAR2
140: ,x_msg_count OUT NOCOPY NUMBER
141: ,x_msg_data OUT NOCOPY VARCHAR2
142: ,p_inf_id IN NUMBER DEFAULT NULL
162: -- End of comments
163:
164: PROCEDURE update_manual_invoice(
165: p_api_version IN NUMBER
166: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
167: ,x_return_status OUT NOCOPY VARCHAR2
168: ,x_msg_count OUT NOCOPY NUMBER
169: ,x_msg_data OUT NOCOPY VARCHAR2
170: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
177:
178:
179: PROCEDURE delete_manual_invoice(
180: p_api_version IN NUMBER
181: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_count OUT NOCOPY NUMBER
184: ,x_msg_data OUT NOCOPY VARCHAR2
185: ,p_taiv_id NUMBER
187: );
188:
189: PROCEDURE create_accounting_dist(
190: p_api_version IN NUMBER
191: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
192: ,x_return_status OUT NOCOPY VARCHAR2
193: ,x_msg_count OUT NOCOPY NUMBER
194: ,x_msg_data OUT NOCOPY VARCHAR2
195: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type