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

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_PM_STREAM_LEVELS_V Record Spec
7: TYPE pmlv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM

Line 9: ,cle_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_PM_STREAM_LEVELS_V Record Spec
7: TYPE pmlv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM

Line 10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKS_PM_STREAM_LEVELS_V Record Spec
7: TYPE pmlv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE pmlv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM

Line 13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM

9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR

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

10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM

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

11: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,frequency NUMBER := OKC_API.G_MISS_NUM

12: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR

Line 17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR

13: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM

14: ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR

15: ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR

16: ,frequency NUMBER := OKC_API.G_MISS_NUM
17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

17: ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 22: ,program_id NUMBER := OKC_API.G_MISS_NUM

18: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

19: ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

20: ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

21: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 26: ,request_id NUMBER := OKC_API.G_MISS_NUM

22: ,program_id NUMBER := OKC_API.G_MISS_NUM
23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 27: ,created_by NUMBER := OKC_API.G_MISS_NUM

23: ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

24: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: -- R12 Data Model Changes 4485150 Start

Line 29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

25: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: -- R12 Data Model Changes 4485150 Start
33: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

26: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: -- R12 Data Model Changes 4485150 Start
33: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_reference1 OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

Line 31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

27: ,created_by NUMBER := OKC_API.G_MISS_NUM
28: ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: -- R12 Data Model Changes 4485150 Start
33: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_reference1 OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
35: ,orig_system_source_code OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 33: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

29: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: -- R12 Data Model Changes 4485150 Start
33: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_reference1 OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
35: ,orig_system_source_code OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
36: -- R12 Data Model Changes 4485150 End
37: );

Line 34: ,orig_system_reference1 OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

30: ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: -- R12 Data Model Changes 4485150 Start
33: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_reference1 OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
35: ,orig_system_source_code OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
36: -- R12 Data Model Changes 4485150 End
37: );
38: G_MISS_pmlv_rec pmlv_rec_type;

Line 35: ,orig_system_source_code OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

31: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32: -- R12 Data Model Changes 4485150 Start
33: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
34: ,orig_system_reference1 OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
35: ,orig_system_source_code OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
36: -- R12 Data Model Changes 4485150 End
37: );
38: G_MISS_pmlv_rec pmlv_rec_type;
39: TYPE pmlv_tbl_type IS TABLE OF pmlv_rec_type

Line 43: id NUMBER := OKC_API.G_MISS_NUM

39: TYPE pmlv_tbl_type IS TABLE OF pmlv_rec_type
40: INDEX BY BINARY_INTEGER;
41: -- OKS_PM_STREAM_LEVELS Record Spec
42: TYPE pml_rec_type IS RECORD (
43: 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: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM

Line 44: ,cle_id NUMBER := OKC_API.G_MISS_NUM

40: INDEX BY BINARY_INTEGER;
41: -- OKS_PM_STREAM_LEVELS Record Spec
42: TYPE pml_rec_type IS RECORD (
43: 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: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM

Line 45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

41: -- OKS_PM_STREAM_LEVELS Record Spec
42: TYPE pml_rec_type IS RECORD (
43: 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: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 46: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM

42: TYPE pml_rec_type IS RECORD (
43: 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: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE

Line 47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM

43: 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: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM

Line 48: ,number_of_occurences 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: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR

Line 49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE

45: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM

Line 50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE

46: ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR

Line 51: ,frequency NUMBER := OKC_API.G_MISS_NUM

47: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR

Line 52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR

48: ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM

49: ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR

50: ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR

51: ,frequency NUMBER := OKC_API.G_MISS_NUM
52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

52: ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 57: ,program_id NUMBER := OKC_API.G_MISS_NUM

53: ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

54: ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

55: ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 60: ,request_id NUMBER := OKC_API.G_MISS_NUM

56: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 61: ,created_by NUMBER := OKC_API.G_MISS_NUM

57: ,program_id NUMBER := OKC_API.G_MISS_NUM
58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

58: ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: -- R12 Data Model Changes 4485150 Start

Line 63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

59: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: -- R12 Data Model Changes 4485150 Start
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

60: ,request_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: -- R12 Data Model Changes 4485150 Start
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: -- R12 Data Model Changes 4485150 Start
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: -- R12 Data Model Changes 4485150 Start
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
70: -- R12 Data Model Changes 4485150 End
71: );

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

64: ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: -- R12 Data Model Changes 4485150 Start
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
70: -- R12 Data Model Changes 4485150 End
71: );
72: G_MISS_pml_rec pml_rec_type;

Line 69: ,orig_system_source_code OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: -- R12 Data Model Changes 4485150 Start
67: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68: ,orig_system_reference1 OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69: ,orig_system_source_code OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
70: -- R12 Data Model Changes 4485150 End
71: );
72: G_MISS_pml_rec pml_rec_type;
73: TYPE pml_tbl_type IS TABLE OF pml_rec_type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

107: PROCEDURE change_version;
108: PROCEDURE api_copy;
109: PROCEDURE insert_row(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_pmlv_rec IN pmlv_rec_type,

Line 119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

115: p_pmlv_rec IN pmlv_rec_type,
116: x_pmlv_rec OUT NOCOPY pmlv_rec_type);
117: PROCEDURE insert_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_pmlv_tbl IN pmlv_tbl_type,

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

121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_pmlv_tbl IN pmlv_tbl_type,
124: x_pmlv_tbl OUT NOCOPY pmlv_tbl_type,
125: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
126: PROCEDURE insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

124: x_pmlv_tbl OUT NOCOPY pmlv_tbl_type,
125: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
126: PROCEDURE insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_pmlv_tbl IN pmlv_tbl_type,

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

132: p_pmlv_tbl IN pmlv_tbl_type,
133: x_pmlv_tbl OUT NOCOPY pmlv_tbl_type);
134: PROCEDURE lock_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_pmlv_rec IN pmlv_rec_type);

Line 143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_pmlv_rec IN pmlv_rec_type);
141: PROCEDURE lock_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_pmlv_tbl IN pmlv_tbl_type,

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

144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_pmlv_tbl IN pmlv_tbl_type,
148: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
149: PROCEDURE lock_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

147: p_pmlv_tbl IN pmlv_tbl_type,
148: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
149: PROCEDURE lock_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_pmlv_tbl IN pmlv_tbl_type);

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_pmlv_tbl IN pmlv_tbl_type);
156: PROCEDURE update_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_pmlv_rec IN pmlv_rec_type,

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

162: p_pmlv_rec IN pmlv_rec_type,
163: x_pmlv_rec OUT NOCOPY pmlv_rec_type);
164: PROCEDURE update_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_pmlv_tbl IN pmlv_tbl_type,

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

168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_pmlv_tbl IN pmlv_tbl_type,
171: x_pmlv_tbl OUT NOCOPY pmlv_tbl_type,
172: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,

Line 175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

171: x_pmlv_tbl OUT NOCOPY pmlv_tbl_type,
172: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_pmlv_tbl IN pmlv_tbl_type,

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

179: p_pmlv_tbl IN pmlv_tbl_type,
180: x_pmlv_tbl OUT NOCOPY pmlv_tbl_type);
181: PROCEDURE delete_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_pmlv_rec IN pmlv_rec_type);

Line 190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_pmlv_rec IN pmlv_rec_type);
188: PROCEDURE delete_row(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_pmlv_tbl IN pmlv_tbl_type,

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

191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_pmlv_tbl IN pmlv_tbl_type,
195: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
196: PROCEDURE delete_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

194: p_pmlv_tbl IN pmlv_tbl_type,
195: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
196: PROCEDURE delete_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_pmlv_tbl IN pmlv_tbl_type);

Line 205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_pmlv_tbl IN pmlv_tbl_type);
203: PROCEDURE validate_row(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_pmlv_rec IN pmlv_rec_type);

Line 212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_pmlv_rec IN pmlv_rec_type);
210: PROCEDURE validate_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_pmlv_tbl IN pmlv_tbl_type,

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

213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_pmlv_tbl IN pmlv_tbl_type,
217: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
218: PROCEDURE validate_row(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221: x_return_status OUT NOCOPY VARCHAR2,

Line 220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

216: p_pmlv_tbl IN pmlv_tbl_type,
217: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
218: PROCEDURE validate_row(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_pmlv_tbl IN pmlv_tbl_type);