[Home] [Help]
PACKAGE: APPS.OKS_INS_PVT
Source
1 PACKAGE OKS_INS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSSINSS.pls 120.3 2006/09/11 23:23:25 dneetha noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_INSTANCE_HISTORY_V Record Spec
7 TYPE insv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,instance_id NUMBER := OKC_API.G_MISS_NUM
10 ,transaction_type OKS_INSTANCE_HISTORY_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
11 ,transaction_date OKS_INSTANCE_HISTORY_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12 ,reference_number OKS_INSTANCE_HISTORY_V.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13 ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
14 ,created_by NUMBER := OKC_API.G_MISS_NUM
15 ,creation_date OKS_INSTANCE_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17 ,last_update_date OKS_INSTANCE_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
19 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20 ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
21 G_MISS_insv_rec insv_rec_type;
22 TYPE insv_tbl_type IS TABLE OF insv_rec_type
23 INDEX BY BINARY_INTEGER;
24 -- OKS_INSTANCE_HISTORY Record Spec
25 TYPE ins_rec_type IS RECORD (
26 id NUMBER := OKC_API.G_MISS_NUM
27 ,instance_id NUMBER := OKC_API.G_MISS_NUM
28 ,transaction_type OKS_INSTANCE_HISTORY.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
29 ,transaction_date OKS_INSTANCE_HISTORY.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
30 ,reference_number OKS_INSTANCE_HISTORY.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31 ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
32 ,created_by NUMBER := OKC_API.G_MISS_NUM
33 ,creation_date OKS_INSTANCE_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35 ,last_update_date OKS_INSTANCE_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
37 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
38 ,batch_id NUMBER := OKC_API.G_MISS_NUM);
39 G_MISS_ins_rec ins_rec_type;
40 TYPE ins_tbl_type IS TABLE OF ins_rec_type
41 INDEX BY BINARY_INTEGER;
42 ---------------------------------------------------------------------------
43 -- GLOBAL MESSAGE CONSTANTS
44 ---------------------------------------------------------------------------
45 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
46 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
47 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
48 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
49 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
50 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
51 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
52 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
53 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
54 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
55 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
56 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
57 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
58
59 ---------------------------------------------------------------------------
60 -- GLOBAL EXCEPTIONS
61 ---------------------------------------------------------------------------
62 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
63
64 ---------------------------------------------------------------------------
65 -- GLOBAL VARIABLES
66 ---------------------------------------------------------------------------
67 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_INS_PVT';
68 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
69 ---------------------------------------------------------------------------
70 -- Procedures and Functions
71 ---------------------------------------------------------------------------
72
73 PROCEDURE qc;
74 PROCEDURE change_version;
75 PROCEDURE api_copy;
76 PROCEDURE insert_row(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_insv_rec IN insv_rec_type,
83 x_insv_rec OUT NOCOPY insv_rec_type);
84 PROCEDURE insert_row(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_insv_tbl IN insv_tbl_type,
91 x_insv_tbl OUT NOCOPY insv_tbl_type,
92 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
93 PROCEDURE insert_row(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_insv_tbl IN insv_tbl_type,
100 x_insv_tbl OUT NOCOPY insv_tbl_type);
101 PROCEDURE lock_row(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_insv_rec IN insv_rec_type);
108 PROCEDURE lock_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_insv_tbl IN insv_tbl_type,
115 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
116 PROCEDURE lock_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_insv_tbl IN insv_tbl_type);
123 PROCEDURE update_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_insv_rec IN insv_rec_type,
130 x_insv_rec OUT NOCOPY insv_rec_type);
131 PROCEDURE update_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_insv_tbl IN insv_tbl_type,
138 x_insv_tbl OUT NOCOPY insv_tbl_type,
139 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
140 PROCEDURE update_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_insv_tbl IN insv_tbl_type,
147 x_insv_tbl OUT NOCOPY insv_tbl_type);
148 PROCEDURE delete_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_insv_rec IN insv_rec_type);
155 PROCEDURE delete_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_insv_tbl IN insv_tbl_type,
162 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
163 PROCEDURE delete_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_insv_tbl IN insv_tbl_type);
170 PROCEDURE validate_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_insv_rec IN insv_rec_type);
177 PROCEDURE validate_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_insv_tbl IN insv_tbl_type,
184 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
185 PROCEDURE validate_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_insv_tbl IN insv_tbl_type);
192 END OKS_INS_PVT;