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