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_PTRNS_PVT dependencies on OKS_SUBSCR_PATTERNS_V

Line 6: -- OKS_SUBSCR_PATTERNS_V Record Spec

2: /* $Header: OKSSPTRS.pls 120.1 2006/09/11 22:38:37 jakuruvi noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_SUBSCR_PATTERNS_V Record Spec
7: TYPE scpv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,osh_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 13: ,year OKS_SUBSCR_PATTERNS_V.YEAR%TYPE := OKC_API.G_MISS_CHAR

9: ,osh_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,seq_no NUMBER := OKC_API.G_MISS_NUM
13: ,year OKS_SUBSCR_PATTERNS_V.YEAR%TYPE := OKC_API.G_MISS_CHAR
14: ,month OKS_SUBSCR_PATTERNS_V.MONTH%TYPE := OKC_API.G_MISS_CHAR
15: ,week OKS_SUBSCR_PATTERNS_V.WEEK%TYPE := OKC_API.G_MISS_CHAR
16: ,week_day OKS_SUBSCR_PATTERNS_V.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
17: ,day OKS_SUBSCR_PATTERNS_V.DAY%TYPE := OKC_API.G_MISS_CHAR

Line 14: ,month OKS_SUBSCR_PATTERNS_V.MONTH%TYPE := OKC_API.G_MISS_CHAR

10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,seq_no NUMBER := OKC_API.G_MISS_NUM
13: ,year OKS_SUBSCR_PATTERNS_V.YEAR%TYPE := OKC_API.G_MISS_CHAR
14: ,month OKS_SUBSCR_PATTERNS_V.MONTH%TYPE := OKC_API.G_MISS_CHAR
15: ,week OKS_SUBSCR_PATTERNS_V.WEEK%TYPE := OKC_API.G_MISS_CHAR
16: ,week_day OKS_SUBSCR_PATTERNS_V.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
17: ,day OKS_SUBSCR_PATTERNS_V.DAY%TYPE := OKC_API.G_MISS_CHAR
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 15: ,week OKS_SUBSCR_PATTERNS_V.WEEK%TYPE := OKC_API.G_MISS_CHAR

11: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
12: ,seq_no NUMBER := OKC_API.G_MISS_NUM
13: ,year OKS_SUBSCR_PATTERNS_V.YEAR%TYPE := OKC_API.G_MISS_CHAR
14: ,month OKS_SUBSCR_PATTERNS_V.MONTH%TYPE := OKC_API.G_MISS_CHAR
15: ,week OKS_SUBSCR_PATTERNS_V.WEEK%TYPE := OKC_API.G_MISS_CHAR
16: ,week_day OKS_SUBSCR_PATTERNS_V.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
17: ,day OKS_SUBSCR_PATTERNS_V.DAY%TYPE := OKC_API.G_MISS_CHAR
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 16: ,week_day OKS_SUBSCR_PATTERNS_V.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR

12: ,seq_no NUMBER := OKC_API.G_MISS_NUM
13: ,year OKS_SUBSCR_PATTERNS_V.YEAR%TYPE := OKC_API.G_MISS_CHAR
14: ,month OKS_SUBSCR_PATTERNS_V.MONTH%TYPE := OKC_API.G_MISS_CHAR
15: ,week OKS_SUBSCR_PATTERNS_V.WEEK%TYPE := OKC_API.G_MISS_CHAR
16: ,week_day OKS_SUBSCR_PATTERNS_V.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
17: ,day OKS_SUBSCR_PATTERNS_V.DAY%TYPE := OKC_API.G_MISS_CHAR
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_SUBSCR_PATTERNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 17: ,day OKS_SUBSCR_PATTERNS_V.DAY%TYPE := OKC_API.G_MISS_CHAR

13: ,year OKS_SUBSCR_PATTERNS_V.YEAR%TYPE := OKC_API.G_MISS_CHAR
14: ,month OKS_SUBSCR_PATTERNS_V.MONTH%TYPE := OKC_API.G_MISS_CHAR
15: ,week OKS_SUBSCR_PATTERNS_V.WEEK%TYPE := OKC_API.G_MISS_CHAR
16: ,week_day OKS_SUBSCR_PATTERNS_V.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
17: ,day OKS_SUBSCR_PATTERNS_V.DAY%TYPE := OKC_API.G_MISS_CHAR
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_SUBSCR_PATTERNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 20: ,creation_date OKS_SUBSCR_PATTERNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

16: ,week_day OKS_SUBSCR_PATTERNS_V.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
17: ,day OKS_SUBSCR_PATTERNS_V.DAY%TYPE := OKC_API.G_MISS_CHAR
18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_SUBSCR_PATTERNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_SUBSCR_PATTERNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
24: G_MISS_scpv_rec scpv_rec_type;

Line 22: ,last_update_date OKS_SUBSCR_PATTERNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

18: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19: ,created_by NUMBER := OKC_API.G_MISS_NUM
20: ,creation_date OKS_SUBSCR_PATTERNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
22: ,last_update_date OKS_SUBSCR_PATTERNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
24: G_MISS_scpv_rec scpv_rec_type;
25: TYPE scpv_tbl_type IS TABLE OF scpv_rec_type
26: INDEX BY BINARY_INTEGER;