3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE aet_rec_type IS RECORD (
7: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE aet_rec_type IS RECORD (
7: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE aet_rec_type IS RECORD (
7: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
6: TYPE aet_rec_type IS RECORD (
7: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
7: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
8: org_id NUMBER := Okc_Api.G_MISS_NUM,
9: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
9: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
10: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: event_number NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
12: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
13: source_id NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
14: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
15: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
16: program_id NUMBER := Okc_Api.G_MISS_NUM,
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
17: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
25: g_miss_aet_rec aet_rec_type;
18: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
25: g_miss_aet_rec aet_rec_type;
26: TYPE aet_tbl_type IS TABLE OF aet_rec_type
19: request_id NUMBER := Okc_Api.G_MISS_NUM,
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
25: g_miss_aet_rec aet_rec_type;
26: TYPE aet_tbl_type IS TABLE OF aet_rec_type
27: INDEX BY BINARY_INTEGER;
20: created_by NUMBER := Okc_Api.G_MISS_NUM,
21: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
22: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
23: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
25: g_miss_aet_rec aet_rec_type;
26: TYPE aet_tbl_type IS TABLE OF aet_rec_type
27: INDEX BY BINARY_INTEGER;
28: TYPE aetv_rec_type IS RECORD (
25: g_miss_aet_rec aet_rec_type;
26: TYPE aet_tbl_type IS TABLE OF aet_rec_type
27: INDEX BY BINARY_INTEGER;
28: TYPE aetv_rec_type IS RECORD (
29: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: org_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: TYPE aet_tbl_type IS TABLE OF aet_rec_type
27: INDEX BY BINARY_INTEGER;
28: TYPE aetv_rec_type IS RECORD (
29: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: org_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
27: INDEX BY BINARY_INTEGER;
28: TYPE aetv_rec_type IS RECORD (
29: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: org_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
28: TYPE aetv_rec_type IS RECORD (
29: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: org_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
29: accounting_event_id NUMBER := Okc_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: org_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
30: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
31: org_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
31: org_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
32: event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
33: accounting_date OKL_ACCOUNTING_EVENTS.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
34: event_number NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: event_status_code OKL_ACCOUNTING_EVENTS.EVENT_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: source_id NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: source_table OKL_ACCOUNTING_EVENTS.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: program_id NUMBER := Okc_Api.G_MISS_NUM,
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
39: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
47: g_miss_aetv_rec aetv_rec_type;
40: program_update_date OKL_ACCOUNTING_EVENTS.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
47: g_miss_aetv_rec aetv_rec_type;
48: TYPE aetv_tbl_type IS TABLE OF aetv_rec_type
41: request_id NUMBER := Okc_Api.G_MISS_NUM,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
47: g_miss_aetv_rec aetv_rec_type;
48: TYPE aetv_tbl_type IS TABLE OF aetv_rec_type
49: INDEX BY BINARY_INTEGER;
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_ACCOUNTING_EVENTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_ACCOUNTING_EVENTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
47: g_miss_aetv_rec aetv_rec_type;
48: TYPE aetv_tbl_type IS TABLE OF aetv_rec_type
49: INDEX BY BINARY_INTEGER;
50: ---------------------------------------------------------------------------
49: INDEX BY BINARY_INTEGER;
50: ---------------------------------------------------------------------------
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
50: ---------------------------------------------------------------------------
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
51: -- GLOBAL MESSAGE CONSTANTS
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
52: ---------------------------------------------------------------------------
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
53: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
54: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
55: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
56: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
57: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
58: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
59: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
60: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
61: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
62: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
63: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
64: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
65: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
66: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_AET_ELEMENT_NOT_UNIQUE';
72: ---------------------------------------------------------------------------
73: -- GLOBAL VARIABLES
74: ---------------------------------------------------------------------------
75: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AET_PVT';
76: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
77: ---------------------------------------------------------------------------
78: -- Procedures and Functions
79: ---------------------------------------------------------------------------
80:
82: PROCEDURE change_version;
83: PROCEDURE api_copy;
84: PROCEDURE insert_row(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_aetv_rec IN aetv_rec_type,
91: x_aetv_rec OUT NOCOPY aetv_rec_type);
92:
93: PROCEDURE insert_row(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_aetv_tbl IN aetv_tbl_type,
100: x_aetv_tbl OUT NOCOPY aetv_tbl_type);
101:
102: PROCEDURE lock_row(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_aetv_rec IN aetv_rec_type);
108: p_aetv_rec IN aetv_rec_type);
109:
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_aetv_tbl IN aetv_tbl_type);
116: p_aetv_tbl IN aetv_tbl_type);
117:
118: PROCEDURE update_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_aetv_rec IN aetv_rec_type,
125: x_aetv_rec OUT NOCOPY aetv_rec_type);
126:
127: PROCEDURE update_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_aetv_tbl IN aetv_tbl_type,
134: x_aetv_tbl OUT NOCOPY aetv_tbl_type);
135:
136: PROCEDURE delete_row(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_aetv_rec IN aetv_rec_type);
142: p_aetv_rec IN aetv_rec_type);
143:
144: PROCEDURE delete_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_aetv_tbl IN aetv_tbl_type);
150: p_aetv_tbl IN aetv_tbl_type);
151:
152: PROCEDURE validate_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_aetv_rec IN aetv_rec_type);
158: p_aetv_rec IN aetv_rec_type);
159:
160: PROCEDURE validate_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_aetv_tbl IN aetv_tbl_type);