DBA Data[Home] [Help]

APPS.OKS_INS_PVT dependencies on OKS_INSTANCE_HISTORY

Line 6: -- OKS_INSTANCE_HISTORY_V Record Spec

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

Line 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

Line 11: ,transaction_date OKS_INSTANCE_HISTORY_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 12: ,reference_number OKS_INSTANCE_HISTORY_V.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

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

Line 13: ,parameters OKS_INSTANCE_HISTORY_V.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR

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

Line 15: ,creation_date OKS_INSTANCE_HISTORY_V.CREATION_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

Line 17: ,last_update_date OKS_INSTANCE_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 24: -- OKS_INSTANCE_HISTORY Record Spec

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

Line 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

Line 29: ,transaction_date OKS_INSTANCE_HISTORY.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 30: ,reference_number OKS_INSTANCE_HISTORY.REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

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

Line 31: ,parameters OKS_INSTANCE_HISTORY.PARAMETERS%TYPE := OKC_API.G_MISS_CHAR

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

Line 33: ,creation_date OKS_INSTANCE_HISTORY.CREATION_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

Line 35: ,last_update_date OKS_INSTANCE_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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;