1 PACKAGE ddr_time_transform_pkg AS
2 /* $Header: ddrttfms.pls 120.0 2008/02/13 07:04:07 vbhave noship $ */
3 PROCEDURE Populate_BSNS_Transformation (
4 p_org_cd IN VARCHAR2,
5 p_start_year IN NUMBER,
6 p_end_year IN NUMBER
7 );
8
9 FUNCTION Add_Day (p_day_code IN VARCHAR2,p_no_of_days IN NUMBER DEFAULT 1)
10 RETURN VARCHAR2;
11
12 FUNCTION Add_Week (p_week_code IN VARCHAR2,p_no_of_weeks IN NUMBER DEFAULT 1)
13 RETURN VARCHAR2;
14
15 FUNCTION Add_Month (p_month_code IN VARCHAR2,p_no_of_months IN NUMBER DEFAULT 1)
16 RETURN VARCHAR2;
17
18 FUNCTION Add_Quarter (p_qtr_code IN VARCHAR2,p_no_of_qtrs IN NUMBER DEFAULT 1)
19 RETURN VARCHAR2;
20
21 END ddr_time_transform_pkg;