[Home] [Help]
PACKAGE: APPS.OKL_PSY_PVT
Source
1 PACKAGE OKL_PSY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSPSYS.pls 115.2 2002/05/15 09:11:42 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_PROD_STRM_TYPES_V Record Spec
7 TYPE psyv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,from_date OKL_PROD_STRM_TYPES_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
10 ,TO_DATE OKL_PROD_STRM_TYPES_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE
11 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12 ,accrual_yn OKL_PROD_STRM_TYPES_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
13 ,sty_id NUMBER := OKC_API.G_MISS_NUM
14 ,pdt_id NUMBER := OKC_API.G_MISS_NUM
15 ,created_by NUMBER := OKC_API.G_MISS_NUM
16 ,creation_date OKL_PROD_STRM_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
17 ,last_update_date OKL_PROD_STRM_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
19 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
20 G_MISS_psyv_rec psyv_rec_type;
21 TYPE psyv_tbl_type IS TABLE OF psyv_rec_type
22 INDEX BY BINARY_INTEGER;
23 -- OKL_PROD_STRM_TYPES Record Spec
24 TYPE psy_rec_type IS RECORD (
25 id NUMBER := OKC_API.G_MISS_NUM
26 ,TO_DATE OKL_PROD_STRM_TYPES.TO_DATE%TYPE := OKC_API.G_MISS_DATE
27 ,accrual_yn OKL_PROD_STRM_TYPES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR
28 ,from_date OKL_PROD_STRM_TYPES.FROM_DATE%TYPE := OKC_API.G_MISS_DATE
29 ,sty_id NUMBER := OKC_API.G_MISS_NUM
30 ,pdt_id NUMBER := OKC_API.G_MISS_NUM
31 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
32 ,created_by NUMBER := OKC_API.G_MISS_NUM
33 ,creation_date OKL_PROD_STRM_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35 ,last_update_date OKL_PROD_STRM_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
37 G_MISS_psy_rec psy_rec_type;
38 TYPE psy_tbl_type IS TABLE OF psy_rec_type
39 INDEX BY BINARY_INTEGER;
40 ---------------------------------------------------------------------------
41 -- GLOBAL MESSAGE CONSTANTS
42 ---------------------------------------------------------------------------
43 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
44 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
45 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
46 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
47 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
48 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
49 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
50 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
51 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
52 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
53 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
54 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
55 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
56 G_TO_DATE_ERROR CONSTANT VARCHAR2(200) := 'OKL_TO_DATE_ERROR';
57 G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME'; --- CHG001
58 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE'; --- CHG001
59
60 ---------------------------------------------------------------------------
61 -- GLOBAL EXCEPTIONS
62 ---------------------------------------------------------------------------
63 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
64 G_ITEM_NOT_FOUND_ERROR EXCEPTION;
65
66 ---------------------------------------------------------------------------
67 -- GLOBAL VARIABLES
68 ---------------------------------------------------------------------------
69 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PSY_PVT';
70 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
71 ---------------------------------------------------------------------------
72 -- Procedures and Functions
73 ---------------------------------------------------------------------------
74
75 PROCEDURE qc;
76 PROCEDURE change_version;
77 PROCEDURE api_copy;
78 PROCEDURE insert_row(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_psyv_rec IN psyv_rec_type,
85 x_psyv_rec OUT NOCOPY psyv_rec_type);
86 PROCEDURE insert_row(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_psyv_tbl IN psyv_tbl_type,
93 x_psyv_tbl OUT NOCOPY psyv_tbl_type,
94 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
95 PROCEDURE insert_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_psyv_tbl IN psyv_tbl_type,
102 x_psyv_tbl OUT NOCOPY psyv_tbl_type);
103 PROCEDURE lock_row(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_psyv_rec IN psyv_rec_type);
110 PROCEDURE lock_row(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_psyv_tbl IN psyv_tbl_type,
117 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
118 PROCEDURE lock_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_psyv_tbl IN psyv_tbl_type);
125 PROCEDURE update_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_psyv_rec IN psyv_rec_type,
132 x_psyv_rec OUT NOCOPY psyv_rec_type);
133 PROCEDURE update_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_psyv_tbl IN psyv_tbl_type,
140 x_psyv_tbl OUT NOCOPY psyv_tbl_type,
141 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
142 PROCEDURE update_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_psyv_tbl IN psyv_tbl_type,
149 x_psyv_tbl OUT NOCOPY psyv_tbl_type);
150 PROCEDURE delete_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_psyv_rec IN psyv_rec_type);
157 PROCEDURE delete_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_psyv_tbl IN psyv_tbl_type,
164 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
165 PROCEDURE delete_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_psyv_tbl IN psyv_tbl_type);
172 PROCEDURE validate_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_psyv_rec IN psyv_rec_type);
179 PROCEDURE validate_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_psyv_tbl IN psyv_tbl_type,
186 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
187 PROCEDURE validate_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_psyv_tbl IN psyv_tbl_type);
194 END OKL_PSY_PVT;