PACKAGE: APPS.HRI_OLTP_PMV_QUERY_TIME

Source

1 PACKAGE HRI_OLTP_PMV_QUERY_TIME AS
2 /* $Header: hriopqtm.pkh 120.0 2005/05/29 07:34:12 appldev noship $ */
3 
4 PROCEDURE GET_TIME_CLAUSE
5           (p_projection_type     VARCHAR2 DEFAULT 'N'
6           ,p_page_period_type    VARCHAR2
7           ,p_page_comp_type      VARCHAR2
8           ,o_trend_table         OUT NOCOPY VARCHAR2
9           ,o_previous_periods    OUT NOCOPY VARCHAR2
10           ,o_projection_periods  OUT NOCOPY VARCHAR2);
11 
12 FUNCTION get_time_clause
13           (p_past_trend   IN VARCHAR2 DEFAULT 'Y',
14            p_future_trend IN VARCHAR2 DEFAULT 'N')
15          RETURN VARCHAR2;
16 
17 PROCEDURE get_period_binds
18           (p_projection_type     VARCHAR2 DEFAULT 'N'
19           ,p_page_period_type    VARCHAR2
20           ,p_page_comp_type      VARCHAR2
21           ,o_previous_periods    OUT NOCOPY NUMBER
22           ,o_projection_periods  OUT NOCOPY NUMBER);
23 
24 END HRI_OLTP_PMV_QUERY_TIME;