1 PACKAGE CN_RT_QUOTA_ASGNS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnxvrqas.pls 120.1.12020000.2 2013/01/25 09:00:23 ndamala ship $ */
3
4 -- Record type
5
6 TYPE rate_date_seq_rec_type IS RECORD
7 (
8 start_date cn_rt_quota_asgns.start_date%TYPE := NULL,
9 start_date_old cn_rt_quota_asgns.start_date%TYPE := NULL,
10 end_date cn_rt_quota_asgns.end_date%TYPE := NULL,
11 end_date_old cn_rt_quota_asgns.end_date%TYPE := NULL,
12 quota_id cn_rt_quota_asgns.quota_id%TYPE := NULL,
13 rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE
14 := NULL,
15 org_id cn_rt_quota_asgns.org_id%type:=NULL,
16 calc_formula_id cn_rt_quota_asgns.calc_formula_id%type:=NULL
17 );
18
19 --
20 -- User Defined Quota Rules Record Table Type
21 --
22 TYPE rate_date_seq_rec_tbl_type IS TABLE OF rate_date_seq_rec_type
23 INDEX BY BINARY_INTEGER;
24
25 G_MISS_RATE_DATE_SEQ_REC_TBL rate_date_seq_rec_tbl_type ;
26
27 -- API name : Create RT Quota Asgns
28 -- Type : Private.
29 -- Pre-reqs : None.
30 -- Usage : Used to Call from Form to Create RT Quota Asgns and
31 -- called from public API ( Plan Element Pub )
32 -- Desc : Procedure to RT Quota Asgns
33 -- Parameters :
34 -- IN : p_api_version IN NUMBER Require
35 -- p_init_msg_list IN VARCHAR2 Optional
36 -- Default = FND_API.G_FALSE
37 -- p_commit IN VARCHAR2 Optional
38 -- Default = FND_API.G_FALSE
39 -- p_validation_level IN NUMBER Optional
40 -- Default = FND_API.G_VALID_LEVEL_FULL
41 -- OUT : x_return_status OUT VARCHAR2(1)
42 -- x_msg_count OUT NUMBER
43 -- x_msg_data OUT VARCHAR2(2000)
44 -- IN p_rt_quota_asgns_tbl_rec IN rt_quota_asgns_rec_tbl_type,
45 -- IN p_quota_name IN VARCHAR2
46 -- OUT : x_loading_status OUT
47 -- Detailed Error Message
48 -- Version : Current version 1.0
49 -- Initial version 1.0
50 --
51 -- End of comments
52
53 PROCEDURE Create_rt_quota_asgns
54 ( p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_validation_level IN NUMBER :=
58 FND_API.G_VALID_LEVEL_FULL,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_quota_name IN cn_quotas.name%TYPE,
63 p_org_id IN NUMBER,
64 p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type
65 := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
66 x_loading_status OUT NOCOPY VARCHAR2,
67 x_object_version_number IN OUT NOCOPY NUMBER
68 );
69 -- API name : Update RT Quota Asgns
70 -- Type : Private.
71 -- Pre-reqs : None.
72 -- Usage : Used to Call from Form to Update RT Quota Asgns
73 -- Desc : Procedure to RT Quota Asgns
74 -- Parameters :
75 -- IN : p_api_version IN NUMBER Require
76 -- p_init_msg_list IN VARCHAR2 Optional
77 -- Default = FND_API.G_FALSE
78 -- p_commit IN VARCHAR2 Optional
79 -- Default = FND_API.G_FALSE
80 -- p_validation_level IN NUMBER Optional
81 -- Default = FND_API.G_VALID_LEVEL_FULL
82 -- p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type
83 -- p_quota_name IN VARCHAR2
84 -- OUT : x_return_status OUT VARCHAR2(1)
85 -- x_msg_count OUT NUMBER
86 -- x_msg_data OUT VARCHAR2(2000)
87 -- OUT : x_loading_status OUT
88 -- Detailed Error Message
89 -- Version : Current version 1.0
90 -- Initial version 1.0
91 --
92 -- End of comments
93 PROCEDURE Update_rt_quota_asgns
94 ( p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_level IN NUMBER :=
98 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 cn_quotas.name%TYPE,
103 p_org_id IN NUMBER,
104 p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type
105 := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
106 x_loading_status OUT NOCOPY VARCHAR2,
107 x_object_version_number IN OUT NOCOPY NUMBER
108 ) ;
109 -- API name : Delete RT Quota Asgns
110 -- Type : Private.
111 -- Pre-reqs : None.
112 -- Usage : Used to Call from Form to Update RT Quota Asgns
113 -- Desc : Procedure to RT Quota Asgns
114 -- Parameters :
115 -- IN : p_api_version IN NUMBER Require
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 -- p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type
123 -- p_quota_name IN VARCHAR2
124 -- OUT : x_return_status OUT VARCHAR2(1)
125 -- x_msg_count OUT NUMBER
126 -- x_msg_data OUT VARCHAR2(2000)
127 -- OUT : x_loading_status OUT
128 -- Detailed Error Message
129 -- Version : Current version 1.0
130 -- Initial version 1.0
131 --
132 -- End of comments
133
134 PROCEDURE Delete_rt_quota_asgns
135 ( p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137 p_commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER :=
139 FND_API.G_VALID_LEVEL_FULL,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_quota_name IN cn_quotas.name%TYPE,
144 p_org_id IN NUMBER,
145 p_rt_quota_asgns_rec_tbl IN cn_plan_element_pub.rt_quota_asgns_rec_tbl_type
146 := cn_plan_element_pub.g_miss_rt_quota_asgns_rec_tbl,
147 x_loading_status OUT NOCOPY VARCHAR2
148 );
149 END CN_RT_QUOTA_ASGNS_PVT;