1 PACKAGE AMS_DMExtract_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdxts.pls 115.9 2002/12/09 11:28:46 choang noship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'AMS_DMExtract_PVT';
5
6
7 --
8 -- PROCEDURE ExtractMain
9 -- This is the main driving procedure for the extraction process. It calls all
10 -- the other procedures as required.
11 -- Input Params:
12 -- p_job : May be used if this is scheduled with DBMS_JOBS or Concurrent Mgr
13 -- p_mode: Parameter specifying whether this is an Insert or an Update process
14 -- Values: 'I' --> Insert Process
15 -- 'U' --> Update Process
16 -- (the following are valid only if p_mode is 'I')
17 -- p_model_id: Model ID for the data mining model to be built or scored
18 -- p_model_type: Whether this extraction process is for model building ('MODL')
19 -- or scoring the model ('SCOR')
20 --
21 PROCEDURE ExtractMain (
22 p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
24 p_commit IN VARCHAR2 := FND_API.g_false,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_job IN VARCHAR2 DEFAULT 'NULL',
29 p_mode IN VARCHAR2,
30 p_model_id IN NUMBER DEFAULT NULL,
31 p_model_type IN VARCHAR2 DEFAULT 'NULL'
32 );
33
34
35 --
36 -- Purpose
37 -- Concurrent program to call extractmain with update
38 -- as the mode.
39 --
40 -- Parameters
41 -- errbuf - standard concurrent program output
42 -- retcode - standard concurrent program output
43 PROCEDURE schedule_update_parties (
44 errbuf OUT NOCOPY VARCHAR2,
45 retcode OUT NOCOPY VARCHAR2
46 );
47
48
49 END ams_DMExtract_pvt; -- END OF PACKAGE SPEC.