[Home] [Help]
PACKAGE: APPS.OKE_RLE_PVT
Source
1 PACKAGE OKE_RLE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVRLES.pls 115.9 2002/11/20 20:42:45 who ship $*/
3 -- GLOBAL DATA STRUCTURES
4
5 TYPE rle_rec_type IS RECORD(
6 ROW_ID ROWID,
7 K_HEADER_ID NUMBER:= OKE_API.G_MISS_NUM,
8 CHG_REQUEST_ID NUMBER:= OKE_API.G_MISS_NUM,
9 RELATED_ENTITY_ID NUMBER:= OKE_API.G_MISS_NUM,
10 RELATED_ENTITY_VERSION NUMBER:= OKE_API.G_MISS_NUM,
11 CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
12 CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
13 LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
14 LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
15 LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM
16 );
17
18 TYPE rle_tbl_type IS TABLE OF rle_rec_type
19 INDEX BY BINARY_INTEGER;
20
21 -- GLOBAL MESSAGE CONSTANTS
22
23 G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
24
25 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
26 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
27
28 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
29
30 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
31 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
32 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
33 G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
34 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
35 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
36
37 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
38 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
39 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
40 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
41 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
42 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_RLE_PVT';
43 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
44 G_VIEW CONSTANT VARCHAR2(200) := 'OKE_K_RELATED_ENTITIES_V';
45
46 G_EXCEPTION_HALT_VALIDATION exception;
47
48 -- Procedures and functions
49
50 PROCEDURE insert_row(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_rle_rec IN rle_rec_type,
57 x_rle_rec OUT NOCOPY rle_rec_type);
58
59 PROCEDURE insert_row(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_rle_tbl IN rle_tbl_type,
66 x_rle_tbl OUT NOCOPY rle_tbl_type);
67
68 PROCEDURE update_row(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_rle_rec IN rle_rec_type,
75 x_rle_rec OUT NOCOPY rle_rec_type);
76
77 PROCEDURE update_row(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_rle_tbl IN rle_tbl_type,
84 x_rle_tbl OUT NOCOPY rle_tbl_type);
85
86
87 PROCEDURE delete_row(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_rle_rec IN rle_rec_type);
94
95 PROCEDURE delete_row(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_rle_tbl IN rle_tbl_type);
102
103
104 PROCEDURE validate_row(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_rle_rec IN rle_rec_type);
111
112 PROCEDURE validate_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_rle_tbl IN rle_tbl_type);
119
120 PROCEDURE lock_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_rle_rec IN rle_rec_type);
127
128
129 END OKE_RLE_PVT;
130