1 PACKAGE oki_load_yra_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRYRAS.pls 115.3 2002/12/01 17:52:58 rpotnuru noship $ */
3 --------------------------------------------------------------------------------
4 -- Start of comments
5 --
6 -- API Name : OKI_LOAD_YRA_PVT
7 -- Type : Process
8 -- Purpose : Load the oki_yoy_renewal_amt table
9 -- Modification History
10 -- 19-July-2001 Mezra Created
11 -- 26-NOV-2002 rpotnuru NOCOPY Changes
12 --
13 -- Notes :
14 -- The following is an overview of the program
15 -- For each distinct month, year, organization and subclass code
16 -- in OKI_SALES_K_HDRS
17 -- For valid period from GL_PERIODS
18 -- Calculate the contract amount
19 -- Determine if the record should be inserted or updated
20 -- For each distinct month, year and subclass code
21 -- in OKI_SALES_K_HDRS
22 -- For valid period from GL_PERIODS
23 -- Calculate the contract amount
24 -- Determine if the record should be inserted or updated
25 -- For each distinct month and year
26 -- For valid period from GL_PERIODS
27 -- Calculate the contract amount
28 -- Determine if the record should be inserted or updated
29 -- Update OKI_REFRESHS table with concurrent manager statistics
30 --
31 --
32 -- End of comments
33 --------------------------------------------------------------------------------
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 yoy renewal records.
47
48 --------------------------------------------------------------------------------
49 PROCEDURE crt_yoy_rnwl
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_yra_pvt ;