12:
13:
14: -- OKS_SUBSCR_HEADER_V Record Spec
15: TYPE schv_rec_type IS RECORD (
16: id NUMBER := OKC_API.G_MISS_NUM
17: ,name OKS_SUBSCR_HEADER_V.NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13:
14: -- OKS_SUBSCR_HEADER_V Record Spec
15: TYPE schv_rec_type IS RECORD (
16: id NUMBER := OKC_API.G_MISS_NUM
17: ,name OKS_SUBSCR_HEADER_V.NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
14: -- OKS_SUBSCR_HEADER_V Record Spec
15: TYPE schv_rec_type IS RECORD (
16: id NUMBER := OKC_API.G_MISS_NUM
17: ,name OKS_SUBSCR_HEADER_V.NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
15: TYPE schv_rec_type IS RECORD (
16: id NUMBER := OKC_API.G_MISS_NUM
17: ,name OKS_SUBSCR_HEADER_V.NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
16: id NUMBER := OKC_API.G_MISS_NUM
17: ,name OKS_SUBSCR_HEADER_V.NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
17: ,name OKS_SUBSCR_HEADER_V.NAME%TYPE := OKC_API.G_MISS_CHAR
18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
19: ,cle_id NUMBER := OKC_API.G_MISS_NUM
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
21: ,instance_id NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%TYPE := OKC_API.G_MISS_CHAR
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%TYPE := OKC_API.G_MISS_CHAR
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
29: ,offset NUMBER := OKC_API.G_MISS_NUM
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,last_update_date OKS_SUBSCR_HEADER_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,last_update_date OKS_SUBSCR_HEADER_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,last_update_date OKS_SUBSCR_HEADER_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
39: );
32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,last_update_date OKS_SUBSCR_HEADER_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
39: );
40: G_MISS_schv_rec schv_rec_type;
33: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,last_update_date OKS_SUBSCR_HEADER_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
39: );
40: G_MISS_schv_rec schv_rec_type;
41: TYPE schv_tbl_type IS TABLE OF schv_rec_type
34: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,last_update_date OKS_SUBSCR_HEADER_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
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;
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
48: ,instance_id NUMBER := OKC_API.G_MISS_NUM
49: ,subscription_type OKS_SUBSCR_HEADER_B.SUBSCRIPTION_TYPE%TYPE := OKC_API.G_MISS_CHAR
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
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
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
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
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
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
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
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
59: ,created_by 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
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
61: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
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
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
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
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
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
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
65: ,orig_system_id1 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
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
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
67: ,orig_system_source_code OKS_SUBSCR_HEADER_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
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
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: );
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
71: TYPE sbh_tbl_type IS TABLE OF sbh_rec_type
72: INDEX BY BINARY_INTEGER;
73: -- OKS_SUBSCR_HEADER_TL Record Spec
74: TYPE oks_subscr_header_tl_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,name OKS_SUBSCR_HEADER_TL.NAME%TYPE := OKC_API.G_MISS_CHAR
77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
72: INDEX BY BINARY_INTEGER;
73: -- OKS_SUBSCR_HEADER_TL Record Spec
74: TYPE oks_subscr_header_tl_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,name OKS_SUBSCR_HEADER_TL.NAME%TYPE := OKC_API.G_MISS_CHAR
77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
73: -- OKS_SUBSCR_HEADER_TL Record Spec
74: TYPE oks_subscr_header_tl_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,name OKS_SUBSCR_HEADER_TL.NAME%TYPE := OKC_API.G_MISS_CHAR
77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
74: TYPE oks_subscr_header_tl_rec_type IS RECORD (
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,name OKS_SUBSCR_HEADER_TL.NAME%TYPE := OKC_API.G_MISS_CHAR
77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: id NUMBER := OKC_API.G_MISS_NUM
76: ,name OKS_SUBSCR_HEADER_TL.NAME%TYPE := OKC_API.G_MISS_CHAR
77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,name OKS_SUBSCR_HEADER_TL.NAME%TYPE := OKC_API.G_MISS_CHAR
77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: GMissOksSubscrHeaderTlRec oks_subscr_header_tl_rec_type;
80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: GMissOksSubscrHeaderTlRec oks_subscr_header_tl_rec_type;
88: TYPE oks_subscr_header_tl_tbl_type IS TABLE OF oks_subscr_header_tl_rec_type
81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: GMissOksSubscrHeaderTlRec oks_subscr_header_tl_rec_type;
88: TYPE oks_subscr_header_tl_tbl_type IS TABLE OF oks_subscr_header_tl_rec_type
89: INDEX BY BINARY_INTEGER;
82: ,created_by NUMBER := OKC_API.G_MISS_NUM
83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: GMissOksSubscrHeaderTlRec oks_subscr_header_tl_rec_type;
88: TYPE oks_subscr_header_tl_tbl_type IS TABLE OF oks_subscr_header_tl_rec_type
89: INDEX BY BINARY_INTEGER;
90: ---------------------------------------------------------------------------
89: INDEX BY BINARY_INTEGER;
90: ---------------------------------------------------------------------------
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
90: ---------------------------------------------------------------------------
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
104: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
104: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
105: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
104: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
105: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
106:
112: ---------------------------------------------------------------------------
113: -- GLOBAL VARIABLES
114: ---------------------------------------------------------------------------
115: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_SUBSCR_HDR_PVT';
116: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
117: ---------------------------------------------------------------------------
118: -- Procedures and Functions
119: ---------------------------------------------------------------------------
120:
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_schv_tbl IN schv_tbl_type,
140: x_schv_tbl OUT NOCOPY schv_tbl_type,
141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
142: PROCEDURE insert_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2,
145: x_return_status OUT NOCOPY VARCHAR2,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_schv_tbl IN schv_tbl_type,
164: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
165: PROCEDURE lock_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2,
168: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_schv_tbl IN schv_tbl_type,
187: x_schv_tbl OUT NOCOPY schv_tbl_type,
188: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
189: PROCEDURE update_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2,
192: x_return_status OUT NOCOPY VARCHAR2,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_schv_tbl IN schv_tbl_type,
211: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
212: PROCEDURE delete_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2,
215: x_return_status OUT NOCOPY VARCHAR2,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_schv_tbl IN schv_tbl_type,
233: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
234: PROCEDURE validate_row(
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2,
237: x_return_status OUT NOCOPY VARCHAR2,