PACKAGE BODY: APPS.OKI_LOAD_FBO_PUB

Source

1 PACKAGE BODY oki_load_fbo_pub AS
2 /* $Header: OKIPFBOB.pls 115.7 2002/12/01 17:52:07 rpotnuru noship $ */
3 
4 -- 26-NOV-2002 rpotnuru     NOCOPY Changes
5 --------------------------------------------------------------------------------
6   -- Procedure to create all the forecast by organization records.
7 
8 --------------------------------------------------------------------------------
9   PROCEDURE crt_fcst_org
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 
25   BEGIN
26 
27     -- Convert the varchar2 date input to a date datatype
28     l_summary_build_date := fnd_conc_date.string_to_date(p_summary_build_date);
29 
30 
31     -- Call procedure to create the forecast by organizations
32     oki_load_fbo_pvt.crt_fcst_org (
33           p_period_set_name    => p_period_set_name
34         , p_period_type        => p_period_type
35         , p_summary_build_date => l_summary_build_date
36         , x_errbuf             => x_errbuf
37         , x_retcode            => x_retcode ) ;
38 
39   END crt_fcst_org ;
40 
41 END oki_load_fbo_pub ;