2: /* $Header: OKSINTHS.pls 120.0 2005/05/25 18:21:43 appldev noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_INTERACTION_HIST_V Record Spec
7: TYPE inhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,contract_number OKS_INTERACTION_HIST_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
6: -- OKS_INTERACTION_HIST_V Record Spec
7: TYPE inhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,contract_number OKS_INTERACTION_HIST_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number_modifier OKS_INTERACTION_HIST_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_status OKS_INTERACTION_HIST_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,party_id NUMBER := OKC_API.G_MISS_NUM
14: ,user_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE inhv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,contract_number OKS_INTERACTION_HIST_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number_modifier OKS_INTERACTION_HIST_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_status OKS_INTERACTION_HIST_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,party_id NUMBER := OKC_API.G_MISS_NUM
14: ,user_id NUMBER := OKC_API.G_MISS_NUM
15: ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,contract_number OKS_INTERACTION_HIST_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number_modifier OKS_INTERACTION_HIST_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_status OKS_INTERACTION_HIST_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,party_id NUMBER := OKC_API.G_MISS_NUM
14: ,user_id NUMBER := OKC_API.G_MISS_NUM
15: ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,status OKS_INTERACTION_HIST_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number_modifier OKS_INTERACTION_HIST_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
12: ,renewal_status OKS_INTERACTION_HIST_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,party_id NUMBER := OKC_API.G_MISS_NUM
14: ,user_id NUMBER := OKC_API.G_MISS_NUM
15: ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,status OKS_INTERACTION_HIST_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
17: ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,task_result OKS_INTERACTION_HIST_V.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKS_INTERACTION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,renewal_status OKS_INTERACTION_HIST_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
13: ,party_id NUMBER := OKC_API.G_MISS_NUM
14: ,user_id NUMBER := OKC_API.G_MISS_NUM
15: ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,status OKS_INTERACTION_HIST_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
17: ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,task_result OKS_INTERACTION_HIST_V.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKS_INTERACTION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
13: ,party_id NUMBER := OKC_API.G_MISS_NUM
14: ,user_id NUMBER := OKC_API.G_MISS_NUM
15: ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,status OKS_INTERACTION_HIST_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
17: ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,task_result OKS_INTERACTION_HIST_V.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKS_INTERACTION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_INTERACTION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,user_id NUMBER := OKC_API.G_MISS_NUM
15: ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,status OKS_INTERACTION_HIST_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
17: ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,task_result OKS_INTERACTION_HIST_V.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKS_INTERACTION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_INTERACTION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
15: ,description OKS_INTERACTION_HIST_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
16: ,status OKS_INTERACTION_HIST_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
17: ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,task_result OKS_INTERACTION_HIST_V.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKS_INTERACTION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_INTERACTION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
17: ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,task_result OKS_INTERACTION_HIST_V.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKS_INTERACTION_HIST_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_INTERACTION_HIST_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
25: G_MISS_inhv_rec inhv_rec_type;