2: /* $Header: OKLSREPS.pls 120.0 2007/12/10 17:40:55 dcshanmu noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_REPORTS_V Record Spec
7: TYPE repv_rec_type IS RECORD (
8: report_id NUMBER
9: ,name OKL_REPORTS_V.NAME%TYPE
10: ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
5: ---------------------------------------------------------------------------
6: -- OKL_REPORTS_V Record Spec
7: TYPE repv_rec_type IS RECORD (
8: report_id NUMBER
9: ,name OKL_REPORTS_V.NAME%TYPE
10: ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
11: ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
6: -- OKL_REPORTS_V Record Spec
7: TYPE repv_rec_type IS RECORD (
8: report_id NUMBER
9: ,name OKL_REPORTS_V.NAME%TYPE
10: ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
11: ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
7: TYPE repv_rec_type IS RECORD (
8: report_id NUMBER
9: ,name OKL_REPORTS_V.NAME%TYPE
10: ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
11: ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
8: report_id NUMBER
9: ,name OKL_REPORTS_V.NAME%TYPE
10: ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
11: ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
9: ,name OKL_REPORTS_V.NAME%TYPE
10: ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
11: ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
10: ,chart_of_accounts_id OKL_REPORTS_V.CHART_OF_ACCOUNTS_ID%TYPE
11: ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18: ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
11: ,book_classification_code OKL_REPORTS_V.BOOK_CLASSIFICATION_CODE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18: ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
19: ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
12: ,ledger_id OKL_REPORTS_V.LEDGER_ID%TYPE
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18: ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
19: ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
20: ,created_by NUMBER
13: ,report_category_code OKL_REPORTS_V.REPORT_CATEGORY_CODE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18: ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
19: ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
20: ,created_by NUMBER
21: ,creation_date OKL_REPORTS_V.CREATION_DATE%TYPE
14: ,report_type_code OKL_REPORTS_V.REPORT_TYPE_CODE%TYPE
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18: ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
19: ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
20: ,created_by NUMBER
21: ,creation_date OKL_REPORTS_V.CREATION_DATE%TYPE
22: ,last_updated_by NUMBER
15: ,activity_code OKL_REPORTS_V.ACTIVITY_CODE%TYPE
16: ,status_code OKL_REPORTS_V.STATUS_CODE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18: ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
19: ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
20: ,created_by NUMBER
21: ,creation_date OKL_REPORTS_V.CREATION_DATE%TYPE
22: ,last_updated_by NUMBER
23: ,last_update_date OKL_REPORTS_V.LAST_UPDATE_DATE%TYPE
17: ,description OKL_REPORTS_V.DESCRIPTION%TYPE
18: ,effective_from_date OKL_REPORTS_V.EFFECTIVE_FROM_DATE%TYPE
19: ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
20: ,created_by NUMBER
21: ,creation_date OKL_REPORTS_V.CREATION_DATE%TYPE
22: ,last_updated_by NUMBER
23: ,last_update_date OKL_REPORTS_V.LAST_UPDATE_DATE%TYPE
24: ,last_update_login NUMBER
25: ,language OKL_REPORTS_V.LANGUAGE%TYPE
19: ,effective_to_date OKL_REPORTS_V.EFFECTIVE_TO_DATE%TYPE
20: ,created_by NUMBER
21: ,creation_date OKL_REPORTS_V.CREATION_DATE%TYPE
22: ,last_updated_by NUMBER
23: ,last_update_date OKL_REPORTS_V.LAST_UPDATE_DATE%TYPE
24: ,last_update_login NUMBER
25: ,language OKL_REPORTS_V.LANGUAGE%TYPE
26: ,source_lang OKL_REPORTS_V.SOURCE_LANG%TYPE
27: ,sfwt_flag OKL_REPORTS_V.SFWT_FLAG%TYPE);
21: ,creation_date OKL_REPORTS_V.CREATION_DATE%TYPE
22: ,last_updated_by NUMBER
23: ,last_update_date OKL_REPORTS_V.LAST_UPDATE_DATE%TYPE
24: ,last_update_login NUMBER
25: ,language OKL_REPORTS_V.LANGUAGE%TYPE
26: ,source_lang OKL_REPORTS_V.SOURCE_LANG%TYPE
27: ,sfwt_flag OKL_REPORTS_V.SFWT_FLAG%TYPE);
28: G_MISS_repv_rec repv_rec_type;
29: TYPE repv_tbl_type IS TABLE OF repv_rec_type
22: ,last_updated_by NUMBER
23: ,last_update_date OKL_REPORTS_V.LAST_UPDATE_DATE%TYPE
24: ,last_update_login NUMBER
25: ,language OKL_REPORTS_V.LANGUAGE%TYPE
26: ,source_lang OKL_REPORTS_V.SOURCE_LANG%TYPE
27: ,sfwt_flag OKL_REPORTS_V.SFWT_FLAG%TYPE);
28: G_MISS_repv_rec repv_rec_type;
29: TYPE repv_tbl_type IS TABLE OF repv_rec_type
30: INDEX BY BINARY_INTEGER;
23: ,last_update_date OKL_REPORTS_V.LAST_UPDATE_DATE%TYPE
24: ,last_update_login NUMBER
25: ,language OKL_REPORTS_V.LANGUAGE%TYPE
26: ,source_lang OKL_REPORTS_V.SOURCE_LANG%TYPE
27: ,sfwt_flag OKL_REPORTS_V.SFWT_FLAG%TYPE);
28: G_MISS_repv_rec repv_rec_type;
29: TYPE repv_tbl_type IS TABLE OF repv_rec_type
30: INDEX BY BINARY_INTEGER;
31: -- OKL_REPORTS_B Record Spec