[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;