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_SLL_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_STREAM_LEVELS_V Record Spec
7: TYPE sllv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM

Line 9: ,chr_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_STREAM_LEVELS_V Record Spec
7: TYPE sllv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,cle_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKS_STREAM_LEVELS_V Record Spec
7: TYPE sllv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE sllv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM

Line 13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM

Line 14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM

Line 15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM

Line 16: ,level_periods NUMBER := OKC_API.G_MISS_NUM

12: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM

Line 17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM

13: ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM

Line 18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM

14: ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,level_amount NUMBER := OKC_API.G_MISS_NUM

15: ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM

16: ,level_periods NUMBER := OKC_API.G_MISS_NUM
17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM

Line 21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM

17: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR

18: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR

19: ,level_amount NUMBER := OKC_API.G_MISS_NUM
20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 24: ,amount NUMBER := OKC_API.G_MISS_NUM

20: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR

21: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

22: ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

23: ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 28: ,request_id NUMBER := OKC_API.G_MISS_NUM

24: ,amount NUMBER := OKC_API.G_MISS_NUM
25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 29: ,created_by NUMBER := OKC_API.G_MISS_NUM

25: ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

27: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
35: ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

Line 32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

28: ,request_id NUMBER := OKC_API.G_MISS_NUM
29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
35: ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
36: ,orig_system_source_code OKS_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);

Line 33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

29: ,created_by NUMBER := OKC_API.G_MISS_NUM
30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
35: ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
36: ,orig_system_source_code OKS_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
37: G_MISS_sllv_rec sllv_rec_type;

Line 34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

30: ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
35: ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
36: ,orig_system_source_code OKS_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
37: G_MISS_sllv_rec sllv_rec_type;
38: TYPE sllv_tbl_type IS TABLE OF sllv_rec_type

Line 35: ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

31: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
35: ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
36: ,orig_system_source_code OKS_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
37: G_MISS_sllv_rec sllv_rec_type;
38: TYPE sllv_tbl_type IS TABLE OF sllv_rec_type
39: INDEX BY BINARY_INTEGER;

Line 36: ,orig_system_source_code OKS_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);

32: ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
35: ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
36: ,orig_system_source_code OKS_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
37: G_MISS_sllv_rec sllv_rec_type;
38: TYPE sllv_tbl_type IS TABLE OF sllv_rec_type
39: INDEX BY BINARY_INTEGER;
40: -- OKS_STREAM_LEVELS_B Record Spec

Line 42: id NUMBER := OKC_API.G_MISS_NUM

38: TYPE sllv_tbl_type IS TABLE OF sllv_rec_type
39: INDEX BY BINARY_INTEGER;
40: -- OKS_STREAM_LEVELS_B Record Spec
41: TYPE sll_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM
43: ,chr_id NUMBER := OKC_API.G_MISS_NUM
44: ,cle_id NUMBER := OKC_API.G_MISS_NUM
45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM

Line 43: ,chr_id NUMBER := OKC_API.G_MISS_NUM

39: INDEX BY BINARY_INTEGER;
40: -- OKS_STREAM_LEVELS_B Record Spec
41: TYPE sll_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM
43: ,chr_id NUMBER := OKC_API.G_MISS_NUM
44: ,cle_id NUMBER := OKC_API.G_MISS_NUM
45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 44: ,cle_id NUMBER := OKC_API.G_MISS_NUM

40: -- OKS_STREAM_LEVELS_B Record Spec
41: TYPE sll_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM
43: ,chr_id NUMBER := OKC_API.G_MISS_NUM
44: ,cle_id NUMBER := OKC_API.G_MISS_NUM
45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

41: TYPE sll_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM
43: ,chr_id NUMBER := OKC_API.G_MISS_NUM
44: ,cle_id NUMBER := OKC_API.G_MISS_NUM
45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM

42: id NUMBER := OKC_API.G_MISS_NUM
43: ,chr_id NUMBER := OKC_API.G_MISS_NUM
44: ,cle_id NUMBER := OKC_API.G_MISS_NUM
45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM

Line 47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

43: ,chr_id NUMBER := OKC_API.G_MISS_NUM
44: ,cle_id NUMBER := OKC_API.G_MISS_NUM
45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM

Line 48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE

44: ,cle_id NUMBER := OKC_API.G_MISS_NUM
45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM

Line 49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE

45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM

Line 50: ,level_periods NUMBER := OKC_API.G_MISS_NUM

46: ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM

Line 51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM

47: ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM

Line 52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM

48: ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR

Line 53: ,level_amount NUMBER := OKC_API.G_MISS_NUM

49: ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR

Line 54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM

50: ,level_periods NUMBER := OKC_API.G_MISS_NUM
51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM

Line 55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM

51: ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR

Line 56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR

52: ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR

53: ,level_amount NUMBER := OKC_API.G_MISS_NUM
54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 58: ,amount NUMBER := OKC_API.G_MISS_NUM

54: ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR

55: ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

56: ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 61: ,request_id NUMBER := OKC_API.G_MISS_NUM

57: ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 62: ,created_by NUMBER := OKC_API.G_MISS_NUM

58: ,amount NUMBER := OKC_API.G_MISS_NUM
59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

59: ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

60: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

61: ,request_id NUMBER := OKC_API.G_MISS_NUM
62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_STREAM_LEVELS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);

Line 66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

62: ,created_by NUMBER := OKC_API.G_MISS_NUM
63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_STREAM_LEVELS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
70: G_MISS_sll_rec sll_rec_type;

Line 67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

63: ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_STREAM_LEVELS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
70: G_MISS_sll_rec sll_rec_type;
71: TYPE sll_tbl_type IS TABLE OF sll_rec_type

Line 68: ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

64: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_STREAM_LEVELS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
70: G_MISS_sll_rec sll_rec_type;
71: TYPE sll_tbl_type IS TABLE OF sll_rec_type
72: INDEX BY BINARY_INTEGER;

Line 69: ,orig_system_source_code OKS_STREAM_LEVELS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);

65: ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_STREAM_LEVELS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
70: G_MISS_sll_rec sll_rec_type;
71: TYPE sll_tbl_type IS TABLE OF sll_rec_type
72: INDEX BY BINARY_INTEGER;
73: ---------------------------------------------------------------------------

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

72: INDEX BY BINARY_INTEGER;
73: ---------------------------------------------------------------------------
74: -- GLOBAL MESSAGE CONSTANTS
75: ---------------------------------------------------------------------------
76: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
77: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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

73: ---------------------------------------------------------------------------
74: -- GLOBAL MESSAGE CONSTANTS
75: ---------------------------------------------------------------------------
76: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
77: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

74: -- GLOBAL MESSAGE CONSTANTS
75: ---------------------------------------------------------------------------
76: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
77: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

75: ---------------------------------------------------------------------------
76: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
77: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

76: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
77: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

77: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
85: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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

78: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
85: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
86: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';

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

79: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
85: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
86: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
87: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

80: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
85: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
86: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
87: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
88: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

81: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
85: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
86: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
87: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
88: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
89:

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

95: ---------------------------------------------------------------------------
96: -- GLOBAL VARIABLES
97: ---------------------------------------------------------------------------
98: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_SLL_PVT';
99: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
100: ---------------------------------------------------------------------------
101: -- Procedures and Functions
102: ---------------------------------------------------------------------------
103:

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

119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_sllv_tbl IN sllv_tbl_type,
122: x_sllv_tbl OUT NOCOPY sllv_tbl_type,
123: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
124: PROCEDURE insert_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2,
127: x_return_status OUT NOCOPY VARCHAR2,

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

142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_sllv_tbl IN sllv_tbl_type,
146: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
147: PROCEDURE lock_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2,
150: x_return_status OUT NOCOPY VARCHAR2,

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

166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_sllv_tbl IN sllv_tbl_type,
169: x_sllv_tbl OUT NOCOPY sllv_tbl_type,
170: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
171: PROCEDURE update_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2,
174: x_return_status OUT NOCOPY VARCHAR2,

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

189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_sllv_tbl IN sllv_tbl_type,
193: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
194: PROCEDURE delete_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2,
197: x_return_status OUT NOCOPY VARCHAR2,

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

211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_sllv_tbl IN sllv_tbl_type,
215: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
216: PROCEDURE validate_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2,
219: x_return_status OUT NOCOPY VARCHAR2,