1 PACKAGE oki_load_okv_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIROKVS.pls 115.9 2002/12/01 17:51:29 rpotnuru noship $ */
3
4 --------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : OKI_LOAD_OKV_PVT
8 -- Type : Process
9 -- Purpose : Load the oki_perf_measures 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 -- Validate the performance measure code
17 -- For each distinct organization and subclass code
18 -- in OKI_SALES_K_HDRS
19 -- For valid period from GL_PERIODS
20 -- Calculate the days outstanding renewal value
21 -- Determine if the record should be inserted or updated
22 -- Calculate the forecast achievement % value
23 -- Determine if the record should be inserted or updated
24 -- Calculate the contracts consolidated value
25 -- Determine if the record should be inserted or updated
26 -- For each distinct organization in OKI_SALES_K_HDRS
27 -- For valid period from GL_PERIODS
28 -- Calculate the days outstanding renewal value
29 -- Determine if the record should be inserted or updated
30 -- Calculate the forecast achievement % value
31 -- Determine if the record should be inserted or updated
32 -- Calculate the contracts consolidated value
33 -- Determine if the record should be inserted or updated
34 -- For valid period from GL_PERIODS
35 -- Calculate the days outstanding renewal value
36 -- Determine if the record should be inserted or updated
37 -- Calculate the forecast achievement % value
38 -- Determine if the record should be inserted or updated
39 -- Calculate the contracts consolidated value
40 -- Determine if the record should be inserted or updated
41 -- Update OKI_REFRESHS table with concurrent manager statistics
42 --
43 -- 10/19/2001 rpotnuru Moved RCS string to the next line of CREATE PACKAGE
44 -- End of comments
45 --------------------------------------------------------------------------------
46
47
48 -- Global variable declaration
49
50 -- variables to log this job run from concurrent manager
51 g_request_id oki.oki_refreshs.request_id%TYPE;
52 g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
53 g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
54 g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
55
56
57 --------------------------------------------------------------------------------
58 -- Procedure to create the performance measures.
59
60 --------------------------------------------------------------------------------
61 PROCEDURE create_perf_measures
62 ( p_period_set_name IN VARCHAR2
63 , p_period_type IN VARCHAR2
64 , p_summary_build_date IN DATE
65 , x_errbuf OUT NOCOPY VARCHAR2
66 , x_retcode OUT NOCOPY VARCHAR2
67 ) ;
68
69 END oki_load_okv_pvt ;