[Home] [Help]
PACKAGE: APPS.OKL_LESSEE_AS_VENDOR_PVT
Source
1 PACKAGE OKL_LESSEE_AS_VENDOR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRLVPS.pls 115.0 2003/10/09 00:48:56 cklee noship $ */
3 ----------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ----------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LESSEE_AS_VENDOR_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
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLCODE';
18
19 G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
21 G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
22 G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
24
25 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
26 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
27
28 G_UPDATE_MODE CONSTANT VARCHAR2(30) := 'UPDATE_MODE';
29 G_INSERT_MODE CONSTANT VARCHAR2(30) := 'INSERT_MODE';
30
31
32 ----------------------------------------------------------------------------
33 -- Data Structures
34 ----------------------------------------------------------------------------
35 subtype ppydv_rec_type is OKL_PYD_pvt.ppydv_rec_type;
36 subtype ppydv_tbl_type is OKL_PYD_pvt.ppydv_tbl_type;
37
38 ----------------------------------------------------------------------------
39 -- Global Exception
40 ----------------------------------------------------------------------------
41 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
42
43 ----------------------------------------------------------------------------
44 -- Procedures and Functions
45 ------------------------------------------------------------------------------
46 ----------------------------------------------------------------------------------
47 -- Start of comments
48 --
49 -- Procedure Name : create_lessee_as_vendor
50 -- Description : wrapper api for create party payment details
51 -- Business Rules :
52 -- Parameters :
53 -- Version : 1.0
54 -- End of comments
55 ----------------------------------------------------------------------------------
56 PROCEDURE create_lessee_as_vendor(
57 p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE
63 ,p_ppydv_rec IN ppydv_rec_type
64 ,x_ppydv_rec OUT NOCOPY ppydv_rec_type
65 );
66
67 ----------------------------------------------------------------------------------
68 -- Start of comments
69 --
70 -- Procedure Name : update_lessee_as_vendor
71 -- Description : wrapper api for update party payment details
72 -- Business Rules :
73 -- Parameters :
74 -- Version : 1.0
75 -- End of comments
76 ----------------------------------------------------------------------------------
77 PROCEDURE update_lessee_as_vendor(
78 p_api_version IN NUMBER
79 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 ,p_ppydv_rec IN ppydv_rec_type
84 ,x_ppydv_rec OUT NOCOPY ppydv_rec_type
85 );
86
87
88 END OKL_LESSEE_AS_VENDOR_PVT;