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