3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ole_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: select_yn OKC_OPERATION_LINES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
9: active_yn OKC_OPERATION_LINES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ole_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: select_yn OKC_OPERATION_LINES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
9: active_yn OKC_OPERATION_LINES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE ole_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: select_yn OKC_OPERATION_LINES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
9: active_yn OKC_OPERATION_LINES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE ole_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: select_yn OKC_OPERATION_LINES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
9: active_yn OKC_OPERATION_LINES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: select_yn OKC_OPERATION_LINES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
9: active_yn OKC_OPERATION_LINES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
8: select_yn OKC_OPERATION_LINES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
9: active_yn OKC_OPERATION_LINES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
9: active_yn OKC_OPERATION_LINES.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: process_flag OKC_OPERATION_LINES.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
11: oie_id NUMBER := OKC_API.G_MISS_NUM,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
15: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
16: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
17: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
25: program_id NUMBER := OKC_API.G_MISS_NUM,
18: created_by NUMBER := OKC_API.G_MISS_NUM,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
25: program_id NUMBER := OKC_API.G_MISS_NUM,
26: program_update_date OKC_OPERATION_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: creation_date OKC_OPERATION_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
25: program_id NUMBER := OKC_API.G_MISS_NUM,
26: program_update_date OKC_OPERATION_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: message_code OKC_OPERATION_LINES.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
20: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
25: program_id NUMBER := OKC_API.G_MISS_NUM,
26: program_update_date OKC_OPERATION_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: message_code OKC_OPERATION_LINES.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
28: g_miss_ole_rec ole_rec_type;
21: last_update_date OKC_OPERATION_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
25: program_id NUMBER := OKC_API.G_MISS_NUM,
26: program_update_date OKC_OPERATION_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: message_code OKC_OPERATION_LINES.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
28: g_miss_ole_rec ole_rec_type;
29: TYPE ole_tbl_type IS TABLE OF ole_rec_type
22: last_update_login NUMBER := OKC_API.G_MISS_NUM,
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
25: program_id NUMBER := OKC_API.G_MISS_NUM,
26: program_update_date OKC_OPERATION_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: message_code OKC_OPERATION_LINES.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
28: g_miss_ole_rec ole_rec_type;
29: TYPE ole_tbl_type IS TABLE OF ole_rec_type
30: INDEX BY BINARY_INTEGER;
23: request_id NUMBER := OKC_API.G_MISS_NUM,
24: program_application_id NUMBER := OKC_API.G_MISS_NUM,
25: program_id NUMBER := OKC_API.G_MISS_NUM,
26: program_update_date OKC_OPERATION_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: message_code OKC_OPERATION_LINES.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
28: g_miss_ole_rec ole_rec_type;
29: TYPE ole_tbl_type IS TABLE OF ole_rec_type
30: INDEX BY BINARY_INTEGER;
31: TYPE olev_rec_type IS RECORD (
28: g_miss_ole_rec ole_rec_type;
29: TYPE ole_tbl_type IS TABLE OF ole_rec_type
30: INDEX BY BINARY_INTEGER;
31: TYPE olev_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM,
33: select_yn OKC_OPERATION_LINES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
34: active_yn OKC_OPERATION_LINES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
29: TYPE ole_tbl_type IS TABLE OF ole_rec_type
30: INDEX BY BINARY_INTEGER;
31: TYPE olev_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM,
33: select_yn OKC_OPERATION_LINES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
34: active_yn OKC_OPERATION_LINES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
30: INDEX BY BINARY_INTEGER;
31: TYPE olev_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM,
33: select_yn OKC_OPERATION_LINES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
34: active_yn OKC_OPERATION_LINES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
31: TYPE olev_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM,
33: select_yn OKC_OPERATION_LINES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
34: active_yn OKC_OPERATION_LINES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
32: id NUMBER := OKC_API.G_MISS_NUM,
33: select_yn OKC_OPERATION_LINES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
34: active_yn OKC_OPERATION_LINES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
33: select_yn OKC_OPERATION_LINES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR,
34: active_yn OKC_OPERATION_LINES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
34: active_yn OKC_OPERATION_LINES_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
35: process_flag OKC_OPERATION_LINES_V.PROCESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
36: oie_id NUMBER := OKC_API.G_MISS_NUM,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: parent_ole_id NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: subject_chr_id NUMBER := OKC_API.G_MISS_NUM,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: object_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
40: subject_cle_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
41: object_cle_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
50: program_id NUMBER := OKC_API.G_MISS_NUM,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
50: program_id NUMBER := OKC_API.G_MISS_NUM,
51: program_update_date OKC_OPERATION_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44: creation_date OKC_OPERATION_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
50: program_id NUMBER := OKC_API.G_MISS_NUM,
51: program_update_date OKC_OPERATION_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: message_code OKC_OPERATION_LINES_V.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
50: program_id NUMBER := OKC_API.G_MISS_NUM,
51: program_update_date OKC_OPERATION_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: message_code OKC_OPERATION_LINES_V.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
53: g_miss_olev_rec olev_rec_type;
46: last_update_date OKC_OPERATION_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
50: program_id NUMBER := OKC_API.G_MISS_NUM,
51: program_update_date OKC_OPERATION_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: message_code OKC_OPERATION_LINES_V.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
53: g_miss_olev_rec olev_rec_type;
54: TYPE olev_tbl_type IS TABLE OF olev_rec_type
47: last_update_login NUMBER := OKC_API.G_MISS_NUM,
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
50: program_id NUMBER := OKC_API.G_MISS_NUM,
51: program_update_date OKC_OPERATION_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: message_code OKC_OPERATION_LINES_V.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
53: g_miss_olev_rec olev_rec_type;
54: TYPE olev_tbl_type IS TABLE OF olev_rec_type
55: INDEX BY BINARY_INTEGER;
48: request_id NUMBER := OKC_API.G_MISS_NUM,
49: program_application_id NUMBER := OKC_API.G_MISS_NUM,
50: program_id NUMBER := OKC_API.G_MISS_NUM,
51: program_update_date OKC_OPERATION_LINES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52: message_code OKC_OPERATION_LINES_V.MESSAGE_CODE%TYPE := OKC_API.G_MISS_CHAR);
53: g_miss_olev_rec olev_rec_type;
54: TYPE olev_tbl_type IS TABLE OF olev_rec_type
55: INDEX BY BINARY_INTEGER;
56: ---------------------------------------------------------------------------
55: INDEX BY BINARY_INTEGER;
56: ---------------------------------------------------------------------------
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: ---------------------------------------------------------------------------
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: ---------------------------------------------------------------------------
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: ---------------------------------------------------------------------------
70: -- GLOBAL VARIABLES
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: ---------------------------------------------------------------------------
70: -- GLOBAL VARIABLES
71: ---------------------------------------------------------------------------
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: ---------------------------------------------------------------------------
70: -- GLOBAL VARIABLES
71: ---------------------------------------------------------------------------
72: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OLE_PVT';
69: ---------------------------------------------------------------------------
70: -- GLOBAL VARIABLES
71: ---------------------------------------------------------------------------
72: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OLE_PVT';
73: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
74: ---------------------------------------------------------------------------
75: -- Procedures and Functions
76: ---------------------------------------------------------------------------
77:
79: PROCEDURE change_version;
80: PROCEDURE api_copy;
81: PROCEDURE insert_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_olev_rec IN olev_rec_type,
88: x_olev_rec OUT NOCOPY olev_rec_type);
89:
90: PROCEDURE insert_row(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_olev_tbl IN olev_tbl_type,
97: x_olev_tbl OUT NOCOPY olev_tbl_type);
98:
99: PROCEDURE lock_row(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_olev_rec IN olev_rec_type);
105: p_olev_rec IN olev_rec_type);
106:
107: PROCEDURE lock_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_olev_tbl IN olev_tbl_type);
113: p_olev_tbl IN olev_tbl_type);
114:
115: PROCEDURE update_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_olev_rec IN olev_rec_type,
122: x_olev_rec OUT NOCOPY olev_rec_type);
123:
124: PROCEDURE update_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_olev_tbl IN olev_tbl_type,
131: x_olev_tbl OUT NOCOPY olev_tbl_type);
132:
133: PROCEDURE delete_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_olev_rec IN olev_rec_type);
139: p_olev_rec IN olev_rec_type);
140:
141: PROCEDURE delete_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_olev_tbl IN olev_tbl_type);
147: p_olev_tbl IN olev_tbl_type);
148:
149: PROCEDURE validate_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_olev_rec IN olev_rec_type);
155: p_olev_rec IN olev_rec_type);
156:
157: PROCEDURE validate_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_olev_tbl IN olev_tbl_type);