PACKAGE: APPS.ICX_POR_EXTRACTOR

Source

1 PACKAGE ICX_POR_EXTRACTOR AS
2 /* $Header: ICXEXTMS.pls 120.1 2006/01/10 11:59:42 sbgeorge noship $*/
3 
4 --------------------------------------------------------------
5 --                   Global Variables                       --
6 --------------------------------------------------------------
7 
8 -- Extractor loader value
9 TYPE tLoaderValueRecord IS Record (
10   load_catalog_groups			VARCHAR2(1),
11   load_categories			VARCHAR2(1),
12   load_template_headers			VARCHAR2(1),
13   load_template_lines			VARCHAR2(1),
14   load_item_master			VARCHAR2(1),
15   load_contracts			VARCHAR2(1),
16   catalog_groups_last_run_date		DATE,
17   categories_last_run_date		DATE,
18   template_headers_last_run_date	DATE,
19   template_lines_last_run_date		DATE,
20   item_master_last_run_date		DATE,
21   contracts_last_run_date		DATE,
22   vendor_last_run_date			DATE,
23   load_internal_item			VARCHAR2(1),
24   internal_item_last_run_date		DATE,
25   cleanup_flag				VARCHAR2(1),
26   load_onetimeitems_all_langs           VARCHAR2(1)  -- Bug # 3991430
27 );
28 gLoaderValue		tLoaderValueRecord;
29 
30 gBaseLang		VARCHAR2(4);
31 gNLSLanguage		VARCHAR2(30);
32 gInstalledLanguageCount	PLS_INTEGER := 1;
33 
34 gJobNum			PLS_INTEGER := 1;
35 gSpid			VARCHAR2(20);
36 
37 gUserId			PLS_INTEGER := fnd_global.user_id;
38 gLoginId		PLS_INTEGER := fnd_global.login_id;
39 gRequestId		PLS_INTEGER := fnd_global.conc_request_id;
40 gProgramApplicationId	PLS_INTEGER := fnd_global.prog_appl_id;
41 gProgramId		PLS_INTEGER := fnd_global.conc_program_id;
42 
43 PROCEDURE setLastRunDates(pType	IN VARCHAR2);
44 PROCEDURE extract(pType 	IN VARCHAR2,
45                   pFileName 	IN VARCHAR2,
46                   pDebugLevel 	IN PLS_INTEGER,
47                   pCommitSize	IN PLS_INTEGER);
48 
49 PROCEDURE purge(pFileName 	IN VARCHAR2,
50                 pDebugLevel 	IN PLS_INTEGER,
51                 pCommitSize	IN PLS_INTEGER);
52 
53 END ICX_POR_EXTRACTOR;