eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IHD_PVT dependencies on OKS_INST_HIST_DETAILS

Line 6: -- OKS_INST_HIST_DETAILS_V Record Spec

2: /* $Header: OKSSIHDS.pls 120.4 2006/09/11 23:23:56 dneetha noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_INST_HIST_DETAILS_V Record Spec
7: TYPE ihdv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,ins_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_date OKS_INST_HIST_DETAILS_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 10: ,transaction_date OKS_INST_HIST_DETAILS_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

6: -- OKS_INST_HIST_DETAILS_V Record Spec
7: TYPE ihdv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,ins_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_date OKS_INST_HIST_DETAILS_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,transaction_type OKS_INST_HIST_DETAILS_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,system_id NUMBER := OKC_API.G_MISS_NUM
13: ,instance_id_new NUMBER := OKC_API.G_MISS_NUM
14: ,instance_qty_old NUMBER := OKC_API.G_MISS_NUM

Line 11: ,transaction_type OKS_INST_HIST_DETAILS_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR

7: TYPE ihdv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,ins_id NUMBER := OKC_API.G_MISS_NUM
10: ,transaction_date OKS_INST_HIST_DETAILS_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,transaction_type OKS_INST_HIST_DETAILS_V.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,system_id NUMBER := OKC_API.G_MISS_NUM
13: ,instance_id_new NUMBER := OKC_API.G_MISS_NUM
14: ,instance_qty_old NUMBER := OKC_API.G_MISS_NUM
15: ,instance_qty_new NUMBER := OKC_API.G_MISS_NUM

Line 19: ,old_contact_start_date OKS_INST_HIST_DETAILS_V.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE

15: ,instance_qty_new NUMBER := OKC_API.G_MISS_NUM
16: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM
17: ,instance_amt_new NUMBER := OKC_API.G_MISS_NUM
18: ,old_contract_id NUMBER := OKC_API.G_MISS_NUM
19: ,old_contact_start_date OKS_INST_HIST_DETAILS_V.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,old_contract_end_date OKS_INST_HIST_DETAILS_V.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
22: ,new_contact_start_date OKS_INST_HIST_DETAILS_V.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,new_contract_end_date OKS_INST_HIST_DETAILS_V.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 20: ,old_contract_end_date OKS_INST_HIST_DETAILS_V.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE

16: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM
17: ,instance_amt_new NUMBER := OKC_API.G_MISS_NUM
18: ,old_contract_id NUMBER := OKC_API.G_MISS_NUM
19: ,old_contact_start_date OKS_INST_HIST_DETAILS_V.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,old_contract_end_date OKS_INST_HIST_DETAILS_V.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
22: ,new_contact_start_date OKS_INST_HIST_DETAILS_V.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,new_contract_end_date OKS_INST_HIST_DETAILS_V.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM

Line 22: ,new_contact_start_date OKS_INST_HIST_DETAILS_V.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE

18: ,old_contract_id NUMBER := OKC_API.G_MISS_NUM
19: ,old_contact_start_date OKS_INST_HIST_DETAILS_V.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,old_contract_end_date OKS_INST_HIST_DETAILS_V.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
22: ,new_contact_start_date OKS_INST_HIST_DETAILS_V.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,new_contract_end_date OKS_INST_HIST_DETAILS_V.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,old_service_end_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 23: ,new_contract_end_date OKS_INST_HIST_DETAILS_V.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE

19: ,old_contact_start_date OKS_INST_HIST_DETAILS_V.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,old_contract_end_date OKS_INST_HIST_DETAILS_V.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
22: ,new_contact_start_date OKS_INST_HIST_DETAILS_V.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,new_contract_end_date OKS_INST_HIST_DETAILS_V.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,old_service_end_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM

Line 25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

21: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
22: ,new_contact_start_date OKS_INST_HIST_DETAILS_V.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,new_contract_end_date OKS_INST_HIST_DETAILS_V.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,old_service_end_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,new_service_end_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 26: ,old_service_end_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

22: ,new_contact_start_date OKS_INST_HIST_DETAILS_V.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,new_contract_end_date OKS_INST_HIST_DETAILS_V.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,old_service_end_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,new_service_end_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM

Line 28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

24: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,old_service_end_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,new_service_end_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,old_subline_end_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 29: ,new_service_end_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
26: ,old_service_end_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,new_service_end_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,old_subline_end_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM

Line 31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

27: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,new_service_end_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,old_subline_end_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
34: ,new_subline_start_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,new_subline_end_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 32: ,old_subline_end_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,new_service_end_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,old_subline_end_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
34: ,new_subline_start_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,new_subline_end_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,old_customer NUMBER := OKC_API.G_MISS_NUM

Line 34: ,new_subline_start_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

30: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,old_subline_end_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
34: ,new_subline_start_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,new_subline_end_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,old_customer NUMBER := OKC_API.G_MISS_NUM
37: ,new_customer NUMBER := OKC_API.G_MISS_NUM
38: ,old_k_status OKS_INST_HIST_DETAILS_V.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 35: ,new_subline_end_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,old_subline_end_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
34: ,new_subline_start_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,new_subline_end_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,old_customer NUMBER := OKC_API.G_MISS_NUM
37: ,new_customer NUMBER := OKC_API.G_MISS_NUM
38: ,old_k_status OKS_INST_HIST_DETAILS_V.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,new_k_status OKS_INST_HIST_DETAILS_V.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 38: ,old_k_status OKS_INST_HIST_DETAILS_V.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

34: ,new_subline_start_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,new_subline_end_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,old_customer NUMBER := OKC_API.G_MISS_NUM
37: ,new_customer NUMBER := OKC_API.G_MISS_NUM
38: ,old_k_status OKS_INST_HIST_DETAILS_V.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,new_k_status OKS_INST_HIST_DETAILS_V.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
40: ,subline_date_terminated OKS_INST_HIST_DETAILS_V.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
41: ,transfer_option OKS_INST_HIST_DETAILS_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
42: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 39: ,new_k_status OKS_INST_HIST_DETAILS_V.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

35: ,new_subline_end_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,old_customer NUMBER := OKC_API.G_MISS_NUM
37: ,new_customer NUMBER := OKC_API.G_MISS_NUM
38: ,old_k_status OKS_INST_HIST_DETAILS_V.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,new_k_status OKS_INST_HIST_DETAILS_V.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
40: ,subline_date_terminated OKS_INST_HIST_DETAILS_V.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
41: ,transfer_option OKS_INST_HIST_DETAILS_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_INST_HIST_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 40: ,subline_date_terminated OKS_INST_HIST_DETAILS_V.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE

36: ,old_customer NUMBER := OKC_API.G_MISS_NUM
37: ,new_customer NUMBER := OKC_API.G_MISS_NUM
38: ,old_k_status OKS_INST_HIST_DETAILS_V.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,new_k_status OKS_INST_HIST_DETAILS_V.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
40: ,subline_date_terminated OKS_INST_HIST_DETAILS_V.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
41: ,transfer_option OKS_INST_HIST_DETAILS_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_INST_HIST_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 41: ,transfer_option OKS_INST_HIST_DETAILS_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR

37: ,new_customer NUMBER := OKC_API.G_MISS_NUM
38: ,old_k_status OKS_INST_HIST_DETAILS_V.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
39: ,new_k_status OKS_INST_HIST_DETAILS_V.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
40: ,subline_date_terminated OKS_INST_HIST_DETAILS_V.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
41: ,transfer_option OKS_INST_HIST_DETAILS_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_INST_HIST_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_INST_HIST_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 43: ,creation_date OKS_INST_HIST_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

39: ,new_k_status OKS_INST_HIST_DETAILS_V.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
40: ,subline_date_terminated OKS_INST_HIST_DETAILS_V.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
41: ,transfer_option OKS_INST_HIST_DETAILS_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_INST_HIST_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_INST_HIST_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 45: ,last_update_date OKS_INST_HIST_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

41: ,transfer_option OKS_INST_HIST_DETAILS_V.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_INST_HIST_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_INST_HIST_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
49: ,date_cancelled OKS_INST_HIST_DETAILS_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);

Line 49: ,date_cancelled OKS_INST_HIST_DETAILS_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);

45: ,last_update_date OKS_INST_HIST_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
49: ,date_cancelled OKS_INST_HIST_DETAILS_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);
50: G_MISS_ihdv_rec ihdv_rec_type;
51: TYPE ihdv_tbl_type IS TABLE OF ihdv_rec_type
52: INDEX BY BINARY_INTEGER;
53: -- OKS_INST_HIST_DETAILS Record Spec

Line 53: -- OKS_INST_HIST_DETAILS Record Spec

49: ,date_cancelled OKS_INST_HIST_DETAILS_V.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);
50: G_MISS_ihdv_rec ihdv_rec_type;
51: TYPE ihdv_tbl_type IS TABLE OF ihdv_rec_type
52: INDEX BY BINARY_INTEGER;
53: -- OKS_INST_HIST_DETAILS Record Spec
54: TYPE ihd_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM
56: ,ins_id NUMBER := OKC_API.G_MISS_NUM
57: ,transaction_date OKS_INST_HIST_DETAILS.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 57: ,transaction_date OKS_INST_HIST_DETAILS.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

53: -- OKS_INST_HIST_DETAILS Record Spec
54: TYPE ihd_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM
56: ,ins_id NUMBER := OKC_API.G_MISS_NUM
57: ,transaction_date OKS_INST_HIST_DETAILS.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,transaction_type OKS_INST_HIST_DETAILS.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: ,system_id NUMBER := OKC_API.G_MISS_NUM
60: ,instance_id_new NUMBER := OKC_API.G_MISS_NUM
61: ,instance_qty_old NUMBER := OKC_API.G_MISS_NUM

Line 58: ,transaction_type OKS_INST_HIST_DETAILS.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR

54: TYPE ihd_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM
56: ,ins_id NUMBER := OKC_API.G_MISS_NUM
57: ,transaction_date OKS_INST_HIST_DETAILS.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,transaction_type OKS_INST_HIST_DETAILS.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: ,system_id NUMBER := OKC_API.G_MISS_NUM
60: ,instance_id_new NUMBER := OKC_API.G_MISS_NUM
61: ,instance_qty_old NUMBER := OKC_API.G_MISS_NUM
62: ,instance_qty_new NUMBER := OKC_API.G_MISS_NUM

Line 66: ,old_contact_start_date OKS_INST_HIST_DETAILS.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE

62: ,instance_qty_new NUMBER := OKC_API.G_MISS_NUM
63: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM
64: ,instance_amt_new NUMBER := OKC_API.G_MISS_NUM
65: ,old_contract_id NUMBER := OKC_API.G_MISS_NUM
66: ,old_contact_start_date OKS_INST_HIST_DETAILS.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,old_contract_end_date OKS_INST_HIST_DETAILS.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
69: ,new_contact_start_date OKS_INST_HIST_DETAILS.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,new_contract_end_date OKS_INST_HIST_DETAILS.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 67: ,old_contract_end_date OKS_INST_HIST_DETAILS.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE

63: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM
64: ,instance_amt_new NUMBER := OKC_API.G_MISS_NUM
65: ,old_contract_id NUMBER := OKC_API.G_MISS_NUM
66: ,old_contact_start_date OKS_INST_HIST_DETAILS.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,old_contract_end_date OKS_INST_HIST_DETAILS.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
69: ,new_contact_start_date OKS_INST_HIST_DETAILS.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,new_contract_end_date OKS_INST_HIST_DETAILS.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM

Line 69: ,new_contact_start_date OKS_INST_HIST_DETAILS.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE

65: ,old_contract_id NUMBER := OKC_API.G_MISS_NUM
66: ,old_contact_start_date OKS_INST_HIST_DETAILS.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,old_contract_end_date OKS_INST_HIST_DETAILS.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
69: ,new_contact_start_date OKS_INST_HIST_DETAILS.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,new_contract_end_date OKS_INST_HIST_DETAILS.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,old_service_end_date OKS_INST_HIST_DETAILS.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 70: ,new_contract_end_date OKS_INST_HIST_DETAILS.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE

66: ,old_contact_start_date OKS_INST_HIST_DETAILS.OLD_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,old_contract_end_date OKS_INST_HIST_DETAILS.OLD_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
69: ,new_contact_start_date OKS_INST_HIST_DETAILS.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,new_contract_end_date OKS_INST_HIST_DETAILS.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,old_service_end_date OKS_INST_HIST_DETAILS.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM

Line 72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

68: ,new_contract_id NUMBER := OKC_API.G_MISS_NUM
69: ,new_contact_start_date OKS_INST_HIST_DETAILS.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,new_contract_end_date OKS_INST_HIST_DETAILS.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,old_service_end_date OKS_INST_HIST_DETAILS.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,new_service_end_date OKS_INST_HIST_DETAILS.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 73: ,old_service_end_date OKS_INST_HIST_DETAILS.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

69: ,new_contact_start_date OKS_INST_HIST_DETAILS.NEW_CONTACT_START_DATE%TYPE := OKC_API.G_MISS_DATE
70: ,new_contract_end_date OKS_INST_HIST_DETAILS.NEW_CONTRACT_END_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,old_service_end_date OKS_INST_HIST_DETAILS.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,new_service_end_date OKS_INST_HIST_DETAILS.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
77: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM

Line 75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

71: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM
72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,old_service_end_date OKS_INST_HIST_DETAILS.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,new_service_end_date OKS_INST_HIST_DETAILS.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
77: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,old_subline_end_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 76: ,new_service_end_date OKS_INST_HIST_DETAILS.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE

72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,old_service_end_date OKS_INST_HIST_DETAILS.OLD_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,new_service_end_date OKS_INST_HIST_DETAILS.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
77: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,old_subline_end_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM

Line 78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

74: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM
75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,new_service_end_date OKS_INST_HIST_DETAILS.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
77: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,old_subline_end_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
81: ,new_subline_start_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,new_subline_end_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 79: ,old_subline_end_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,new_service_end_date OKS_INST_HIST_DETAILS.NEW_SERVICE_END_DATE%TYPE := OKC_API.G_MISS_DATE
77: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,old_subline_end_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
81: ,new_subline_start_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,new_subline_end_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
83: ,old_customer NUMBER := OKC_API.G_MISS_NUM

Line 81: ,new_subline_start_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

77: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM
78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,old_subline_end_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
81: ,new_subline_start_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,new_subline_end_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
83: ,old_customer NUMBER := OKC_API.G_MISS_NUM
84: ,new_customer NUMBER := OKC_API.G_MISS_NUM
85: ,old_k_status OKS_INST_HIST_DETAILS.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 82: ,new_subline_end_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE

78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
79: ,old_subline_end_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM
81: ,new_subline_start_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,new_subline_end_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
83: ,old_customer NUMBER := OKC_API.G_MISS_NUM
84: ,new_customer NUMBER := OKC_API.G_MISS_NUM
85: ,old_k_status OKS_INST_HIST_DETAILS.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
86: ,new_k_status OKS_INST_HIST_DETAILS.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 85: ,old_k_status OKS_INST_HIST_DETAILS.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

81: ,new_subline_start_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE
82: ,new_subline_end_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
83: ,old_customer NUMBER := OKC_API.G_MISS_NUM
84: ,new_customer NUMBER := OKC_API.G_MISS_NUM
85: ,old_k_status OKS_INST_HIST_DETAILS.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
86: ,new_k_status OKS_INST_HIST_DETAILS.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
87: ,subline_date_terminated OKS_INST_HIST_DETAILS.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
88: ,transfer_option OKS_INST_HIST_DETAILS.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
89: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 86: ,new_k_status OKS_INST_HIST_DETAILS.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR

82: ,new_subline_end_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_END_DATE%TYPE := OKC_API.G_MISS_DATE
83: ,old_customer NUMBER := OKC_API.G_MISS_NUM
84: ,new_customer NUMBER := OKC_API.G_MISS_NUM
85: ,old_k_status OKS_INST_HIST_DETAILS.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
86: ,new_k_status OKS_INST_HIST_DETAILS.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
87: ,subline_date_terminated OKS_INST_HIST_DETAILS.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
88: ,transfer_option OKS_INST_HIST_DETAILS.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
89: ,created_by NUMBER := OKC_API.G_MISS_NUM
90: ,creation_date OKS_INST_HIST_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 87: ,subline_date_terminated OKS_INST_HIST_DETAILS.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE

83: ,old_customer NUMBER := OKC_API.G_MISS_NUM
84: ,new_customer NUMBER := OKC_API.G_MISS_NUM
85: ,old_k_status OKS_INST_HIST_DETAILS.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
86: ,new_k_status OKS_INST_HIST_DETAILS.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
87: ,subline_date_terminated OKS_INST_HIST_DETAILS.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
88: ,transfer_option OKS_INST_HIST_DETAILS.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
89: ,created_by NUMBER := OKC_API.G_MISS_NUM
90: ,creation_date OKS_INST_HIST_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 88: ,transfer_option OKS_INST_HIST_DETAILS.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR

84: ,new_customer NUMBER := OKC_API.G_MISS_NUM
85: ,old_k_status OKS_INST_HIST_DETAILS.OLD_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
86: ,new_k_status OKS_INST_HIST_DETAILS.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
87: ,subline_date_terminated OKS_INST_HIST_DETAILS.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
88: ,transfer_option OKS_INST_HIST_DETAILS.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
89: ,created_by NUMBER := OKC_API.G_MISS_NUM
90: ,creation_date OKS_INST_HIST_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
92: ,last_update_date OKS_INST_HIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 90: ,creation_date OKS_INST_HIST_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

86: ,new_k_status OKS_INST_HIST_DETAILS.NEW_K_STATUS%TYPE := OKC_API.G_MISS_CHAR
87: ,subline_date_terminated OKS_INST_HIST_DETAILS.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE
88: ,transfer_option OKS_INST_HIST_DETAILS.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
89: ,created_by NUMBER := OKC_API.G_MISS_NUM
90: ,creation_date OKS_INST_HIST_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
92: ,last_update_date OKS_INST_HIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
93: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
94: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 92: ,last_update_date OKS_INST_HIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

88: ,transfer_option OKS_INST_HIST_DETAILS.TRANSFER_OPTION%TYPE := OKC_API.G_MISS_CHAR
89: ,created_by NUMBER := OKC_API.G_MISS_NUM
90: ,creation_date OKS_INST_HIST_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
91: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
92: ,last_update_date OKS_INST_HIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
93: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
94: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
95: ,date_cancelled OKS_INST_HIST_DETAILS.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);
96: G_MISS_ihd_rec ihd_rec_type;

Line 95: ,date_cancelled OKS_INST_HIST_DETAILS.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);

91: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
92: ,last_update_date OKS_INST_HIST_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
93: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
94: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
95: ,date_cancelled OKS_INST_HIST_DETAILS.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);
96: G_MISS_ihd_rec ihd_rec_type;
97: TYPE ihd_tbl_type IS TABLE OF ihd_rec_type
98: INDEX BY BINARY_INTEGER;
99: ---------------------------------------------------------------------------