PACKAGE: APPS.ISC_FS_TASK_BAC_AGE_ETL_PKG

Source

1 package isc_fs_task_bac_age_etl_pkg
2 /* $Header: iscfsbacageetls.pls 120.1 2005/10/18 19:19:45 kreardon noship $ */
3 as
4 
5   type t_period_bit_rec is record (curr number, prior_period number, prior_year number);
6   type t_period_bit_tbl is table of t_period_bit_rec index by varchar2(10);
7 
8   G_WTD      constant number := power(2, 1);
9   G_WTD_PP   constant number := power(2, 5);
10   G_WTD_PY   constant number := power(2, 9);
11 
12   G_MTD      constant number := power(2, 2);
13   G_MTD_PP   constant number := power(2, 6);
14   G_MTD_PY   constant number := power(2, 10);
15 
16   G_QTD      constant number := power(2, 3);
17   G_QTD_PP   constant number := power(2, 7);
18   G_QTD_PY   constant number := power(2, 11);
19 
20   G_YTD      constant number := power(2, 4);
21   G_YTD_PP   constant number := power(2, 8);
22   G_YTD_PY   constant number := power(2, 12);
23 
24   G_DAY      constant number := power(2, 13);
25   G_DAY_PP   constant number := power(2, 14);
26   G_DAY_PY   constant number := power(2, 15);
27 
28 procedure initial_load
29 ( errbuf out nocopy varchar2
30 , retcode out nocopy number
31 );
32 
33 procedure incremental_load
34 ( errbuf out nocopy varchar2
35 , retcode out nocopy number
36 );
37 
38 function get_period_bit_tbl
39 return t_period_bit_tbl;
40 
41 end isc_fs_task_bac_age_etl_pkg;