1 PACKAGE oki_load_sgr_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRSGRS.pls 115.3 2002/06/06 11:35:22 pkm ship $ */
3 --------------------------------------------------------------------------------
4 -- Start of comments
5 --
6 -- API Name : OKI_LOAD_SGR_PVT
7 -- Type : Process
8 -- Purpose : Load the oki_seq_growth_rate table
9 -- Modification History
10 -- 10-Oct-2001 mezra Initial version
11 --
12 -- Notes :
13 -- The following is an overview of the program
14 -- For each distinct customer in OKI_SALES_K_HDRS
15 -- For valid period from GL_PERIODS
16 -- Calculate the following:
17 -- 1. Current / previous beginning active contract
18 -- amount
19 -- 2. Current / previous expiring during quarter contract
20 -- amount
21 -- 3. Current / previous quarter contract renewed
22 -- amount
23 -- 4. Current / previous backlog contract renewed
24 -- amount
25 -- 5. Current / previous new business contract
26 -- amount
27 -- 6. Current / previous cancelled renewal contract
28 -- amount
29 -- 7. Current / previous terminated contract
30 -- amount (lost)
31 -- 8. Current / previous ending active contract
32 -- amount
33 -- 9. Current / previous sequential growth rate
34 -- Determine if each of the above should be inserted or updated
35 -- For each distinct organization in OKI_SALES_K_HDRS
36 -- For valid period from GL_PERIODS
37 -- Repeat steps 1 - 9 above.
38 -- Determine if each of the above should be inserted or updated
39 -- For each summary build date
40 -- Repeat steps 1 - 9 above.
41 -- Determine if each of the above should be inserted or updated
42 -- Update OKI_REFRESHS table with concurrent manager statistics
43 --
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 sequential growth rate records.
59
60 --------------------------------------------------------------------------------
61 PROCEDURE crt_seq_grw
62 ( p_period_set_name IN VARCHAR2
63 , p_period_type IN VARCHAR2
64 , p_start_summary_build_date IN DATE DEFAULT SYSDATE
65 , p_end_summary_build_date IN DATE DEFAULT SYSDATE
66 , x_errbuf OUT VARCHAR2
67 , x_retcode OUT VARCHAR2
68 ) ;
69
70
71 END oki_load_sgr_pvt ;