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

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;

Line 27: -- OKS_SUBSCR_PATTERNS Record Spec

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;
27: -- OKS_SUBSCR_PATTERNS Record Spec
28: TYPE sbp_rec_type IS RECORD (
29: id NUMBER := OKC_API.G_MISS_NUM
30: ,osh_id NUMBER := OKC_API.G_MISS_NUM
31: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

Line 34: ,year OKS_SUBSCR_PATTERNS.YEAR%TYPE := OKC_API.G_MISS_CHAR

30: ,osh_id NUMBER := OKC_API.G_MISS_NUM
31: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
33: ,seq_no NUMBER := OKC_API.G_MISS_NUM
34: ,year OKS_SUBSCR_PATTERNS.YEAR%TYPE := OKC_API.G_MISS_CHAR
35: ,month OKS_SUBSCR_PATTERNS.MONTH%TYPE := OKC_API.G_MISS_CHAR
36: ,week OKS_SUBSCR_PATTERNS.WEEK%TYPE := OKC_API.G_MISS_CHAR
37: ,week_day OKS_SUBSCR_PATTERNS.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
38: ,day OKS_SUBSCR_PATTERNS.DAY%TYPE := OKC_API.G_MISS_CHAR

Line 35: ,month OKS_SUBSCR_PATTERNS.MONTH%TYPE := OKC_API.G_MISS_CHAR

31: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
32: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
33: ,seq_no NUMBER := OKC_API.G_MISS_NUM
34: ,year OKS_SUBSCR_PATTERNS.YEAR%TYPE := OKC_API.G_MISS_CHAR
35: ,month OKS_SUBSCR_PATTERNS.MONTH%TYPE := OKC_API.G_MISS_CHAR
36: ,week OKS_SUBSCR_PATTERNS.WEEK%TYPE := OKC_API.G_MISS_CHAR
37: ,week_day OKS_SUBSCR_PATTERNS.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
38: ,day OKS_SUBSCR_PATTERNS.DAY%TYPE := OKC_API.G_MISS_CHAR
39: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 36: ,week OKS_SUBSCR_PATTERNS.WEEK%TYPE := OKC_API.G_MISS_CHAR

32: ,dnz_cle_id NUMBER := OKC_API.G_MISS_NUM
33: ,seq_no NUMBER := OKC_API.G_MISS_NUM
34: ,year OKS_SUBSCR_PATTERNS.YEAR%TYPE := OKC_API.G_MISS_CHAR
35: ,month OKS_SUBSCR_PATTERNS.MONTH%TYPE := OKC_API.G_MISS_CHAR
36: ,week OKS_SUBSCR_PATTERNS.WEEK%TYPE := OKC_API.G_MISS_CHAR
37: ,week_day OKS_SUBSCR_PATTERNS.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
38: ,day OKS_SUBSCR_PATTERNS.DAY%TYPE := OKC_API.G_MISS_CHAR
39: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
40: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 37: ,week_day OKS_SUBSCR_PATTERNS.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR

33: ,seq_no NUMBER := OKC_API.G_MISS_NUM
34: ,year OKS_SUBSCR_PATTERNS.YEAR%TYPE := OKC_API.G_MISS_CHAR
35: ,month OKS_SUBSCR_PATTERNS.MONTH%TYPE := OKC_API.G_MISS_CHAR
36: ,week OKS_SUBSCR_PATTERNS.WEEK%TYPE := OKC_API.G_MISS_CHAR
37: ,week_day OKS_SUBSCR_PATTERNS.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
38: ,day OKS_SUBSCR_PATTERNS.DAY%TYPE := OKC_API.G_MISS_CHAR
39: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date OKS_SUBSCR_PATTERNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 38: ,day OKS_SUBSCR_PATTERNS.DAY%TYPE := OKC_API.G_MISS_CHAR

34: ,year OKS_SUBSCR_PATTERNS.YEAR%TYPE := OKC_API.G_MISS_CHAR
35: ,month OKS_SUBSCR_PATTERNS.MONTH%TYPE := OKC_API.G_MISS_CHAR
36: ,week OKS_SUBSCR_PATTERNS.WEEK%TYPE := OKC_API.G_MISS_CHAR
37: ,week_day OKS_SUBSCR_PATTERNS.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
38: ,day OKS_SUBSCR_PATTERNS.DAY%TYPE := OKC_API.G_MISS_CHAR
39: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date OKS_SUBSCR_PATTERNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 41: ,creation_date OKS_SUBSCR_PATTERNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

37: ,week_day OKS_SUBSCR_PATTERNS.WEEK_DAY%TYPE := OKC_API.G_MISS_CHAR
38: ,day OKS_SUBSCR_PATTERNS.DAY%TYPE := OKC_API.G_MISS_CHAR
39: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date OKS_SUBSCR_PATTERNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_SUBSCR_PATTERNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_sbp_rec sbp_rec_type;

Line 43: ,last_update_date OKS_SUBSCR_PATTERNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

39: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
40: ,created_by NUMBER := OKC_API.G_MISS_NUM
41: ,creation_date OKS_SUBSCR_PATTERNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
42: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
43: ,last_update_date OKS_SUBSCR_PATTERNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
45: G_MISS_sbp_rec sbp_rec_type;
46: TYPE sbp_tbl_type IS TABLE OF sbp_rec_type
47: INDEX BY BINARY_INTEGER;