DBA Data[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 ;