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