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