1 PACKAGE oki_load_rbs_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRRBSS.pls 115.8 2002/12/01 17:54:04 rpotnuru noship $ */
3
4 --------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : OKI_LOAD_RBS_PVT
8 -- Type : Process
9 -- Purpose : Load the oki_renew_by_statuses 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 expired amounts and counts
20 -- Determine if the record should be inserted or updated
21 -- Calculate the WIP amounts and counts
22 -- Determine if the record should be inserted or updated
23 -- Calculate the signed amounts and counts
24 -- Determine if the record should be inserted or updated
25 -- Calculate the forecast amounts and counts
26 -- Determine if the record should be inserted or updated
27 -- For each distinct organization in OKI_SALES_K_HDRS
28 -- For valid period from GL_PERIODS
29 -- Calculate the expired amounts and counts
30 -- Determine if the record should be inserted or updated
31 -- Calculate the WIP amounts and counts
32 -- Determine if the record should be inserted or updated
33 -- Calculate the signed amounts and counts
34 -- Determine if the record should be inserted or updated
35 -- Calculate the forecast amounts and counts
36 -- Determine if the record should be inserted or updated
37 -- For valid period from GL_PERIODS
38 -- Calculate the expired amounts and counts
39 -- Determine if the record should be inserted or updated
40 -- Calculate the WIP amounts and counts
41 -- Determine if the record should be inserted or updated
42 -- Calculate the signed amounts and counts
43 -- Determine if the record should be inserted or updated
44 -- Calculate the forecast amounts and counts
45 -- Determine if the record should be inserted or updated
46 -- Update OKI_REFRESHS table with concurrent manager statistics
47 --
48 -- End of comments
49 --------------------------------------------------------------------------------
50
51 -- Global variable declaration
52
53 -- variables to log this job run from concurrent manager
54 g_request_id oki.oki_refreshs.request_id%TYPE;
55 g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
56 g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
57 g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
58
59
60 --------------------------------------------------------------------------------
61 -- Procedure to create the renew by statuses records.
62
63 --------------------------------------------------------------------------------
64 PROCEDURE crt_rnwl_by_stat
65 ( p_period_set_name IN VARCHAR2
66 , p_period_type IN VARCHAR2
67 , p_summary_build_date IN DATE
68 , x_errbuf OUT NOCOPY VARCHAR2
69 , x_retcode OUT NOCOPY VARCHAR2
70 ) ;
71
72 END oki_load_rbs_pvt ;