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 OKS_SUBSCR_HEADER_V

Line 9: OKS_SUBSCR_HEADER_V: columns not added in the excel sheet

5: ---------------------------------------------------------------------------
6: /**mchoudha**/
7: /*
8:
9: OKS_SUBSCR_HEADER_V: columns not added in the excel sheet
10: */
11: /**mchoudha**/
12:
13:

Line 14: -- OKS_SUBSCR_HEADER_V Record Spec

10: */
11: /**mchoudha**/
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

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