2: /* $Header: OKSSINSS.pls 120.3 2006/09/11 23:23:25 dneetha noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_INSTANCE_HISTORY_V Record Spec
7: TYPE insv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_type OKS_INSTANCE_HISTORY_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
6: -- OKS_INSTANCE_HISTORY_V Record Spec
7: TYPE insv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_type OKS_INSTANCE_HISTORY_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_INSTANCE_HISTORY_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,reference_number OKS_INSTANCE_HISTORY_V.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
7: TYPE insv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_type OKS_INSTANCE_HISTORY_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_INSTANCE_HISTORY_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,reference_number OKS_INSTANCE_HISTORY_V.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_INSTANCE_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_type OKS_INSTANCE_HISTORY_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_INSTANCE_HISTORY_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,reference_number OKS_INSTANCE_HISTORY_V.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_INSTANCE_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
9: ,instance_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_type OKS_INSTANCE_HISTORY_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_INSTANCE_HISTORY_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,reference_number OKS_INSTANCE_HISTORY_V.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_INSTANCE_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_INSTANCE_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,transaction_date OKS_INSTANCE_HISTORY_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,reference_number OKS_INSTANCE_HISTORY_V.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_INSTANCE_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_INSTANCE_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_INSTANCE_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_INSTANCE_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
19: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
21: G_MISS_insv_rec insv_rec_type;
20: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
21: G_MISS_insv_rec insv_rec_type;
22: TYPE insv_tbl_type IS TABLE OF insv_rec_type
23: INDEX BY BINARY_INTEGER;
24: -- OKS_INSTANCE_HISTORY Record Spec
25: TYPE ins_rec_type IS RECORD (
26: id NUMBER := OKC_API.G_MISS_NUM
27: ,instance_id NUMBER := OKC_API.G_MISS_NUM
28: ,transaction_type OKS_INSTANCE_HISTORY.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: -- OKS_INSTANCE_HISTORY Record Spec
25: TYPE ins_rec_type IS RECORD (
26: id NUMBER := OKC_API.G_MISS_NUM
27: ,instance_id NUMBER := OKC_API.G_MISS_NUM
28: ,transaction_type OKS_INSTANCE_HISTORY.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
29: ,transaction_date OKS_INSTANCE_HISTORY.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,reference_number OKS_INSTANCE_HISTORY.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
25: TYPE ins_rec_type IS RECORD (
26: id NUMBER := OKC_API.G_MISS_NUM
27: ,instance_id NUMBER := OKC_API.G_MISS_NUM
28: ,transaction_type OKS_INSTANCE_HISTORY.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
29: ,transaction_date OKS_INSTANCE_HISTORY.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,reference_number OKS_INSTANCE_HISTORY.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKS_INSTANCE_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
26: id NUMBER := OKC_API.G_MISS_NUM
27: ,instance_id NUMBER := OKC_API.G_MISS_NUM
28: ,transaction_type OKS_INSTANCE_HISTORY.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
29: ,transaction_date OKS_INSTANCE_HISTORY.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,reference_number OKS_INSTANCE_HISTORY.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKS_INSTANCE_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
27: ,instance_id NUMBER := OKC_API.G_MISS_NUM
28: ,transaction_type OKS_INSTANCE_HISTORY.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
29: ,transaction_date OKS_INSTANCE_HISTORY.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,reference_number OKS_INSTANCE_HISTORY.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKS_INSTANCE_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKS_INSTANCE_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,transaction_date OKS_INSTANCE_HISTORY.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,reference_number OKS_INSTANCE_HISTORY.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKS_INSTANCE_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKS_INSTANCE_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
37: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
31: ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR
32: ,created_by NUMBER := OKC_API.G_MISS_NUM
33: ,creation_date OKS_INSTANCE_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
35: ,last_update_date OKS_INSTANCE_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
37: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
38: ,batch_id NUMBER := OKC_API.G_MISS_NUM);
39: G_MISS_ins_rec ins_rec_type;