[Home] [Help]
PACKAGE: APPS.OKI_LOAD_ETR_PVT
Source
1 PACKAGE oki_load_etr_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRETRS.pls 115.4 2002/12/01 17:53:35 rpotnuru noship $ */
3 --------------------------------------------------------------------------------
4 -- Start of comments
5 --
6 -- API Name : OKI_LOAD_ETR_PVT
7 -- Type : Process
8 -- Purpose : Load the oki_exp_to_rnwl table
9 -- Modification History
10 -- 26-DEC-2001 mezra Initial version
11 -- 26-NOV-2002 rpotnuru NOCOPY Changes
12 --
13 -- Notes :
14 --
15 -- End of comments
16 --------------------------------------------------------------------------------
17
18
19 -- Global variable declaration
20
21 -- variables to log this job run from concurrent manager
22 g_request_id oki.oki_refreshs.request_id%TYPE;
23 g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
24 g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
25 g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
26
27
28 --------------------------------------------------------------------------------
29 -- Procedure to create the expiration to renewal records.
30
31 --------------------------------------------------------------------------------
32 PROCEDURE crt_exp_to_rnwl
33 ( p_start_summary_build_date IN DATE
34 , p_end_summary_build_date IN DATE
35 , x_errbuf OUT NOCOPY VARCHAR2
36 , x_retcode OUT NOCOPY VARCHAR2
37 ) ;
38
39
40 END oki_load_etr_pvt ;