[Home] [Help]
PACKAGE: APPS.OKC_TIME_UTIL_PUB
Source
1 PACKAGE OKC_TIME_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPTULS.pls 120.0 2005/05/26 09:51:21 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- Procedures and Functions
5 ---------------------------------------------------------------------------
6 ---------------------------------------------------------------------------
7 -- GLOBAL VARIABLES
8 ---------------------------------------------------------------------------
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10 G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'SQLcode';
12 G_DATE_ERROR CONSTANT varchar2(200) := 'Start Date > End Date';
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TIME_UTIL_PUB';
15 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
17
18 ----------------------------------------------------------------------------
19 -- The following procedure derives the most suitable period and duration based
20 -- on a start and end date.
21 ----------------------------------------------------------------------------
22
23 PROCEDURE get_duration(
24 p_start_date in date,
25 p_end_date in date,
26 x_duration out nocopy number,
27 x_timeunit out nocopy varchar2,
28 x_return_status out nocopy varchar2);
29
30 ----------------------------------------------------------------------------
31 -- The following function returns the end date based on a start,duration and
32 -- period.
33 ----------------------------------------------------------------------------
34 FUNCTION get_enddate(
35 p_start_date in date,
36 p_timeunit varchar2,
37 p_duration number)
38 return date ;
39 ----------------------------------------------------------------------------
40 ----------------------------------------------------------------------------
41 -- The following section deals with handling of tve related rules
42 ----------------------------------------------------------------------------
43
44 SUBTYPE col_val_rec is OKC_TIME_UTIL_PVT.col_val_rec;
45 SUBTYPE t_col_vals is OKC_TIME_UTIL_PVT.t_col_vals;
46
47 FUNCTION get_app_id
48 return NUMBER;
49
50 -- /striping/
51 FUNCTION get_app_id(rule_code in varchar2)
52 return NUMBER;
53
54 FUNCTION get_rule_df_name
55 return varchar2;
56
57 -- /striping/
58 FUNCTION get_rule_df_name(rule_code in varchar2)
59 return varchar2;
60
61 FUNCTION get_rule_defs_using_vs(
62 p_app_id IN NUMBER,
63 p_dff_name IN VARCHAR2,
64 p_fvs_name IN VARCHAR2)
65 return varchar2;
66
67 PROCEDURE get_dff_column_values (
68 p_app_id IN NUMBER,
69 p_dff_name IN VARCHAR2,
70 p_rdf_code IN VARCHAR2,
71 p_fvs_name IN VARCHAR2,
72 p_rule_id IN NUMBER,
73 p_col_vals OUT NOCOPY t_col_vals,
74 p_no_of_cols OUT NOCOPY NUMBER
75 );
76
77 FUNCTION get_tve_ids (
78 p_app_id IN NUMBER,
79 p_dff_name IN VARCHAR2,
80 p_rdf_code IN VARCHAR2,
81 p_fvs_name IN VARCHAR2,
82 p_rule_id IN NUMBER)
83 return varchar2;
84
85 END OKC_TIME_UTIL_PUB;