1 PACKAGE CN_COLLECTION_GEN AUTHID CURRENT_USER AS
2 -- $Header: cncogens.pls 120.5 2007/09/26 19:51:22 apink ship $
3
4
5 --
6 -- Function Name
7 -- isParallelEnabled
8 -- Purpose
9 -- Check profile to see if Parallel DML needs to be used or not
10 -- History
11 -- 10-JUL-07 Krish Created
12 --
13
14 FUNCTION isParallelEnabled return boolean;
15 --
16 -- Function Name
17 -- get_org_append_id
18 -- Purpose
19 -- returns the user org_id preceded by an underscore, e.g. _204
20 -- History
21 -- 31-MAR-00 Dave Maskell Created
22 --
23 FUNCTION get_org_append
24 RETURN VARCHAR2;
25 PROCEDURE set_org_id(p_org_id IN NUMBER);
26 PROCEDURE unset_org_id;
27
28 --
29 -- Procedure Name
30 -- collection_pkg
31 -- Purpose
32 -- This procedure generates any collection package.
33 -- History
34 -- 17-MAR-00 Dave Maskell Created
35 --
36 PROCEDURE collection_pkg (
37 debug_pipe VARCHAR2,
38 debug_level NUMBER := 1,
39 x_table_map_id cn_table_maps.table_map_id%TYPE,
40 x_org_id IN NUMBER);
41
42 --
43 -- Procedure Name
44 -- collection_install
45 -- Purpose
46 -- This procedure installs the generated collection package(s)
47 -- for the chosen data source (table_map).
48 -- IF p_test = 'Y' then '_TEST' is appended to the end of the
49 -- package name. This allows you to test creation without overwriting
50 -- the live package.
51 -- History
52 -- 17-MAR-00 Dave Maskell Created
53 --
54 PROCEDURE Collection_install(
55 x_errbuf OUT NOCOPY VARCHAR2,
56 x_retcode OUT NOCOPY NUMBER,
57 p_table_map_id IN cn_table_maps.table_map_id%TYPE,
58 p_test IN VARCHAR2 := 'N',
59 x_org_id IN NUMBER);
60
61 PROCEDURE generate_collect_conc(
62 errbuf OUT NOCOPY VARCHAR2,
63 retcode OUT NOCOPY NUMBER,
64 p_org_id NUMBER);
65
66 END cn_collection_gen;
67
68