DBA Data[Home] [Help]

APPS.OKS_SUBSCR_ELEMS_PVT dependencies on OKS_SUBSCR_ELEMENTS

Line 6: -- OKS_SUBSCR_ELEMENTS_V Record Spec

2: /* $Header: OKSSELES.pls 120.1 2006/09/11 22:37:35 jakuruvi noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_SUBSCR_ELEMENTS_V Record Spec
7: TYPE scev_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,osh_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 12: ,linked_flag OKS_SUBSCR_ELEMENTS_V.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,osh_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,linked_flag OKS_SUBSCR_ELEMENTS_V.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR
13: ,seq_no NUMBER := OKC_API.G_MISS_NUM
14: ,om_interface_date OKS_SUBSCR_ELEMENTS_V.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKS_SUBSCR_ELEMENTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 14: ,om_interface_date OKS_SUBSCR_ELEMENTS_V.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE

10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,linked_flag OKS_SUBSCR_ELEMENTS_V.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR
13: ,seq_no NUMBER := OKC_API.G_MISS_NUM
14: ,om_interface_date OKS_SUBSCR_ELEMENTS_V.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKS_SUBSCR_ELEMENTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,end_date OKS_SUBSCR_ELEMENTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,quantity NUMBER := OKC_API.G_MISS_NUM

Line 16: ,start_date OKS_SUBSCR_ELEMENTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

12: ,linked_flag OKS_SUBSCR_ELEMENTS_V.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR
13: ,seq_no NUMBER := OKC_API.G_MISS_NUM
14: ,om_interface_date OKS_SUBSCR_ELEMENTS_V.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKS_SUBSCR_ELEMENTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,end_date OKS_SUBSCR_ELEMENTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,quantity NUMBER := OKC_API.G_MISS_NUM
19: ,uom_code OKS_SUBSCR_ELEMENTS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,order_header_id NUMBER := OKC_API.G_MISS_NUM

Line 17: ,end_date OKS_SUBSCR_ELEMENTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

13: ,seq_no NUMBER := OKC_API.G_MISS_NUM
14: ,om_interface_date OKS_SUBSCR_ELEMENTS_V.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKS_SUBSCR_ELEMENTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,end_date OKS_SUBSCR_ELEMENTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,quantity NUMBER := OKC_API.G_MISS_NUM
19: ,uom_code OKS_SUBSCR_ELEMENTS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,order_header_id NUMBER := OKC_API.G_MISS_NUM
21: ,order_line_id NUMBER := OKC_API.G_MISS_NUM

Line 19: ,uom_code OKS_SUBSCR_ELEMENTS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,start_date OKS_SUBSCR_ELEMENTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,end_date OKS_SUBSCR_ELEMENTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,quantity NUMBER := OKC_API.G_MISS_NUM
19: ,uom_code OKS_SUBSCR_ELEMENTS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,order_header_id NUMBER := OKC_API.G_MISS_NUM
21: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 24: ,creation_date OKS_SUBSCR_ELEMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

20: ,order_header_id NUMBER := OKC_API.G_MISS_NUM
21: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,created_by NUMBER := OKC_API.G_MISS_NUM
24: ,creation_date OKS_SUBSCR_ELEMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_date OKS_SUBSCR_ELEMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
28: G_MISS_scev_rec scev_rec_type;

Line 26: ,last_update_date OKS_SUBSCR_ELEMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: ,created_by NUMBER := OKC_API.G_MISS_NUM
24: ,creation_date OKS_SUBSCR_ELEMENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_date OKS_SUBSCR_ELEMENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
27: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
28: G_MISS_scev_rec scev_rec_type;
29: TYPE scev_tbl_type IS TABLE OF scev_rec_type
30: INDEX BY BINARY_INTEGER;

Line 31: -- OKS_SUBSCR_ELEMENTS Record Spec

27: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
28: G_MISS_scev_rec scev_rec_type;
29: TYPE scev_tbl_type IS TABLE OF scev_rec_type
30: INDEX BY BINARY_INTEGER;
31: -- OKS_SUBSCR_ELEMENTS Record Spec
32: TYPE sbe_rec_type IS RECORD (
33: id NUMBER := OKC_API.G_MISS_NUM
34: ,osh_id NUMBER := OKC_API.G_MISS_NUM
35: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 37: ,linked_flag OKS_SUBSCR_ELEMENTS.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR

33: id NUMBER := OKC_API.G_MISS_NUM
34: ,osh_id NUMBER := OKC_API.G_MISS_NUM
35: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,linked_flag OKS_SUBSCR_ELEMENTS.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR
38: ,seq_no NUMBER := OKC_API.G_MISS_NUM
39: ,om_interface_date OKS_SUBSCR_ELEMENTS.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,amount NUMBER := OKC_API.G_MISS_NUM
41: ,start_date OKS_SUBSCR_ELEMENTS.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 39: ,om_interface_date OKS_SUBSCR_ELEMENTS.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE

35: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,linked_flag OKS_SUBSCR_ELEMENTS.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR
38: ,seq_no NUMBER := OKC_API.G_MISS_NUM
39: ,om_interface_date OKS_SUBSCR_ELEMENTS.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,amount NUMBER := OKC_API.G_MISS_NUM
41: ,start_date OKS_SUBSCR_ELEMENTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,end_date OKS_SUBSCR_ELEMENTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,quantity NUMBER := OKC_API.G_MISS_NUM

Line 41: ,start_date OKS_SUBSCR_ELEMENTS.START_DATE%TYPE := OKC_API.G_MISS_DATE

37: ,linked_flag OKS_SUBSCR_ELEMENTS.LINKED_FLAG%TYPE := OKC_API.G_MISS_CHAR
38: ,seq_no NUMBER := OKC_API.G_MISS_NUM
39: ,om_interface_date OKS_SUBSCR_ELEMENTS.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,amount NUMBER := OKC_API.G_MISS_NUM
41: ,start_date OKS_SUBSCR_ELEMENTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,end_date OKS_SUBSCR_ELEMENTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,quantity NUMBER := OKC_API.G_MISS_NUM
44: ,uom_code OKS_SUBSCR_ELEMENTS.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,order_header_id NUMBER := OKC_API.G_MISS_NUM

Line 42: ,end_date OKS_SUBSCR_ELEMENTS.END_DATE%TYPE := OKC_API.G_MISS_DATE

38: ,seq_no NUMBER := OKC_API.G_MISS_NUM
39: ,om_interface_date OKS_SUBSCR_ELEMENTS.OM_INTERFACE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,amount NUMBER := OKC_API.G_MISS_NUM
41: ,start_date OKS_SUBSCR_ELEMENTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,end_date OKS_SUBSCR_ELEMENTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,quantity NUMBER := OKC_API.G_MISS_NUM
44: ,uom_code OKS_SUBSCR_ELEMENTS.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,order_header_id NUMBER := OKC_API.G_MISS_NUM
46: ,order_line_id NUMBER := OKC_API.G_MISS_NUM

Line 44: ,uom_code OKS_SUBSCR_ELEMENTS.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR

40: ,amount NUMBER := OKC_API.G_MISS_NUM
41: ,start_date OKS_SUBSCR_ELEMENTS.START_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,end_date OKS_SUBSCR_ELEMENTS.END_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,quantity NUMBER := OKC_API.G_MISS_NUM
44: ,uom_code OKS_SUBSCR_ELEMENTS.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,order_header_id NUMBER := OKC_API.G_MISS_NUM
46: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 49: ,creation_date OKS_SUBSCR_ELEMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

45: ,order_header_id NUMBER := OKC_API.G_MISS_NUM
46: ,order_line_id NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,created_by NUMBER := OKC_API.G_MISS_NUM
49: ,creation_date OKS_SUBSCR_ELEMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
51: ,last_update_date OKS_SUBSCR_ELEMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
53: G_MISS_sbe_rec sbe_rec_type;

Line 51: ,last_update_date OKS_SUBSCR_ELEMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: ,created_by NUMBER := OKC_API.G_MISS_NUM
49: ,creation_date OKS_SUBSCR_ELEMENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
51: ,last_update_date OKS_SUBSCR_ELEMENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
53: G_MISS_sbe_rec sbe_rec_type;
54: TYPE sbe_tbl_type IS TABLE OF sbe_rec_type
55: INDEX BY BINARY_INTEGER;