1 PACKAGE ddr_pop_calendar_pkg AS
2 /* $Header: ddrcldrs.pls 120.0 2008/02/13 07:11:11 vbhave noship $ */
3
4 TYPE Number_Tab IS TABLE OF NUMBER INDEX BY VARCHAR2(30);
5
6 PROCEDURE Populate_STND_Calendar (
7 p_no_of_years IN NUMBER,
8 p_start_year IN NUMBER DEFAULT NULL
9 );
10
11 PROCEDURE Populate_BSNS_Calendar (
12 p_org_cd IN VARCHAR2,
13 p_no_of_years IN NUMBER,
14 p_start_date IN DATE DEFAULT NULL,
15 p_five_week_month_list IN VARCHAR2,
16 p_special_year_list IN VARCHAR2,
17 p_extra_week_month IN VARCHAR2
18 );
19
20 PROCEDURE Populate_FSCL_Calendar (
21 p_org_cd IN VARCHAR2,
22 p_no_of_years IN NUMBER,
23 p_start_year_month IN NUMBER DEFAULT NULL
24 );
25
26 PROCEDURE Populate_ADVR_Calendar (
27 p_org_cd IN VARCHAR2,
28 p_no_of_years IN NUMBER,
29 p_start_date IN DATE DEFAULT NULL,
30 p_period_dist_list IN VARCHAR2,
31 p_week_dist_list IN VARCHAR2,
32 p_special_year_list IN VARCHAR2,
33 p_extra_week_period IN VARCHAR2
34 );
35
36 PROCEDURE Populate_PLNG_Calendar (
37 p_org_cd IN VARCHAR2,
38 p_no_of_years IN NUMBER,
39 p_start_date IN DATE DEFAULT NULL,
40 p_period_dist_list IN VARCHAR2,
41 p_week_dist_list IN VARCHAR2,
42 p_special_year_list IN VARCHAR2,
43 p_extra_week_period IN VARCHAR2
44 );
45
46 END ddr_pop_calendar_pkg;