1 PACKAGE cn_classification_gen AS
2 -- $Header: cnclgens.pls 120.3 2005/07/12 23:01:58 appldev ship $
3
4
5 --
6 -- Procedure Name
7 -- revenue_classes
8 -- Purpose
9 -- This function generates the code for classifying transactions into
10 -- revenue classes based on certain rules.
11 -- History
12 -- 12/13/93 Devesh Khatu Created
13 -- 06-JUN-95 Amy Erickson Updated
14 --
15 FUNCTION revenue_classes (
16 debug_pipe VARCHAR2,
17 debug_level NUMBER := 1,
18 X_module_id cn_modules.module_id%TYPE,
19 x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
20 x_org_id_in cn_rulesets.org_id%TYPE) RETURN BOOLEAN ;
21
22 g_ruleset_id cn_rulesets.ruleset_id%type;
23 g_org_id cn_rulesets.org_id%type;
24
25 --
26 -- Procedure Name
27 -- classification_install
28 -- Purpose
29 -- This procedure generates the code and then installs the
30 -- modified rule definitions in the database.
31 -- History
32 -- 07/04/2000 Sohail Khawaja Created
33 --
34 PROCEDURE Classification_Install(
35 x_errbuf OUT NOCOPY VARCHAR2,
36 x_retcode OUT NOCOPY NUMBER,
37 x_ruleset_id IN NUMBER,
38 x_org_id IN NUMBER);
39
40 -- Called by the methods to get the current org_id and the org_id string rep
41 PROCEDURE get_cached_org_info (
42 x_cached_org_id OUT NOCOPY integer,
43 x_cached_org_append OUT NOCOPY VARCHAR2);
44
45
46 -- clku
47 -- procedure to check for if single quotes are paired up in a string
48 PROCEDURE check_text_paired_quotes (l_in_text IN VARCHAR2,
49 l_out_paired_quotes OUT NOCOPY BOOLEAN );
50
51 END cn_classification_gen;