DBA Data[Home] [Help]

APPS.OKS_SUBSCR_HDR_PVT dependencies on OKS_SUBSCR_HEADER_B

Line 43: -- OKS_SUBSCR_HEADER_B Record Spec

39: );
40: G_MISS_schv_rec schv_rec_type;
41: TYPE schv_tbl_type IS TABLE OF schv_rec_type
42: INDEX BY BINARY_INTEGER;
43: -- OKS_SUBSCR_HEADER_B Record Spec
44: TYPE sbh_rec_type IS RECORD (
45: id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 49: ,subscription_type OKS_SUBSCR_HEADER_B.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR

45: id NUMBER := OKC_API.G_MISS_NUM
46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,instance_id NUMBER := OKC_API.G_MISS_NUM
49: ,subscription_type OKS_SUBSCR_HEADER_B.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,item_type OKS_SUBSCR_HEADER_B.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
51: ,media_type OKS_SUBSCR_HEADER_B.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR

Line 50: ,item_type OKS_SUBSCR_HEADER_B.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR

46: ,cle_id NUMBER := OKC_API.G_MISS_NUM
47: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,instance_id NUMBER := OKC_API.G_MISS_NUM
49: ,subscription_type OKS_SUBSCR_HEADER_B.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,item_type OKS_SUBSCR_HEADER_B.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
51: ,media_type OKS_SUBSCR_HEADER_B.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
54: ,fulfillment_channel OKS_SUBSCR_HEADER_B.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR

Line 51: ,media_type OKS_SUBSCR_HEADER_B.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR

47: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
48: ,instance_id NUMBER := OKC_API.G_MISS_NUM
49: ,subscription_type OKS_SUBSCR_HEADER_B.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,item_type OKS_SUBSCR_HEADER_B.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
51: ,media_type OKS_SUBSCR_HEADER_B.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
54: ,fulfillment_channel OKS_SUBSCR_HEADER_B.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
55: ,offset NUMBER := OKC_API.G_MISS_NUM

Line 52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR

48: ,instance_id NUMBER := OKC_API.G_MISS_NUM
49: ,subscription_type OKS_SUBSCR_HEADER_B.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,item_type OKS_SUBSCR_HEADER_B.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
51: ,media_type OKS_SUBSCR_HEADER_B.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
54: ,fulfillment_channel OKS_SUBSCR_HEADER_B.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
55: ,offset NUMBER := OKC_API.G_MISS_NUM
56: ,upg_orig_system_ref OKS_SUBSCR_HEADER_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR

Line 53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR

49: ,subscription_type OKS_SUBSCR_HEADER_B.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: ,item_type OKS_SUBSCR_HEADER_B.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
51: ,media_type OKS_SUBSCR_HEADER_B.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
54: ,fulfillment_channel OKS_SUBSCR_HEADER_B.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
55: ,offset NUMBER := OKC_API.G_MISS_NUM
56: ,upg_orig_system_ref OKS_SUBSCR_HEADER_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
57: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM

Line 54: ,fulfillment_channel OKS_SUBSCR_HEADER_B.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR

50: ,item_type OKS_SUBSCR_HEADER_B.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
51: ,media_type OKS_SUBSCR_HEADER_B.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
54: ,fulfillment_channel OKS_SUBSCR_HEADER_B.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
55: ,offset NUMBER := OKC_API.G_MISS_NUM
56: ,upg_orig_system_ref OKS_SUBSCR_HEADER_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
57: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 56: ,upg_orig_system_ref OKS_SUBSCR_HEADER_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR

52: ,status OKS_SUBSCR_HEADER_B.STATUS%TYPE := OKC_API.G_MISS_CHAR
53: ,frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
54: ,fulfillment_channel OKS_SUBSCR_HEADER_B.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
55: ,offset NUMBER := OKC_API.G_MISS_NUM
56: ,upg_orig_system_ref OKS_SUBSCR_HEADER_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
57: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
59: ,created_by NUMBER := OKC_API.G_MISS_NUM
60: ,creation_date OKS_SUBSCR_HEADER_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 60: ,creation_date OKS_SUBSCR_HEADER_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

56: ,upg_orig_system_ref OKS_SUBSCR_HEADER_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
57: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
58: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
59: ,created_by NUMBER := OKC_API.G_MISS_NUM
60: ,creation_date OKS_SUBSCR_HEADER_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
62: ,last_update_date OKS_SUBSCR_HEADER_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
64: -- R12 Data Model Changes 4485150 Start

Line 62: ,last_update_date OKS_SUBSCR_HEADER_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 66: ,orig_system_reference1 OKS_SUBSCR_HEADER_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

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

Line 67: ,orig_system_source_code OKS_SUBSCR_HEADER_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

63: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
64: -- R12 Data Model Changes 4485150 Start
65: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
66: ,orig_system_reference1 OKS_SUBSCR_HEADER_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
67: ,orig_system_source_code OKS_SUBSCR_HEADER_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
68: -- R12 Data Model Changes 4485150 End
69: );
70: G_MISS_sbh_rec sbh_rec_type;
71: TYPE sbh_tbl_type IS TABLE OF sbh_rec_type