[Home] [Help]
PACKAGE: APPS.OKL_RES_PVT
Source
1 PACKAGE OKL_RES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSRESS.pls 120.0 2005/07/08 14:26:23 smadhava noship $ */
3 --------------------------------------------------------------------------------
4 --GLOBAL DATASTRUCTURES
5 --------------------------------------------------------------------------------
6 TYPE okl_res_rec IS RECORD (
7 RESI_CAT_OBJECT_ID NUMBER ,
8 OBJECT_VERSION_NUMBER NUMBER ,
9 RESI_CATEGORY_SET_ID NUMBER ,
10 CREATED_BY NUMBER ,
11 CREATION_DATE OKL_FE_RESI_CAT_OBJECTS.CREATION_DATE%TYPE ,
12 LAST_UPDATED_BY NUMBER ,
13 LAST_UPDATE_DATE OKL_FE_RESI_CAT_OBJECTS.LAST_UPDATE_DATE%TYPE ,
14 LAST_UPDATE_LOGIN NUMBER ,
15 INVENTORY_ITEM_ID NUMBER ,
16 ORGANIZATION_ID NUMBER ,
17 CATEGORY_ID NUMBER ,
18 CATEGORY_SET_ID NUMBER );
19
20 TYPE okl_res_tbl IS TABLE OF okl_res_rec
21 INDEX BY BINARY_INTEGER;
22
23 --------------------------------------------------------------------------------
24 -- GLOBAL MESSAGE CONSTANTS
25 --------------------------------------------------------------------------------
26 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
27 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
28 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
29 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
30 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
31 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
32 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
33 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
34 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
35 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
36 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
37 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
38 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
39 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
40 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
41 G_API_VERSION CONSTANT NUMBER := 1;
42 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
43 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
44 --------------------------------------------------------------------------------
45 -- GLOBAL VARIABLES
46 --------------------------------------------------------------------------------
47 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RES_PVT';
48 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
49
50 --------------------------------------------------------------------------------
51 -- Procedures and Functions
52 --------------------------------------------------------------------------------
53 PROCEDURE change_version;
54 PROCEDURE api_copy;
55
56 PROCEDURE insert_row(
57 p_api_version IN NUMBER ,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_res_rec IN okl_res_rec,
63 x_res_rec OUT NOCOPY okl_res_rec);
64 PROCEDURE insert_row(
65 p_api_version IN NUMBER ,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_res_tbl IN okl_res_tbl,
71 x_res_tbl OUT NOCOPY okl_res_tbl);
72 PROCEDURE update_row(
73 p_api_version IN NUMBER ,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_res_rec IN okl_res_rec,
79 x_res_rec OUT NOCOPY okl_res_rec);
80 PROCEDURE update_row(
81 p_api_version IN NUMBER ,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_res_tbl IN okl_res_tbl,
87 x_res_tbl OUT NOCOPY okl_res_tbl);
88 PROCEDURE delete_row(
89 p_api_version IN NUMBER ,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_res_rec IN okl_res_rec);
95 PROCEDURE delete_row(
96 p_api_version IN NUMBER ,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_res_tbl IN okl_res_tbl);
102 END OKL_RES_PVT;