[Home] [Help]
PACKAGE: APPS.PSB_WS_DISTRIBUTION_RULES_PVT
Source
1 PACKAGE PSB_WS_Distribution_Rules_PVT AS
2 /* $Header: PSBVWDRS.pls 120.2 2005/07/13 11:30:56 shtripat ship $ */
3
4 g_rule_id number;
5
6 PROCEDURE Insert_Row
7 (
8 p_api_version IN NUMBER,
9 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10 p_commit IN VARCHAR2 := FND_API.G_FALSE,
11 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12 p_return_status OUT NOCOPY VARCHAR2,
13 p_msg_count OUT NOCOPY NUMBER,
14 p_msg_data OUT NOCOPY VARCHAR2,
15 --
16 p_Row_Id IN OUT NOCOPY VARCHAR2,
17 p_Distribution_Rule_Line_Id IN NUMBER,
18 p_Distribution_Rule_Id IN NUMBER,
19 p_Budget_Group_Id IN NUMBER,
20 p_distribute_flag IN VARCHAR2,
21 p_distribute_all_level_flag IN VARCHAR2,
22 p_download_flag IN VARCHAR2,
23 p_download_all_level_flag IN VARCHAR2,
24 p_year_category_type IN VARCHAR2,
25 p_attribute1 in varchar2,
26 p_attribute2 in varchar2,
27 p_attribute3 in varchar2,
28 p_attribute4 in varchar2,
29 p_attribute5 in varchar2,
30 p_attribute6 in varchar2,
31 p_attribute7 in varchar2,
32 p_attribute8 in varchar2,
33 p_attribute9 in varchar2,
34 p_attribute10 in varchar2,
35 p_context in varchar2,
36 p_mode in varchar2 default 'R'
37 );
38
39
40 PROCEDURE Lock_Row
41 (
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 p_return_status OUT NOCOPY VARCHAR2,
47 p_msg_count OUT NOCOPY NUMBER,
48 p_msg_data OUT NOCOPY VARCHAR2,
49 --
50 p_Distribution_Rule_Line_Id IN NUMBER,
51 p_Distribution_Rule_Id IN NUMBER,
52 p_Budget_Group_Id IN NUMBER,
53 p_distribute_flag IN VARCHAR2,
54 p_distribute_all_level_flag IN VARCHAR2,
55 p_download_flag IN VARCHAR2,
56 p_download_all_level_flag IN VARCHAR2,
57 p_year_category_type IN VARCHAR2,
58 p_attribute1 in varchar2,
59 p_attribute2 in varchar2,
60 p_attribute3 in varchar2,
61 p_attribute4 in varchar2,
62 p_attribute5 in varchar2,
63 p_attribute6 in varchar2,
64 p_attribute7 in varchar2,
65 p_attribute8 in varchar2,
66 p_attribute9 in varchar2,
67 p_attribute10 in varchar2,
68 p_context in varchar2,
69 --
70 p_row_locked OUT NOCOPY VARCHAR2
71 );
72
73
74 PROCEDURE Update_Row
75 (
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80 p_return_status OUT NOCOPY VARCHAR2,
81 p_msg_count OUT NOCOPY NUMBER,
82 p_msg_data OUT NOCOPY VARCHAR2,
83 --
84 p_Distribution_Rule_Line_Id IN NUMBER,
85 p_Distribution_Rule_Id IN NUMBER,
86 p_Budget_Group_Id IN NUMBER,
87 p_distribute_flag IN VARCHAR2,
88 p_distribute_all_level_flag IN VARCHAR2,
89 p_download_flag IN VARCHAR2,
90 p_download_all_level_flag IN VARCHAR2,
91 p_year_category_type IN VARCHAR2,
92 p_attribute1 in varchar2,
93 p_attribute2 in varchar2,
94 p_attribute3 in varchar2,
95 p_attribute4 in varchar2,
96 p_attribute5 in varchar2,
97 p_attribute6 in varchar2,
98 p_attribute7 in varchar2,
99 p_attribute8 in varchar2,
100 p_attribute9 in varchar2,
101 p_attribute10 in varchar2,
102 p_context in varchar2,
103 p_mode in varchar2 default 'R'
104 );
105
106
107 PROCEDURE Delete_Row
108 (
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113 p_return_status OUT NOCOPY VARCHAR2,
114 p_msg_count OUT NOCOPY NUMBER,
115 p_msg_data OUT NOCOPY VARCHAR2,
116 --
117 p_Distribution_Rule_Line_Id IN NUMBER
118 );
119
120 PROCEDURE Rules_Insert_Row
121 (
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124 p_commit IN VARCHAR2 := FND_API.G_FALSE,
125 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126 p_return_status OUT NOCOPY VARCHAR2,
127 p_msg_count OUT NOCOPY NUMBER,
128 p_msg_data OUT NOCOPY VARCHAR2,
129 --
130 p_Row_Id IN OUT NOCOPY VARCHAR2,
131 p_Distribution_Rule_Id IN NUMBER,
132 P_Budget_Group_Id IN NUMBER,
133 p_Name IN VARCHAR2,
134 p_mode in varchar2 default 'R'
135 );
136
137
138 PROCEDURE Rules_Delete_Row
139 (
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144 p_return_status OUT NOCOPY VARCHAR2,
145 p_msg_count OUT NOCOPY NUMBER,
146 p_msg_data OUT NOCOPY VARCHAR2,
147 --
148 p_Distribution_Rule_Id IN NUMBER
149 );
150
151 PROCEDURE Distribution_Insert_Row
152 (
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157 p_return_status OUT NOCOPY VARCHAR2,
158 p_msg_count OUT NOCOPY NUMBER,
159 p_msg_data OUT NOCOPY VARCHAR2,
160 --
161 p_Row_Id IN OUT NOCOPY VARCHAR2,
162 p_Distribution_Id IN NUMBER,
163 p_Distribution_Rule_Id IN NUMBER,
164 p_Worksheet_ID IN NUMBER,
165 p_Distribution_Date IN DATE,
166 p_distributed_flag IN VARCHAR2,
167 p_distribution_instructions IN VARCHAR2,
168 p_distribution_option_flag IN VARCHAR2,
169 p_revision_option_flag IN VARCHAR2,
170 p_mode IN VARCHAR2 DEFAULT 'R'
171 );
172
173
174 PROCEDURE Check_Unique
175 (
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178 p_commit IN VARCHAR2 := FND_API.G_FALSE,
179 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180 p_return_status OUT NOCOPY VARCHAR2,
181 p_msg_count OUT NOCOPY NUMBER,
182 p_msg_data OUT NOCOPY VARCHAR2,
183 --
184 p_Row_Id IN VARCHAR2,
185 p_Name IN VARCHAR2,
186 p_Return_Value OUT NOCOPY VARCHAR2
187 );
188 --
189 PROCEDURE Copy_Rule
190 (
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193 p_commit IN VARCHAR2 := FND_API.G_FALSE,
194 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195 p_return_status OUT NOCOPY VARCHAR2,
196 p_msg_count OUT NOCOPY NUMBER,
197 p_msg_data OUT NOCOPY VARCHAR2,
198 --
199 p_Source_Distribution_Rule_Id IN NUMBER ,
200 p_Source_Budget_Group In NUMBER,
201 p_Target_Rule_Name In VARCHAR2 ,
202 p_Target_Rule_ID OUT NOCOPY NUMBER,
203 p_mode in varchar2 default 'R'
204 );
205
206 --
207 PROCEDURE Pass_Rule_ID ( p_rule_id IN NUMBER);
208
209 -- functions
210
211 FUNCTION Get_Rule_ID RETURN NUMBER;
212 pragma RESTRICT_REFERENCES ( Get_Rule_ID, WNDS, WNPS );
213
214 FUNCTION get_debug RETURN VARCHAR2;
215 --
216
217 END PSB_WS_Distribution_Rules_PVT ;