PACKAGE BODY: APPS.OKI_LOAD_OKV_PUB

Source

1 PACKAGE BODY oki_load_okv_pub AS
2 /* $Header: OKIPOKVB.pls 115.7 2002/12/01 17:53:03 rpotnuru noship $ */
3 
4 -- 26-NOV-2002 rpotnuru     NOCOPY Changes
5 --------------------------------------------------------------------------------
6   -- Procedure to create all the performance measures records.
7 
8 --------------------------------------------------------------------------------
9   PROCEDURE create_perf_measures
10   (   x_errbuf             OUT NOCOPY VARCHAR2
11     , x_retcode            OUT NOCOPY VARCHAR2
12     , p_period_set_name    IN  VARCHAR2
13     , p_period_type        IN  VARCHAR2
14     , p_summary_build_date IN  VARCHAR2
15   ) IS
16 
17 
18   -- Local variable declaration
19 
20   -- Effective date of the job run.
21   -- Also treated as "current DATE" for bin calculations (e.g., aging reports).
22   l_summary_build_date DATE := NULL ;
23 
24   BEGIN
25 
26     -- Convert the varchar2 date input to a date datatype
27     l_summary_build_date := fnd_conc_date.string_to_date(p_summary_build_date);
28 
29 
30     -- call procedure to create the performance measures
31     oki_load_okv_pvt.create_perf_measures(
32           p_period_set_name    => p_period_set_name
33         , p_period_type        => p_period_type
34         , p_summary_build_date => l_summary_build_date
35         , x_errbuf             => x_errbuf
36         , x_retcode            => x_retcode ) ;
37 
38   END create_perf_measures ;
39 
40 END oki_load_okv_pub ;