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 OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

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
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

Line 9: ,ins_id NUMBER := OKC_API.G_MISS_NUM

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
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

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 12: ,system_id NUMBER := OKC_API.G_MISS_NUM

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
16: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM

Line 13: ,instance_id_new 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
16: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM
17: ,instance_amt_new NUMBER := OKC_API.G_MISS_NUM

Line 14: ,instance_qty_old 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
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

Line 15: ,instance_qty_new NUMBER := OKC_API.G_MISS_NUM

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
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

Line 16: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM

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
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

Line 17: ,instance_amt_new 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
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

Line 18: ,old_contract_id 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
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

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 21: ,new_contract_id 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
25: ,old_service_start_date OKS_INST_HIST_DETAILS_V.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 24: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM

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
28: ,new_service_start_date OKS_INST_HIST_DETAILS_V.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 27: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM

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
31: ,old_subline_start_date OKS_INST_HIST_DETAILS_V.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 30: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM

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
34: ,new_subline_start_date OKS_INST_HIST_DETAILS_V.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 33: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM

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
37: ,new_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 36: ,old_customer NUMBER := OKC_API.G_MISS_NUM

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
40: ,subline_date_terminated OKS_INST_HIST_DETAILS_V.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE

Line 37: ,new_customer NUMBER := OKC_API.G_MISS_NUM

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
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

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 42: ,created_by 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
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

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 44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

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
48: ,security_group_id 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 46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

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);
50: G_MISS_ihdv_rec ihdv_rec_type;

Line 47: ,object_version_number 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);
50: G_MISS_ihdv_rec ihdv_rec_type;
51: TYPE ihdv_tbl_type IS TABLE OF ihdv_rec_type

Line 48: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

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);
50: G_MISS_ihdv_rec ihdv_rec_type;
51: TYPE ihdv_tbl_type IS TABLE OF ihdv_rec_type
52: INDEX BY BINARY_INTEGER;

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 55: id NUMBER := OKC_API.G_MISS_NUM

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
58: ,transaction_type OKS_INST_HIST_DETAILS.TRANSACTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: ,system_id NUMBER := OKC_API.G_MISS_NUM

Line 56: ,ins_id NUMBER := OKC_API.G_MISS_NUM

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
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

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 59: ,system_id NUMBER := OKC_API.G_MISS_NUM

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
63: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM

Line 60: ,instance_id_new 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
63: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM
64: ,instance_amt_new NUMBER := OKC_API.G_MISS_NUM

Line 61: ,instance_qty_old 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
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

Line 62: ,instance_qty_new NUMBER := OKC_API.G_MISS_NUM

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
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

Line 63: ,instance_amt_old NUMBER := OKC_API.G_MISS_NUM

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
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

Line 64: ,instance_amt_new 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
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

Line 65: ,old_contract_id 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
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

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 68: ,new_contract_id 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
72: ,old_service_start_date OKS_INST_HIST_DETAILS.OLD_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 71: ,old_service_line_id NUMBER := OKC_API.G_MISS_NUM

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
75: ,new_service_start_date OKS_INST_HIST_DETAILS.NEW_SERVICE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 74: ,new_service_line_id NUMBER := OKC_API.G_MISS_NUM

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
78: ,old_subline_start_date OKS_INST_HIST_DETAILS.OLD_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 77: ,old_subline_id NUMBER := OKC_API.G_MISS_NUM

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
81: ,new_subline_start_date OKS_INST_HIST_DETAILS.NEW_SUBLINE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 80: ,new_subline_id NUMBER := OKC_API.G_MISS_NUM

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
84: ,new_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 83: ,old_customer NUMBER := OKC_API.G_MISS_NUM

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
87: ,subline_date_terminated OKS_INST_HIST_DETAILS.SUBLINE_DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE

Line 84: ,new_customer NUMBER := OKC_API.G_MISS_NUM

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
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

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 89: ,created_by 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
93: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

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 91: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

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
95: ,date_cancelled OKS_INST_HIST_DETAILS.DATE_CANCELLED%TYPE := OKC_API.G_MISS_DATE);

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 93: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

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;
97: TYPE ihd_tbl_type IS TABLE OF ihd_rec_type

Line 94: ,object_version_number 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;
97: TYPE ihd_tbl_type IS TABLE OF ihd_rec_type
98: INDEX BY BINARY_INTEGER;

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: ---------------------------------------------------------------------------

Line 102: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

98: INDEX BY BINARY_INTEGER;
99: ---------------------------------------------------------------------------
100: -- GLOBAL MESSAGE CONSTANTS
101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

99: ---------------------------------------------------------------------------
100: -- GLOBAL MESSAGE CONSTANTS
101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

100: -- GLOBAL MESSAGE CONSTANTS
101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

101: ---------------------------------------------------------------------------
102: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

102: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

103: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

104: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
112: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';

Line 109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

105: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
112: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
113: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

106: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
112: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
113: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
114: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

107: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
108: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
109: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
110: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
111: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
112: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
113: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
114: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
115:

Line 125: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

121: ---------------------------------------------------------------------------
122: -- GLOBAL VARIABLES
123: ---------------------------------------------------------------------------
124: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_IHD_PVT';
125: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
126: ---------------------------------------------------------------------------
127: -- Procedures and Functions
128: ---------------------------------------------------------------------------
129:

Line 149: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_ihdv_tbl IN ihdv_tbl_type,
148: x_ihdv_tbl OUT NOCOPY ihdv_tbl_type,
149: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
150: PROCEDURE insert_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2,
153: x_return_status OUT NOCOPY VARCHAR2,

Line 172: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_ihdv_tbl IN ihdv_tbl_type,
172: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
173: PROCEDURE lock_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2,
176: x_return_status OUT NOCOPY VARCHAR2,

Line 196: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_ihdv_tbl IN ihdv_tbl_type,
195: x_ihdv_tbl OUT NOCOPY ihdv_tbl_type,
196: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
197: PROCEDURE update_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,

Line 219: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_ihdv_tbl IN ihdv_tbl_type,
219: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
220: PROCEDURE delete_row(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2,
223: x_return_status OUT NOCOPY VARCHAR2,

Line 241: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_ihdv_tbl IN ihdv_tbl_type,
241: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
242: PROCEDURE validate_row(
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2,
245: x_return_status OUT NOCOPY VARCHAR2,