DBA Data[Home] [Help]

APPS.OKL_RPP_PVT dependencies on OKL_REPORT_PARAMETERS

Line 6: -- OKL_REPORT_PARAMETERS Record Spec

2: /* $Header: OKLSRPPS.pls 120.1 2007/12/31 11:07:22 dcshanmu noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_REPORT_PARAMETERS Record Spec
7: TYPE rpp_rec_type IS RECORD (
8: parameter_id NUMBER
9: ,report_id NUMBER
10: ,parameter_type OKL_REPORT_PARAMETERS.PARAMETER_TYPE_CODE%TYPE

Line 10: ,parameter_type OKL_REPORT_PARAMETERS.PARAMETER_TYPE_CODE%TYPE

6: -- OKL_REPORT_PARAMETERS Record Spec
7: TYPE rpp_rec_type IS RECORD (
8: parameter_id NUMBER
9: ,report_id NUMBER
10: ,parameter_type OKL_REPORT_PARAMETERS.PARAMETER_TYPE_CODE%TYPE
11: ,param_num_value1 NUMBER
12: ,param_char_value1 OKL_REPORT_PARAMETERS.PARAM_CHAR_VALUE1%TYPE
13: ,param_date_value1 OKL_REPORT_PARAMETERS.PARAM_DATE_VALUE1%TYPE
14: ,created_by NUMBER

Line 12: ,param_char_value1 OKL_REPORT_PARAMETERS.PARAM_CHAR_VALUE1%TYPE

8: parameter_id NUMBER
9: ,report_id NUMBER
10: ,parameter_type OKL_REPORT_PARAMETERS.PARAMETER_TYPE_CODE%TYPE
11: ,param_num_value1 NUMBER
12: ,param_char_value1 OKL_REPORT_PARAMETERS.PARAM_CHAR_VALUE1%TYPE
13: ,param_date_value1 OKL_REPORT_PARAMETERS.PARAM_DATE_VALUE1%TYPE
14: ,created_by NUMBER
15: ,source_table OKL_REPORT_PARAMETERS.SOURCE_TABLE%TYPE
16: ,creation_date OKL_REPORT_PARAMETERS.CREATION_DATE%TYPE

Line 13: ,param_date_value1 OKL_REPORT_PARAMETERS.PARAM_DATE_VALUE1%TYPE

9: ,report_id NUMBER
10: ,parameter_type OKL_REPORT_PARAMETERS.PARAMETER_TYPE_CODE%TYPE
11: ,param_num_value1 NUMBER
12: ,param_char_value1 OKL_REPORT_PARAMETERS.PARAM_CHAR_VALUE1%TYPE
13: ,param_date_value1 OKL_REPORT_PARAMETERS.PARAM_DATE_VALUE1%TYPE
14: ,created_by NUMBER
15: ,source_table OKL_REPORT_PARAMETERS.SOURCE_TABLE%TYPE
16: ,creation_date OKL_REPORT_PARAMETERS.CREATION_DATE%TYPE
17: ,last_updated_by NUMBER

Line 15: ,source_table OKL_REPORT_PARAMETERS.SOURCE_TABLE%TYPE

11: ,param_num_value1 NUMBER
12: ,param_char_value1 OKL_REPORT_PARAMETERS.PARAM_CHAR_VALUE1%TYPE
13: ,param_date_value1 OKL_REPORT_PARAMETERS.PARAM_DATE_VALUE1%TYPE
14: ,created_by NUMBER
15: ,source_table OKL_REPORT_PARAMETERS.SOURCE_TABLE%TYPE
16: ,creation_date OKL_REPORT_PARAMETERS.CREATION_DATE%TYPE
17: ,last_updated_by NUMBER
18: ,last_update_date OKL_REPORT_PARAMETERS.LAST_UPDATE_DATE%TYPE
19: ,last_update_login NUMBER);

Line 16: ,creation_date OKL_REPORT_PARAMETERS.CREATION_DATE%TYPE

12: ,param_char_value1 OKL_REPORT_PARAMETERS.PARAM_CHAR_VALUE1%TYPE
13: ,param_date_value1 OKL_REPORT_PARAMETERS.PARAM_DATE_VALUE1%TYPE
14: ,created_by NUMBER
15: ,source_table OKL_REPORT_PARAMETERS.SOURCE_TABLE%TYPE
16: ,creation_date OKL_REPORT_PARAMETERS.CREATION_DATE%TYPE
17: ,last_updated_by NUMBER
18: ,last_update_date OKL_REPORT_PARAMETERS.LAST_UPDATE_DATE%TYPE
19: ,last_update_login NUMBER);
20: G_MISS_rpp_rec rpp_rec_type;

Line 18: ,last_update_date OKL_REPORT_PARAMETERS.LAST_UPDATE_DATE%TYPE

14: ,created_by NUMBER
15: ,source_table OKL_REPORT_PARAMETERS.SOURCE_TABLE%TYPE
16: ,creation_date OKL_REPORT_PARAMETERS.CREATION_DATE%TYPE
17: ,last_updated_by NUMBER
18: ,last_update_date OKL_REPORT_PARAMETERS.LAST_UPDATE_DATE%TYPE
19: ,last_update_login NUMBER);
20: G_MISS_rpp_rec rpp_rec_type;
21: TYPE rpp_tbl_type IS TABLE OF rpp_rec_type
22: INDEX BY BINARY_INTEGER;