1 PACKAGE oki_load_enr_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRENRS.pls 115.4 2002/12/01 17:52:43 rpotnuru noship $ */
3
4 --------------------------------------------------------------------------------
5 -- Start of comments
6 --
7 -- API Name : OKI_LOAD_ENR_PVT
8 -- Type : Process
9 -- Purpose : Load the oki_exp_not_rnw_tmp table.
10 -- Modification History
11 -- 19-September-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 customer, organization and subclass code
17 -- in OKI_SALES_K_HDRS
18 -- For valid period from GL_PERIODS
19 -- Calculate the lost amounts and counts for each salesrep
20 -- Determine if the record should be inserted or updated
21 -- For each distinct customer and subclass
22 -- in OKI_SALES_K_HDRS
23 -- For valid period from GL_PERIODS
24 -- Calculate the lost amounts and counts for each salesrep
25 -- Determine if the record should be inserted or updated
26 -- For each distinct customer in OKI_SALES_K_HDRS
27 -- For valid period from GL_PERIODS
28 -- Calculate the lost amounts and counts
29 -- Determine if the record should be inserted or updated
30 -- Update OKI_REFRESHS table with concurrent manager statistics
31 --
32 --
33 -- End of comments
34 --------------------------------------------------------------------------------
35
36 -- Global variable declaration
37
38 -- variables to log this job run from concurrent manager
39 g_request_id oki.oki_refreshs.request_id%TYPE;
40 g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
41 g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
42 g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
43
44
45 --------------------------------------------------------------------------------
46 -- Procedure to create the expired not renewed records.
47
48 --------------------------------------------------------------------------------
49 PROCEDURE crt_exp_not_rnw
50 ( p_period_set_name IN VARCHAR2
51 , p_period_type IN VARCHAR2
52 , p_summary_build_date IN DATE
53 , x_errbuf OUT NOCOPY VARCHAR2
54 , x_retcode OUT NOCOPY VARCHAR2
55 ) ;
56
57
58 END oki_load_enr_pvt ;