1 PACKAGE MSD_TRANSLATE_TIME_DATA AUTHID CURRENT_USER AS
2 /* $Header: msdttims.pls 115.8 2002/12/03 21:14:53 pinamati ship $ */
3
4
5 procedure Explode_Fiscal_Dates(
6 errbuf OUT nocopy VARCHAR2,
7 retcode OUT nocopy VARCHAR2,
8 p_dest_table IN VARCHAR2,
9 p_instance_id IN NUMBER,
10 p_calendar_type_id IN NUMBER,
11 p_calendar_code IN VARCHAR2,
12 p_seq_num IN NUMBER,
13 p_year IN VARCHAR2,
14 p_year_description IN VARCHAR2,
15 p_year_start_date IN DATE,
16 p_year_end_date IN DATE,
17 p_quarter IN VARCHAR2,
18 p_quarter_description IN VARCHAR2,
19 p_quarter_start_date IN DATE,
20 p_quarter_end_date IN DATE,
21 p_month IN VARCHAR2,
22 p_month_description IN VARCHAR2,
23 p_month_start_date IN DATE,
24 p_month_end_date IN DATE,
25 p_from_date IN DATE,
26 p_to_date IN DATE) ;
27
28
29 procedure translate_time_data(
30 errbuf OUT nocopy VARCHAR2,
31 retcode OUT nocopy VARCHAR2,
32 p_source_table IN VARCHAR2,
33 p_dest_table IN VARCHAR2,
34 p_instance_id IN NUMBER,
35 p_calendar_type_id IN NUMBER,
36 p_calendar_code IN VARCHAR2,
37 p_from_date IN DATE,
38 p_to_date IN DATE) ;
39
40 procedure Generate_Gregorian(
41 errbuf OUT nocopy VARCHAR2,
42 retcode OUT nocopy VARCHAR2,
43 p_calendar_code IN VARCHAR2,
44 p_from_date IN DATE,
45 p_to_date IN DATE ) ;
46
47 procedure fix_manufacturing(errbuf out nocopy varchar2,
48 retcode out nocopy varchar2,
49 p_cal_code in varchar2);
50
51 END MSD_TRANSLATE_TIME_DATA ;