1 PACKAGE oki_load_fbo_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRFBOS.pls 115.8 2002/12/01 17:50:37 rpotnuru noship $ */
3
4 --------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : OKI_LOAD_FBO_PVT
8 -- Type : Process
9 -- Purpose : Load the oki_forecast_by_orgs table
10 -- Modification History
11 -- 16-July-2001 Mezra Created
12 -- 26-NOV-2002 rpotnuru NOCOPY Changes
13 --
14 -- Notes :
15 -- The following is an overview of the program
16 -- For each distinct organization and subclass code
17 -- in OKI_SALES_K_HDRS
18 -- For valid period from GL_PERIODS
19 -- Calculate the forecast and booked amounts
20 -- Determine if the record should be inserted or updated
21 -- For each distinct organization in OKI_SALES_K_HDRS
22 -- For valid period from GL_PERIODS
23 -- Calculate the forecast and booked amounts
24 -- Determine if the record should be inserted or updated
25 -- Update OKI_REFRESHS table with concurrent manager statistics
26 --
27 -- End of comments
28 --------------------------------------------------------------------------------
29
30 -- Global variable declaration
31
32 -- variables to log this job run from concurrent manager
33 g_request_id oki.oki_refreshs.request_id%TYPE;
34 g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
35 g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
36 g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
37
38
39 --------------------------------------------------------------------------------
40 -- Procedure to create the forecast by organization records.
41
42 --------------------------------------------------------------------------------
43 PROCEDURE crt_fcst_org
44 ( p_period_set_name IN VARCHAR2
45 , p_period_type IN VARCHAR2
46 , p_summary_build_date IN DATE
47 , x_errbuf OUT NOCOPY VARCHAR2
48 , x_retcode OUT NOCOPY VARCHAR2
49 ) ;
50
51 END oki_load_fbo_pvt ;