DBA Data[Home] [Help]

PACKAGE: APPS.OZF_TIME_API_PVT

Source


1 PACKAGE OZF_TIME_API_PVT AUTHID CURRENT_USER AS
2 /*$Header: ozfvtias.pls 115.2 2004/03/10 01:43:54 mkothari noship $*/
3 
4  TYPE G_PERIOD_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 
6  FUNCTION get_period_start_date(p_time_id         number,
7                                 p_period_type_id  number) RETURN DATE;
8 
9  FUNCTION get_period_end_date(p_time_id         number,
10                               p_period_type_id  number) RETURN DATE;
11 
12  FUNCTION get_period_name(p_time_id         number,
13                           p_period_type_id  number) RETURN VARCHAR2;
14 
15  FUNCTION get_lysp_period_name(p_time_id         number,
16                                p_period_type_id  number) RETURN VARCHAR2;
17 
18  FUNCTION GET_LYSP_ID(p_time_id        number,
19                       p_period_type_id number) RETURN NUMBER;
20 
21  FUNCTION GET_PERIOD_TBL(p_start_date     varchar2,
22                          p_end_date       varchar2,
23                          p_period_type_id number) RETURN G_PERIOD_TBL_TYPE;
24 
25  FUNCTION Is_Quarter_Allowed(p_start_date     DATE,
26                              p_end_date       DATE) RETURN CHAR;
27 
28  FUNCTION Is_Period_Range_Valid (p_start_date     DATE,
29                                  p_end_date       DATE) RETURN CHAR;
30 
31 END OZF_TIME_API_PVT;