3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE oie_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cop_id NUMBER := OKC_API.G_MISS_NUM,
9: status_code OKC_OPERATION_INSTANCES.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE oie_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cop_id NUMBER := OKC_API.G_MISS_NUM,
9: status_code OKC_OPERATION_INSTANCES.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE oie_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cop_id NUMBER := OKC_API.G_MISS_NUM,
9: status_code OKC_OPERATION_INSTANCES.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE oie_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cop_id NUMBER := OKC_API.G_MISS_NUM,
9: status_code OKC_OPERATION_INSTANCES.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cop_id NUMBER := OKC_API.G_MISS_NUM,
9: status_code OKC_OPERATION_INSTANCES.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
8: cop_id NUMBER := OKC_API.G_MISS_NUM,
9: status_code OKC_OPERATION_INSTANCES.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: status_code OKC_OPERATION_INSTANCES.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKC_OPERATION_INSTANCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_update_date OKC_OPERATION_INSTANCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
15: last_update_login NUMBER := OKC_API.G_MISS_NUM,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: object1_id1 OKC_OPERATION_INSTANCES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
16: name OKC_OPERATION_INSTANCES.NAME%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: object1_id1 OKC_OPERATION_INSTANCES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
24: object1_id2 OKC_OPERATION_INSTANCES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
17: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: object1_id1 OKC_OPERATION_INSTANCES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
24: object1_id2 OKC_OPERATION_INSTANCES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
25: -- R12 Data Model Changes 4485150 Start
18: request_id NUMBER := OKC_API.G_MISS_NUM,
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: object1_id1 OKC_OPERATION_INSTANCES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
24: object1_id2 OKC_OPERATION_INSTANCES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
25: -- R12 Data Model Changes 4485150 Start
26: batch_id NUMBER := OKC_API.G_MISS_NUM
19: program_application_id NUMBER := OKC_API.G_MISS_NUM,
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: object1_id1 OKC_OPERATION_INSTANCES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
24: object1_id2 OKC_OPERATION_INSTANCES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
25: -- R12 Data Model Changes 4485150 Start
26: batch_id NUMBER := OKC_API.G_MISS_NUM
27: -- R12 Data Model Changes 4485150 Start
20: program_id NUMBER := OKC_API.G_MISS_NUM,
21: program_update_date OKC_OPERATION_INSTANCES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: object1_id1 OKC_OPERATION_INSTANCES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
24: object1_id2 OKC_OPERATION_INSTANCES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
25: -- R12 Data Model Changes 4485150 Start
26: batch_id NUMBER := OKC_API.G_MISS_NUM
27: -- R12 Data Model Changes 4485150 Start
28: );
22: jtot_object1_code OKC_OPERATION_INSTANCES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: object1_id1 OKC_OPERATION_INSTANCES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
24: object1_id2 OKC_OPERATION_INSTANCES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
25: -- R12 Data Model Changes 4485150 Start
26: batch_id NUMBER := OKC_API.G_MISS_NUM
27: -- R12 Data Model Changes 4485150 Start
28: );
29:
30: g_miss_oie_rec oie_rec_type;
31: TYPE oie_tbl_type IS TABLE OF oie_rec_type
32: INDEX BY BINARY_INTEGER;
33:
34: TYPE oiev_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: name OKC_OPERATION_INSTANCES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
37: cop_id NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
32: INDEX BY BINARY_INTEGER;
33:
34: TYPE oiev_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: name OKC_OPERATION_INSTANCES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
37: cop_id NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
33:
34: TYPE oiev_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: name OKC_OPERATION_INSTANCES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
37: cop_id NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
34: TYPE oiev_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: name OKC_OPERATION_INSTANCES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
37: cop_id NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: id NUMBER := OKC_API.G_MISS_NUM,
36: name OKC_OPERATION_INSTANCES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
37: cop_id NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: name OKC_OPERATION_INSTANCES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
37: cop_id NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: cop_id NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
38: status_code OKC_OPERATION_INSTANCES_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: jtot_object1_code OKC_OPERATION_INSTANCES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
39: target_chr_id NUMBER := OKC_API.G_MISS_NUM,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: jtot_object1_code OKC_OPERATION_INSTANCES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id1 OKC_OPERATION_INSTANCES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
40: object_version_number NUMBER := OKC_API.G_MISS_NUM,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: jtot_object1_code OKC_OPERATION_INSTANCES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id1 OKC_OPERATION_INSTANCES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
48: object1_id2 OKC_OPERATION_INSTANCES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: jtot_object1_code OKC_OPERATION_INSTANCES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id1 OKC_OPERATION_INSTANCES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
48: object1_id2 OKC_OPERATION_INSTANCES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
49:
42: creation_date OKC_OPERATION_INSTANCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: jtot_object1_code OKC_OPERATION_INSTANCES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id1 OKC_OPERATION_INSTANCES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
48: object1_id2 OKC_OPERATION_INSTANCES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
49:
50: g_miss_oiev_rec oiev_rec_type;
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: jtot_object1_code OKC_OPERATION_INSTANCES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id1 OKC_OPERATION_INSTANCES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
48: object1_id2 OKC_OPERATION_INSTANCES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
49:
50: g_miss_oiev_rec oiev_rec_type;
51: TYPE oiev_tbl_type IS TABLE OF oiev_rec_type
44: last_update_date OKC_OPERATION_INSTANCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: jtot_object1_code OKC_OPERATION_INSTANCES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id1 OKC_OPERATION_INSTANCES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
48: object1_id2 OKC_OPERATION_INSTANCES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
49:
50: g_miss_oiev_rec oiev_rec_type;
51: TYPE oiev_tbl_type IS TABLE OF oiev_rec_type
52: INDEX BY BINARY_INTEGER;
53:
54: ---------------------------------------------------------------------------
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
54: ---------------------------------------------------------------------------
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: ---------------------------------------------------------------------------
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: ---------------------------------------------------------------------------
68: -- GLOBAL VARIABLES
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: ---------------------------------------------------------------------------
68: -- GLOBAL VARIABLES
69: ---------------------------------------------------------------------------
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: ---------------------------------------------------------------------------
68: -- GLOBAL VARIABLES
69: ---------------------------------------------------------------------------
70: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OIE_PVT';
67: ---------------------------------------------------------------------------
68: -- GLOBAL VARIABLES
69: ---------------------------------------------------------------------------
70: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OIE_PVT';
71: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
72: ---------------------------------------------------------------------------
73: -- Procedures and Functions
74: ---------------------------------------------------------------------------
75:
77: PROCEDURE change_version;
78: PROCEDURE api_copy;
79: PROCEDURE insert_row(
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_oiev_rec IN oiev_rec_type,
86: x_oiev_rec OUT NOCOPY oiev_rec_type);
87:
88: PROCEDURE insert_row(
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: p_oiev_tbl IN oiev_tbl_type,
95: x_oiev_tbl OUT NOCOPY oiev_tbl_type);
96:
97: PROCEDURE lock_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_oiev_rec IN oiev_rec_type);
103: p_oiev_rec IN oiev_rec_type);
104:
105: PROCEDURE lock_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_oiev_tbl IN oiev_tbl_type);
111: p_oiev_tbl IN oiev_tbl_type);
112:
113: PROCEDURE update_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_oiev_rec IN oiev_rec_type,
120: x_oiev_rec OUT NOCOPY oiev_rec_type);
121:
122: PROCEDURE update_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_oiev_tbl IN oiev_tbl_type,
129: x_oiev_tbl OUT NOCOPY oiev_tbl_type);
130:
131: PROCEDURE delete_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_oiev_rec IN oiev_rec_type);
137: p_oiev_rec IN oiev_rec_type);
138:
139: PROCEDURE delete_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_oiev_tbl IN oiev_tbl_type);
145: p_oiev_tbl IN oiev_tbl_type);
146:
147: PROCEDURE validate_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_oiev_rec IN oiev_rec_type);
153: p_oiev_rec IN oiev_rec_type);
154:
155: PROCEDURE validate_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_oiev_tbl IN oiev_tbl_type);