[Home] [Help]
PACKAGE: APPS.OKI_LOAD_TNK_PVT
Source
1 PACKAGE oki_load_tnk_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKIRTNKS.pls 115.2 2002/07/12 01:16:25 rpotnuru noship $ */
3 --------------------------------------------------------------------------------
4 -- Start of comments
5 --
6 -- API Name : OKI_LOAD_TNK_PVT
7 -- Type : Process
8 -- Purpose : Load the oki_top_n_contracts table.
9 -- Modification History
10 -- 10-Apr-2002 mezra Initial version.
11 -- Create stub in order to branch.
12 --
13 -- Notes :
14 --
15 -- End of comments
16 --------------------------------------------------------------------------------
17
18 -- Global variable declaration
19
20 -- variables to log this job run from concurrent manager
21 g_request_id oki.oki_refreshs.request_id%TYPE;
22 g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
23 g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
24 g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
25
26 --------------------------------------------------------------------------------
27 -- Procedure to create top n contract records.
28 --
29 --------------------------------------------------------------------------------
30 PROCEDURE crt_top_n_k
31 ( p_start_summary_build_date IN DATE DEFAULT SYSDATE
32 , p_end_summary_build_date IN DATE DEFAULT SYSDATE
33 , x_errbuf OUT VARCHAR2
34 , x_retcode OUT VARCHAR2
35 ) ;
36
37
38 END oki_load_tnk_pvt ;