[Home] [Help]
PACKAGE: APPS.OKS_TIME_MEASURES_PUB
Source
1 package OKS_TIME_MEASURES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSSTQTS.pls 120.2 2005/07/07 01:53:36 jvorugan noship $ */
3
4 -----------------------------------------------------------------------------
5
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7 G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'SQLerrm';
8 G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'SQLcode';
9 G_DATE_ERROR CONSTANT varchar2(200) := 'OKC_INVALID_START_END_DATES';
10 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TIME_UTIL_PVT';
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14
15
16
17 -----------------------------------------------------------------------------
18
19 function get_target_qty (p_start_date IN DATE DEFAULT NULL,
20 p_source_qty IN NUMBER,
21 p_source_uom IN VARCHAR2,
22 p_target_uom IN VARCHAR2,
23 p_round_dec IN NUMBER)
24 return NUMBER;
25
26 function get_target_qty_cal(p_start_date IN DATE,
27 p_end_date IN DATE,
28 p_price_uom IN VARCHAR2,
29 p_period_type IN VARCHAR2,
30 p_round_dec IN NUMBER)
31
32 return NUMBER;
33
34 function get_target_qty_service(p_start_date IN DATE,
35 p_end_date IN DATE,
36 p_price_uom IN VARCHAR2,
37 p_period_type IN VARCHAR2,
38 p_round_dec IN NUMBER)
39
40 return NUMBER;
41
42 function get_partial_period_duration (p_start_date IN DATE,
43 p_end_date IN DATE,
44 p_price_uom IN VARCHAR2,
45 p_period_type IN VARCHAR2,
46 p_period_start IN VARCHAR2)
47
48 return NUMBER;
49
50 PROCEDURE get_full_periods (p_start_date IN DATE,
51 p_end_date IN DATE,
52 p_price_uom IN VARCHAR2,
53 x_full_periods OUT NOCOPY NUMBER,
54 x_full_period_end_date OUT NOCOPY DATE,
55 x_return_status OUT NOCOPY VARCHAR2);
56
57 function get_con_factor(p_source_uom IN VARCHAR2,
58 p_target_uom IN VARCHAR2)
59 return NUMBER;
60
61
62 function get_qty_for_days(p_no_days IN NUMBER,
63 p_target_uom IN VARCHAR2)
64 return NUMBER;
65
66
67 function get_quantity(p_start_date IN DATE,
68 p_end_date IN DATE,
69 p_source_uom IN VARCHAR2 DEFAULT NULL,
70 p_period_type IN VARCHAR2 DEFAULT NULL,
71 p_period_start IN VARCHAR2 DEFAULT NULL)
72 return NUMBER;
73
74 function get_uom_code(p_tce_code IN VARCHAR2
75 ,p_quantity IN NUMBER)
76 return VARCHAR2;
77
78 procedure get_duration_uom ( p_start_date IN DATE
79 , p_end_date IN DATE
80 , x_duration OUT NOCOPY NUMBER
81 , x_timeunit OUT NOCOPY VARCHAR2
82 , x_return_status OUT NOCOPY VARCHAR2);
83
84
85 function get_months_between(p_start_date IN DATE,
86 p_end_date IN DATE)
87 return NUMBER;
88
89 END OKS_TIME_MEASURES_PUB ;