12: */
13: ------------------------------------------------------------------------------
14: -- Global Variables
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_ADJST_PUB';
16: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
17: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
20:
36: * @rep:lifecycle active
37: */
38:
39: PROCEDURE create_adjustments_pub ( p_api_version IN NUMBER
40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY NUMBER
43: ,x_msg_data OUT NOCOPY VARCHAR2
44: );
58: * @rep:scope internal
59: * @rep:lifecycle active
60: */
61: PROCEDURE iex_create_adjustments_pub( p_api_version IN NUMBER
62: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
63: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE
64: ,p_psl_id IN NUMBER
65: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE
66: ,x_new_adj_id OUT NOCOPY NUMBER
59: * @rep:lifecycle active
60: */
61: PROCEDURE iex_create_adjustments_pub( p_api_version IN NUMBER
62: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
63: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE
64: ,p_psl_id IN NUMBER
65: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE
66: ,x_new_adj_id OUT NOCOPY NUMBER
67: ,x_return_status OUT NOCOPY VARCHAR2
61: PROCEDURE iex_create_adjustments_pub( p_api_version IN NUMBER
62: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
63: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE
64: ,p_psl_id IN NUMBER
65: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE
66: ,x_new_adj_id OUT NOCOPY NUMBER
67: ,x_return_status OUT NOCOPY VARCHAR2
68: ,x_msg_count OUT NOCOPY NUMBER
69: ,x_msg_data OUT NOCOPY VARCHAR2