1 PACKAGE CN_RuleSet_PUB AS
2 --$Header: cnprsets.pls 120.1 2005/08/25 23:38:16 rramakri noship $
3 TYPE ruleset_rec_type IS RECORD
4 (ruleset_name cn_rulesets.name%TYPE,
5 module_type cn_lookups.meaning%TYPE,
6 end_date cn_rulesets.end_date%TYPE,
7 start_date cn_rulesets.start_date%TYPE,
8 org_id cn_rulesets.org_id%TYPE
9 );
10
11 -- NOTE : Due to a bug in FORMS 6.0.4, the record type cannot be initialized
12 -- with the defaults (fnd_api.g_miss_num etc. ) if this API is invoked
13 -- from forms. Hence this version does not initialize the variables
14
15 -- Start of comments
16 -- API name : Create_Ruleset
17 -- Type : Private
18 -- Function : This Private API can be used to create a ruleset.
19 --
20 -- Pre-reqs : None.
21 -- Parameters :
22 -- IN : p_api_version IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional
24 -- Default = FND_API.G_FALSE
25 -- p_commit IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_validation_level IN NUMBER Optional
28 -- Default = FND_API.G_VALID_LEVEL_FULL
29 -- p_ruleset_rec_type IN
30 -- CN_RuleSet_PUB.ruleset_rec_type
31 --
32 -- OUT : x_return_status OUT VARCHAR2(1)
33 -- x_msg_count OUT NUMBER
34 -- x_msg_data OUT VARCHAR2(2000)
35 --
36 -- Version : Current version 1.0
37 -- 25-Mar-99 Renu Chintalapati
38 -- previous version y.y
39 -- Changed....
40 -- Initial version 1.0
41 -- 25-Mar-99 Renu Chintalapati
42 --
43 -- Notes : Note text
44 --
45 -- End of comments
46
47 PROCEDURE create_ruleset
48 ( p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE,
51 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 x_loading_status OUT NOCOPY VARCHAR2,
56 p_ruleset_rec IN CN_RuleSet_PUB.ruleset_rec_type
57 );
58
59
60 -- Start of comments
61 -- API name : Update_Ruleset
62 -- Type : Public
63 -- Function : This Public API can be used to update a rule,
64 -- a ruleset or rule attributes in Oracle Sales
65 -- Compensation.
66 -- Pre-reqs : None.
67 -- Parameters :
68 -- IN : p_api_version IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_commit IN VARCHAR2 Optional
72 -- Default = FND_API.G_FALSE
73 -- p_validation_level IN NUMBER Optional
74 -- Default = FND_API.G_VALID_LEVEL_FULL
75 -- p_ruleset_rec_type IN
76 -- CN_RuleSet_PUB.ruleset_rec_type
77 --
78 -- OUT : x_return_status OUT VARCHAR2(1)
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2(2000)
81 --
82 -- Version : Current version 1.0
83 -- 25-Mar-99 Renu Chintalapati
84 -- previous version y.y
85 -- Changed....
86 -- Initial version 1.0
87 -- 25-Mar-99 Renu Chintalapati
88 --
89 -- Notes : Note text
90 --
91 -- End of comments
92
93
94 PROCEDURE Update_Ruleset
95 ( p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 x_loading_status OUT NOCOPY VARCHAR2,
103 p_old_ruleset_rec IN OUT NOCOPY CN_RuleSet_PUB.ruleset_rec_type,
104 p_ruleset_rec IN OUT NOCOPY CN_RuleSet_PUB.ruleset_rec_type
105 );
106
107 END CN_RuleSet_PUB;