[Home] [Help]
PACKAGE: APPS.OKL_MISC_TRANS_PUB
Source
1 PACKAGE OKL_MISC_TRANS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPMSCS.pls 120.3 2005/10/30 04:26:08 appldev noship $ */
3
4
5 SUBTYPE tclv_rec_type IS OKL_MISC_TRANS_PVT.tclv_rec_type;
6
7
8
9 PROCEDURE CREATE_MISC_DSTR_LINE(p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 p_tclv_rec IN tclv_rec_type,
15 x_tclv_rec OUT NOCOPY tclv_rec_type);
16
17 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_MISC_TRANS_PUB' ;
18 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
19
20
21 -----------------------------------------------------------------------------
22 -- APPLICATION GLOBAL CONSTANTS
23 -----------------------------------------------------------------------------
24 G_API_VERSION CONSTANT NUMBER := 1;
25 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
26 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
27 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
28 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
29 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
30 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
31 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
32 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
33 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
34
35 -----------------------------------------------------------------------------
36 -- DATA STRUCTURES
37 -----------------------------------------------------------------------------
38 -----------------------------------------------------------------------------
39 -- PROGRAM UNITS
40 -----------------------------------------------------------------------------
41 PROCEDURE create_misc_transaction(p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_jrnl_hdr_rec IN OKL_MISC_TRANS_PVT.jrnl_hdr_rec_type,
47 p_jrnl_line_tbl IN OKL_MISC_TRANS_PVT.jrnl_line_tbl_type,
48 x_jrnl_hdr_rec OUT NOCOPY OKL_MISC_TRANS_PVT.jrnl_hdr_rec_type);
49
50 PROCEDURE update_misc_transaction(p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_jrnl_hdr_rec IN OKL_MISC_TRANS_PVT.jrnl_hdr_rec_type,
56 p_jrnl_line_tbl IN OKL_MISC_TRANS_PVT.jrnl_line_tbl_type);
57
58
59
60 END OKL_MISC_TRANS_PUB;