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
133: -- End of comments
134: ----------------------------------------------------------------------------------
135: PROCEDURE Get_Invoice_format(
136: p_api_version IN NUMBER
137: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
138: ,x_return_status OUT NOCOPY VARCHAR2
139: ,x_msg_count OUT NOCOPY NUMBER
140: ,x_msg_data OUT NOCOPY VARCHAR2
141: ,p_inf_id IN NUMBER DEFAULT NULL
161: -- End of comments
162:
163: PROCEDURE update_manual_invoice(
164: p_api_version IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
166: ,x_return_status OUT NOCOPY VARCHAR2
167: ,x_msg_count OUT NOCOPY NUMBER
168: ,x_msg_data OUT NOCOPY VARCHAR2
169: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
176:
177:
178: PROCEDURE delete_manual_invoice(
179: p_api_version IN NUMBER
180: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
181: ,x_return_status OUT NOCOPY VARCHAR2
182: ,x_msg_count OUT NOCOPY NUMBER
183: ,x_msg_data OUT NOCOPY VARCHAR2
184: ,p_taiv_id NUMBER