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
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
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
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
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
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
17: ,task_name OKS_INTERACTION_HIST_V.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
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
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
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
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
24: ,object_version_number 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;
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;
26: TYPE inhv_tbl_type IS TABLE OF inhv_rec_type
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;
26: TYPE inhv_tbl_type IS TABLE OF inhv_rec_type
27: INDEX BY BINARY_INTEGER;
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;
26: TYPE inhv_tbl_type IS TABLE OF inhv_rec_type
27: INDEX BY BINARY_INTEGER;
28: -- OKS_INTERACTION_HISTORY Record Spec
26: TYPE inhv_tbl_type IS TABLE OF inhv_rec_type
27: INDEX BY BINARY_INTEGER;
28: -- OKS_INTERACTION_HISTORY Record Spec
29: TYPE inh_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
27: INDEX BY BINARY_INTEGER;
28: -- OKS_INTERACTION_HISTORY Record Spec
29: TYPE inh_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
28: -- OKS_INTERACTION_HISTORY Record Spec
29: TYPE inh_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
29: TYPE inh_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
30: id NUMBER := OKC_API.G_MISS_NUM
31: ,chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
31: ,chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,contract_number OKS_INTERACTION_HISTORY.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
33: ,contract_number_modifier OKS_INTERACTION_HISTORY.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,renewal_status OKS_INTERACTION_HISTORY.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,party_id NUMBER := OKC_API.G_MISS_NUM
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,user_id NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,description OKS_INTERACTION_HISTORY.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
38: ,status OKS_INTERACTION_HISTORY.STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
46: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
39: ,task_name OKS_INTERACTION_HISTORY.TASK_NAME%TYPE := OKC_API.G_MISS_CHAR
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
46: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_inh_rec inh_rec_type;
40: ,task_result OKS_INTERACTION_HISTORY.TASK_RESULT%TYPE := OKC_API.G_MISS_CHAR
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
46: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_inh_rec inh_rec_type;
48: TYPE inh_tbl_type IS TABLE OF inh_rec_type
41: ,creation_date OKS_INTERACTION_HISTORY.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
46: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_inh_rec inh_rec_type;
48: TYPE inh_tbl_type IS TABLE OF inh_rec_type
49: INDEX BY BINARY_INTEGER;
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_INTERACTION_HISTORY.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
46: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
47: G_MISS_inh_rec inh_rec_type;
48: TYPE inh_tbl_type IS TABLE OF inh_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) := 'OKS_SERVICE_AVAILABILITY_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) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
64: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
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) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
64: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
65: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
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) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
64: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
65: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
66:
72: ---------------------------------------------------------------------------
73: -- GLOBAL VARIABLES
74: ---------------------------------------------------------------------------
75: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_INTERACTION_HIST_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_inhv_rec IN inhv_rec_type,
90: p_inhv_rec IN inhv_rec_type,
91: x_inhv_rec OUT NOCOPY inhv_rec_type);
92: PROCEDURE insert_row(
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_inhv_tbl IN inhv_tbl_type,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_inhv_tbl IN inhv_tbl_type,
99: x_inhv_tbl OUT NOCOPY inhv_tbl_type,
100: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
101: PROCEDURE insert_row(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
99: x_inhv_tbl OUT NOCOPY inhv_tbl_type,
100: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
101: PROCEDURE insert_row(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_inhv_tbl IN inhv_tbl_type,
107: p_inhv_tbl IN inhv_tbl_type,
108: x_inhv_tbl OUT NOCOPY inhv_tbl_type);
109: PROCEDURE lock_row(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_inhv_rec IN inhv_rec_type);
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_inhv_rec IN inhv_rec_type);
116: PROCEDURE lock_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_inhv_tbl IN inhv_tbl_type,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_inhv_tbl IN inhv_tbl_type,
123: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
124: PROCEDURE lock_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
122: p_inhv_tbl IN inhv_tbl_type,
123: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
124: PROCEDURE lock_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_inhv_tbl IN inhv_tbl_type);
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_inhv_tbl IN inhv_tbl_type);
131: PROCEDURE update_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_inhv_rec IN inhv_rec_type,
137: p_inhv_rec IN inhv_rec_type,
138: x_inhv_rec OUT NOCOPY inhv_rec_type);
139: PROCEDURE update_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_inhv_tbl IN inhv_tbl_type,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_inhv_tbl IN inhv_tbl_type,
146: x_inhv_tbl OUT NOCOPY inhv_tbl_type,
147: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
148: PROCEDURE update_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
146: x_inhv_tbl OUT NOCOPY inhv_tbl_type,
147: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
148: PROCEDURE update_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_inhv_tbl IN inhv_tbl_type,
154: p_inhv_tbl IN inhv_tbl_type,
155: x_inhv_tbl OUT NOCOPY inhv_tbl_type);
156: PROCEDURE delete_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_inhv_rec IN inhv_rec_type);
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_inhv_rec IN inhv_rec_type);
163: PROCEDURE delete_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_inhv_tbl IN inhv_tbl_type,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_inhv_tbl IN inhv_tbl_type,
170: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
171: PROCEDURE delete_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
169: p_inhv_tbl IN inhv_tbl_type,
170: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
171: PROCEDURE delete_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_inhv_tbl IN inhv_tbl_type);
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_inhv_tbl IN inhv_tbl_type);
178: PROCEDURE validate_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_inhv_rec IN inhv_rec_type);
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_inhv_rec IN inhv_rec_type);
185: PROCEDURE validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_inhv_tbl IN inhv_tbl_type,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_inhv_tbl IN inhv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
193: PROCEDURE validate_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
191: p_inhv_tbl IN inhv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
193: PROCEDURE validate_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_inhv_tbl IN inhv_tbl_type);