eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_SUBSCR_HDR_PVT dependencies on OKC_API

Line 16: id NUMBER := OKC_API.G_MISS_NUM

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

Line 17: ,name OKS_SUBSCR_HEADER_V.NAME%TYPE := OKC_API.G_MISS_CHAR

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

Line 18: ,description OKS_SUBSCR_HEADER_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

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

Line 19: ,cle_id NUMBER := OKC_API.G_MISS_NUM

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

Line 20: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

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

Line 21: ,instance_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
25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,sfwt_flag OKS_SUBSCR_HEADER_V.SFWT_FLAG%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

Line 23: ,subscription_type OKS_SUBSCR_HEADER_V.SUBSCRIPTION_TYPE%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

Line 24: ,item_type OKS_SUBSCR_HEADER_V.ITEM_TYPE%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

Line 25: ,media_type OKS_SUBSCR_HEADER_V.MEDIA_TYPE%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

Line 26: ,status OKS_SUBSCR_HEADER_V.STATUS%TYPE := OKC_API.G_MISS_CHAR

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

Line 27: ,frequency OKS_SUBSCR_HEADER_V.FREQUENCY%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

Line 28: ,fulfillment_channel OKS_SUBSCR_HEADER_V.FULFILLMENT_CHANNEL%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

Line 29: ,offset 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

Line 30: ,comments OKS_SUBSCR_HEADER_V.COMMENTS%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
34: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 31: ,upg_orig_system_ref OKS_SUBSCR_HEADER_V.UPG_ORIG_SYSTEM_REF%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
35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 32: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM

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

Line 33: ,object_version_number 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

Line 34: ,created_by 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
38: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 35: ,creation_date OKS_SUBSCR_HEADER_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 36: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

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;

Line 37: ,last_update_date OKS_SUBSCR_HEADER_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 38: ,last_update_login 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
42: INDEX BY BINARY_INTEGER;

Line 45: id NUMBER := OKC_API.G_MISS_NUM

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

Line 46: ,cle_id NUMBER := OKC_API.G_MISS_NUM

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

Line 47: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

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

Line 48: ,instance_id NUMBER := OKC_API.G_MISS_NUM

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

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 55: ,offset 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

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 57: ,upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM

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

Line 58: ,object_version_number 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

Line 59: ,created_by NUMBER := OKC_API.G_MISS_NUM

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

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 61: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

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

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 63: ,last_update_login 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
67: ,orig_system_source_code OKS_SUBSCR_HEADER_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

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

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

Line 75: id NUMBER := OKC_API.G_MISS_NUM

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

Line 76: ,name OKS_SUBSCR_HEADER_TL.NAME%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

Line 77: ,description OKS_SUBSCR_HEADER_TL.DESCRIPTION%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

Line 78: ,language OKS_SUBSCR_HEADER_TL.LANGUAGE%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

Line 79: ,source_lang OKS_SUBSCR_HEADER_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR

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

Line 80: ,sfwt_flag OKS_SUBSCR_HEADER_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

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

Line 81: ,comments OKS_SUBSCR_HEADER_TL.COMMENTS%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
85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 82: ,created_by NUMBER := OKC_API.G_MISS_NUM

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

Line 83: ,creation_date OKS_SUBSCR_HEADER_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 84: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

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

Line 85: ,last_update_date OKS_SUBSCR_HEADER_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 86: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

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

Line 93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

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;

Line 94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

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;

Line 96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

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;

Line 97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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;

Line 99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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

Line 100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

Line 101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

Line 102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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:

Line 116: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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:

Line 141: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,

Line 164: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,

Line 188: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,

Line 211: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,

Line 233: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,