[Home] [Help]
PACKAGE: APPS.MTH_CALENDAR_PKG
Source
1 PACKAGE MTH_CALENDAR_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthcalrs.pls 120.4.12020000.1 2012/07/24 16:09:45 sasuren noship $*/
3
4 /* ****************************************************************************
5 * Procedure :GENERATE_GREGORIAN_CALENDAR *
6 * Description :... *
7 * File Name :MTHCALRB.PLS *
8 * Visibility :Public *
9 * Parameters :P_START_YEAR - Year from which calendar has to be *
10 * generated *
11 * P_NUM_YEARS - Number of years for generation *
12 ******************************************************************************/
13 PROCEDURE GENERATE_GREGORIAN_CALENDAR (p_err_buff OUT NOCOPY VARCHAR2,
14 p_retcode OUT NOCOPY NUMBER,
15 p_start_year IN NUMBER,
16 p_num_years IN NUMBER);
17
18 /* ****************************************************************************
19 * Function :VALIDATE_GREG_CAL_INPUT_PARAMS *
20 * Description :... *
21 * File Name :MTHCALRB.PLS *
22 * Visibility :Public *
23 * Input Parameters :P_START_YEAR - Year from which calendar has to be *
24 * generated *
25 * P_NUM_YEARS - Number of years for generation *
26 ******************************************************************************/
27 FUNCTION VALIDATE_GREG_CAL_INPUT_PARAMS(P_START_YEAR IN NUMBER,
28 P_NUM_YEARS IN NUMBER) RETURN VARCHAR2;
29
30 /* ****************************************************************************
31 * Function :GET_445_544_YEAR_END *
32 * Description :... *
33 * File Name :MTHCALRB.PLS *
34 * Visibility :Public *
35 * Input Parameters :P_YEAR - Year for which end date has to be calculated*
36 * generated *
37 * P_START_MONTH - Start Month *
38 * P_START_WEEK_DAY - Start Week day *
39 * P_YEAR_END_VARIATION - Year end variation *
40 ******************************************************************************/
41
42 FUNCTION get_445_544_year_end(P_YEAR IN NUMBER, P_START_MONTH IN NUMBER,
43 P_START_WEEK_DAY IN NUMBER , P_YEAR_END_VARIATION IN NUMBER) RETURN DATE;
44
45
46 /* ****************************************************************************
47 * Procedure :Populate_445_cal_denrom *
48 * Description :... *
49 * File Name :MTHCALRB.PLS *
50 * Visibility :Public *
51 * Input Parameters : *
52 * p_err_buff *
53 * p_retcode *
54 * P_START_YEAR - Start year from which calendar needs *
55 * to be generated *
56 * P_NUM_YEARS - Number of years *
57 * P_CAL_TYPE - Calendar type 445 or 544 *
58 * P_START_MONTH - Start Month *
59 * P_START_DAY - Start Week day *
60 * P_YEAR_END_VARIATION - Year end variation *
61 ******************************************************************************/
62
63 PROCEDURE Populate_445_cal_denrom(p_err_buff OUT NOCOPY VARCHAR2,
64 p_retcode OUT NOCOPY NUMBER,
65 P_START_YEAR IN NUMBER, P_NUM_YEARS IN NUMBER,
66 P_CAL_TYPE IN NUMBER, P_START_MONTH IN NUMBER,
67 P_START_DAY IN NUMBER, P_YEAR_END_VARIATION IN NUMBER);
68
69
70 /* ****************************************************************************
71 * Procedure :POPULATE_GREGORIAN_CAL_DENORM *
72 * Description :... *
73 * File Name :MTHCALRB.PLS *
74 * Visibility :Public *
75 * Parameters :P_START_YEAR - Year from which calendar has to be *
76 * generated *
77 * P_NUM_YEARS - Number of years for generation *
78 ******************************************************************************/
79 PROCEDURE POPULATE_GREGORIAN_CAL_DENORM (P_START_YEAR IN NUMBER,
80 P_NUM_YEARS IN NUMBER);
81
82 /* ****************************************************************************
83 * Procedure :POPULATE_HOURS *
84 * Description :... *
85 * File Name :MTHCALRB.PLS *
86 * Visibility :Public *
87 * Parameters : *
88 ******************************************************************************/
89 PROCEDURE POPULATE_HOURS;
90
91
92 /* ****************************************************************************
93 * * Procedure :VALIDATE_CUSTOM_CAL_STG_DATA *
94 * * Description :...
95 * *
96 * * File Name :MTHCALRB.PLS
97 * *
98 * * Visibility :Public
99 * *
100 * * Parameters :
101 * *
102 * ******************************************************************************/
103 PROCEDURE VALIDATE_CUSTOM_CAL_STG_DATA (P_SESSION_NO IN VARCHAR);
104
105
106
107
108 END MTH_CALENDAR_PKG;