3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
36: TYPE rscv_tbl_type IS TABLE OF rscv_rec_type
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
36: TYPE rscv_tbl_type IS TABLE OF rscv_rec_type
37: INDEX BY BINARY_INTEGER;
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
36: TYPE rscv_tbl_type IS TABLE OF rscv_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
41: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
53: ---------------------------------------------------------------------------
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
53: ---------------------------------------------------------------------------
54: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RSC_PVT';
51: ---------------------------------------------------------------------------
52: -- GLOBAL VARIABLES
53: ---------------------------------------------------------------------------
54: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RSC_PVT';
55: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
56: ---------------------------------------------------------------------------
57: -- Procedures and Functions
58: ---------------------------------------------------------------------------
59:
61: PROCEDURE change_version;
62: PROCEDURE api_copy;
63: PROCEDURE insert_row(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_rscv_rec IN rscv_rec_type,
70: x_rscv_rec OUT NOCOPY rscv_rec_type);
71:
72: PROCEDURE insert_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_rscv_tbl IN rscv_tbl_type,
79: x_rscv_tbl OUT NOCOPY rscv_tbl_type);
80:
81: PROCEDURE lock_row(
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rscv_rec IN rscv_rec_type);
87: p_rscv_rec IN rscv_rec_type);
88:
89: PROCEDURE lock_row(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rscv_tbl IN rscv_tbl_type);
95: p_rscv_tbl IN rscv_tbl_type);
96:
97: PROCEDURE update_row(
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_rscv_rec IN rscv_rec_type,
104: x_rscv_rec OUT NOCOPY rscv_rec_type);
105:
106: PROCEDURE update_row(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_rscv_tbl IN rscv_tbl_type,
113: x_rscv_tbl OUT NOCOPY rscv_tbl_type);
114:
115: PROCEDURE delete_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_rscv_rec IN rscv_rec_type);
121: p_rscv_rec IN rscv_rec_type);
122:
123: PROCEDURE delete_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_rscv_tbl IN rscv_tbl_type);
129: p_rscv_tbl IN rscv_tbl_type);
130:
131: PROCEDURE validate_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_rscv_rec IN rscv_rec_type);
137: p_rscv_rec IN rscv_rec_type);
138:
139: PROCEDURE validate_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_rscv_tbl IN rscv_tbl_type);