DBA Data[Home] [Help]

APPS.OKS_PML_PVT dependencies on OKS_PM_STREAM_LEVELS_V

Line 6: -- OKS_PM_STREAM_LEVELS_V Record Spec

2: /* $Header: OKSSPMLS.pls 120.1 2005/07/15 09:25:16 parkumar noship $ */
3: ---------------------------------------------------------------------------
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

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