1 PACKAGE cn_formula_gen_pkg AUTHID CURRENT_USER AS
2 -- $Header: cnfmgens.pls 120.3 2005/12/01 15:22:49 ymao noship $
3
4 -- API name : generate_formula
5 -- Type : Private.
6 -- Pre-reqs :
7 -- Usage :
8 --+
9 -- Desc : create a formula package and store in cn_sources, then submit a concurrent
10 -- spool the code to a file and get it compiled against the database.
11 --
12 --
13 --+
14 -- Parameters :
15 -- IN : p_api_version NUMBER Require
16 -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
17 -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
18 -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
19 -- OUT : x_return_status VARCHAR2(1)
20 -- x_msg_count NUMBER
21 -- x_msg_data VARCHAR2(2000)
22 -- IN : p_formula_id NUMBER(15) Require
23 --
24 -- OUT : x_process_audit_id NUMBER(15)
25 -- +
26 --+
27 -- Version : Current version 1.0
28 -- Initial version 1.0
29 --+
30 -- Notes :
31 --+
32 -- End of comments
33
34 PROCEDURE generate_formula
35 ( p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
37 p_commit IN VARCHAR2 := FND_API.G_FALSE,
38 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
39
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43
44 p_formula_id IN NUMBER,
45 p_org_id IN NUMBER,
46 x_process_audit_id OUT NOCOPY NUMBER
47 );
48
49 -- Procedure Name
50 -- create_formula
51 -- Scope
52 -- local to cn_formula_gen_pkg, make it open for debugging purpose
53 -- Purpose
54 -- invoke all formula component constructors to create formula
55 -- History
56 -- 02-March 1999 Richard Jin Created
57 --+
58 FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN;
59
60 PROCEDURE generate_formula_conc(errbuf OUT NOCOPY VARCHAR2,
61 retcode OUT NOCOPY NUMBER,
62 p_org_id NUMBER := NULL);
63
64 END cn_formula_gen_pkg;