1 PACKAGE cn_quota_rule_uplifts_grp AUTHID CURRENT_USER AS
2 /* $Header: cnxgqrus.pls 120.2 2005/09/09 17:57:56 sbadami ship $ */
3 TYPE uplift_date_seq_rec_type IS RECORD (
4 start_date cn_quota_rule_uplifts.start_date%TYPE := NULL,
5 start_date_old cn_quota_rule_uplifts.start_date%TYPE := NULL,
6 end_date cn_quota_rule_uplifts.end_date%TYPE := NULL,
7 end_date_old cn_quota_rule_uplifts.end_date%TYPE := NULL,
8 quota_rule_id cn_quota_rule_uplifts.quota_rule_id%TYPE := NULL,
9 quota_rule_uplift_id cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE := NULL
10 );
11
12 --
13 -- User Defined Quota Rules Record Table Type
14 --
15 TYPE uplift_date_seq_rec_tbl_type IS TABLE OF uplift_date_seq_rec_type
16 INDEX BY BINARY_INTEGER;
17
18 g_miss_uplift_date_seq_rec_tbl uplift_date_seq_rec_tbl_type;
19
20 -- API name : Create_Quota_Rule_uplifts
21 -- Type : Group.
22 -- Pre-reqs : None.
23 -- Usage : Used to create entry into cn_quota_rule_uplifts
24 --
25 -- Desc group package can be called from any where from the oracle apps
26 -- currenly it is called from oracle forms and the public package
27 -- Plan Element public package
28 -- Parameters :
29 -- IN : p_api_version IN NUMBER Required
30 -- p_init_msg_list IN VARCHAR2 Optional
31 -- Default = FND_API.G_FALSE
32 -- p_commit IN VARCHAR2 Optional
33 -- Default = FND_API.G_FALSE
34 -- p_validation_level IN NUMBER Optional
35 -- Default = FND_API.G_VALID_LEVEL_FULL
36 -- OUT : x_return_status OUT VARCHAR2(1)
37 -- x_msg_count OUT NUMBER
38 -- x_msg_data OUT VARCHAR2(2000)
39 -- OUT : x_loading_status OUT VARCHAR2(50)
40 -- Detailed error code returned from procedure.
41 -- IN : p_quota_name IN Required
42 -- IN : p_rev_uplift_rec_tbl IN Optional
43 -- cn_plan_element_pub.g_miss_rev_uplift_rec_tbl
44
45 -- Version : Current version 1.0
46 -- Initial version 1.0
47 --
48 -- Notes : Note text
49 --
50 -- End of comments
51 PROCEDURE create_quota_rule_uplift (
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
54 p_commit IN VARCHAR2 := fnd_api.g_false,
55 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_quota_name IN VARCHAR2,
60 p_rev_uplift_rec_tbl IN OUT NOCOPY cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type,
61 x_loading_status OUT NOCOPY VARCHAR2
62 );
63
64 -- API name : Update_Quota_Rule_uplifts
65 -- Type : Group.
66 -- Pre-reqs : None.
67 -- Usage : Used to update the cn_quota_rule_uplifts
68 --
69 -- Desc
70 --
71 -- Parameters :
72 -- IN : p_api_version IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional
74 -- Default = FND_API.G_FALSE
75 -- p_commit IN VARCHAR2 Optional
76 -- Default = FND_API.G_FALSE
77 -- p_validation_level IN NUMBER Optional
78 -- Default = FND_API.G_VALID_LEVEL_FULL
79 -- OUT : x_return_status OUT VARCHAR2(1)
80 -- x_msg_count OUT NUMBER
81 -- x_msg_data OUT VARCHAR2(2000)
82 -- OUT : x_loading_status OUT VARCHAR2(50)
83 -- Detailed error code returned from procedure.
84 -- IN : p_quota_name IN Required
85 -- IN : p_rev_uplift_rec_tbl IN Optional
86 -- cn_plan_element_pub.g_miss_rev_uplift_rec_tbl
87
88 -- Version : Current version 1.0
89 -- Initial version 1.0
90 --
91 -- Notes : Note text
92 --
93 -- End of comments
94 PROCEDURE update_quota_rule_uplift (
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 p_quota_name IN VARCHAR2,
103 p_rev_uplift_rec_tbl IN OUT NOCOPY cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type,
104 x_loading_status OUT NOCOPY VARCHAR2
105 );
106
107 -- API name : Delete_Quota_Rule_uplifts
108 -- Type : Group.
109 -- Pre-reqs : None.
110 -- Usage : Used to delete a record from cn_quota_rule_uplifts
111 --
112 -- Desc
113 --
114 -- Parameters :
115 -- IN : p_api_version IN NUMBER Required
116 -- p_init_msg_list IN VARCHAR2 Optional
117 -- Default = FND_API.G_FALSE
118 -- p_commit IN VARCHAR2 Optional
119 -- Default = FND_API.G_FALSE
120 -- p_validation_level IN NUMBER Optional
121 -- Default = FND_API.G_VALID_LEVEL_FULL
122 -- OUT : x_return_status OUT VARCHAR2(1)
123 -- x_msg_count OUT NUMBER
124 -- x_msg_data OUT VARCHAR2(2000)
125 -- OUT : x_loading_status OUT VARCHAR2(50)
126 -- Detailed error code returned from procedure.
127 -- IN : p_quota_name IN Required
128 -- IN : p_rev_uplift_rec_tbl IN Optional
129 -- cn_plan_element_pub.g_miss_rev_uplift_rec_tbl
130
131 -- Version : Current version 1.0
132 -- Initial version 1.0
133 --
134 -- Notes : Note text
135 --
136 -- End of comments
137 PROCEDURE delete_quota_rule_uplift (
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
140 p_commit IN VARCHAR2 := fnd_api.g_false,
141 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_quota_name IN VARCHAR2,
146 p_rev_uplift_rec_tbl IN OUT NOCOPY cn_quota_rule_uplift_pvt.quota_rule_uplift_tbl_type,
147 x_loading_status OUT NOCOPY VARCHAR2
148 );
149 END cn_quota_rule_uplifts_grp;