[Home] [Help]
PACKAGE: APPS.OKL_ITM_CAT_RV_PRCS_PUB
Source
1 PACKAGE OKL_ITM_CAT_RV_PRCS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPICPS.pls 120.2 2005/10/30 03:32:01 appldev noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE SPECIFIC CONSTANTS
6 -----------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_ITM_CAT_RV_PRCS_PUB';
8
9 -----------------------------------------------------------------------------
10 -- APPLICATION GLOBAL CONSTANTS
11 -----------------------------------------------------------------------------
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
13 G_API_VERSION CONSTANT NUMBER := 1;
14 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
17 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
18 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
20 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
23 G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
24
25 ---------------------------------------------------------------------------
26 -- DATA STRUCTURES
27 ---------------------------------------------------------------------------
28 subtype icpv_rec_type is okl_icp_pvt.icpv_rec_type;
29 subtype icpv_tbl_type is okl_icp_pvt.icpv_tbl_type;
30
31 ---------------------------------------------------------------------------
32 -- PROGRAM UNITS
33 ---------------------------------------------------------------------------
34 PROCEDURE insert_itm_cat_rv_prcs(
35 p_api_version IN NUMBER
36 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2
40 ,p_icpv_tbl IN icpv_tbl_type
41 ,x_icpv_tbl OUT NOCOPY icpv_tbl_type);
42
43 PROCEDURE insert_itm_cat_rv_prcs(
44 p_api_version IN NUMBER
45 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 ,p_icpv_rec IN icpv_rec_type
50 ,x_icpv_rec OUT NOCOPY icpv_rec_type);
51
52 PROCEDURE lock_itm_cat_rv_prcs(
53 p_api_version IN NUMBER
54 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 ,p_icpv_tbl IN icpv_tbl_type);
59
60 PROCEDURE lock_itm_cat_rv_prcs(
61 p_api_version IN NUMBER
62 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 ,p_icpv_rec IN icpv_rec_type);
67
68 PROCEDURE update_itm_cat_rv_prcs(
69 p_api_version IN NUMBER
70 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
71 ,x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 ,x_msg_data OUT NOCOPY VARCHAR2
74 ,p_icpv_tbl IN icpv_tbl_type
75 ,x_icpv_tbl OUT NOCOPY icpv_tbl_type);
76
77 PROCEDURE update_itm_cat_rv_prcs(
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_icpv_rec IN icpv_rec_type
84 ,x_icpv_rec OUT NOCOPY icpv_rec_type);
85
86 PROCEDURE delete_itm_cat_rv_prcs(
87 p_api_version IN NUMBER
88 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2
92 ,p_icpv_tbl IN icpv_tbl_type);
93
94 PROCEDURE delete_itm_cat_rv_prcs(
95 p_api_version IN NUMBER
96 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
97 ,x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2
100 ,p_icpv_rec IN icpv_rec_type);
101
102 PROCEDURE validate_itm_cat_rv_prcs(
103 p_api_version IN NUMBER
104 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 ,p_icpv_tbl IN icpv_tbl_type);
109
110 PROCEDURE validate_itm_cat_rv_prcs(
111 p_api_version IN NUMBER
112 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_count OUT NOCOPY NUMBER
115 ,x_msg_data OUT NOCOPY VARCHAR2
116 ,p_icpv_rec IN icpv_rec_type);
117
118 END okl_itm_cat_rv_prcs_pub;