DBA Data[Home] [Help]

APPS.OKS_REPORT_TEMPLATES_PVT dependencies on OKS_REPORT_TEMPLATES_V

Line 6: -- OKS_REPORT_TEMPLATES_V Record Spec

2: /* $Header: OKSRTMPS.pls 120.1.12000000.1 2007/01/16 22:12:34 appldev ship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_REPORT_TEMPLATES_V Record Spec
7: TYPE rtmpv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM

Line 11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR

7: TYPE rtmpv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR

Line 12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR

11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR

12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM

Line 17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR

13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR

14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR

15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

Line 24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_rtmpv_rec rtmpv_rec_type;
28: TYPE rtmpv_tbl_type IS TABLE OF rtmpv_rec_type

Line 41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR

37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR

38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR

39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM