DBA Data[Home] [Help]

PACKAGE: APPS.PJI_PJP_EXTRACTION_UTILS

Source


1 PACKAGE PJI_PJP_EXTRACTION_UTILS as
2   /* $Header: PJIUT06S.pls 120.1 2006/11/10 13:33:37 akgupta noship $ */
3 
4   procedure SET_WORKER_ID (p_worker_id in number);
5 
6   function GET_WORKER_ID return number;
7 
8   procedure UPDATE_EXTR_SCOPE;
9 
10   procedure POPULATE_ORG_EXTR_INFO;
11 
12   procedure UPDATE_ORG_EXTR_INFO;
13 
14   procedure SEED_PJI_PJP_STATS(p_worker_id in number);
15 
16   procedure ANALYZE_PJP_FACTS;
17 
18   procedure TRUNCATE_PJP_TABLES
19   (
20     errbuf        out nocopy varchar2,
21     retcode       out nocopy varchar2,
22     p_check       in         varchar2 default 'N',
23     p_fpm_upgrade in         varchar2 default 'Y',
24     p_recover     in         varchar2 default 'N'
25   );
26 
27   function LAST_PJP_EXTR_DATE (p_project_id in number default null ) return date;
28 
29 end PJI_PJP_EXTRACTION_UTILS;