1 PACKAGE PSB_ELEMENT_DISTRIBUTIONS_PVT AS
2 /* $Header: PSBVPEDS.pls 120.2 2005/07/13 11:28:14 shtripat ship $ */
3
4
5 PROCEDURE INSERT_ROW
6 ( p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 P_DISTRIBUTION_ID IN NUMBER,
15 P_POSITION_SET_GROUP_ID in NUMBER,
16 P_CHART_OF_ACCOUNTS_ID IN NUMBER,
17 P_EFFECTIVE_START_DATE IN DATE,
18 P_EFFECTIVE_END_DATE IN DATE,
19 P_DISTRIBUTION_PERCENT IN NUMBER,
20 P_CONCATENATED_SEGMENTS IN VARCHAR2,
21 P_CODE_COMBINATION_ID IN NUMBER,
22 P_DISTRIBUTION_SET_ID IN NUMBER,
23 P_SEGMENT1 IN VARCHAR2,
24 P_SEGMENT2 IN VARCHAR2,
25 P_SEGMENT3 IN VARCHAR2,
26 P_SEGMENT4 IN VARCHAR2,
27 P_SEGMENT5 IN VARCHAR2,
28 P_SEGMENT6 IN VARCHAR2,
29 P_SEGMENT7 IN VARCHAR2,
30 P_SEGMENT8 IN VARCHAR2,
31 P_SEGMENT9 IN VARCHAR2,
32 P_SEGMENT10 IN VARCHAR2,
33 P_SEGMENT11 IN VARCHAR2,
34 P_SEGMENT12 IN VARCHAR2,
35 P_SEGMENT13 IN VARCHAR2,
36 P_SEGMENT14 IN VARCHAR2,
37 P_SEGMENT15 IN VARCHAR2,
38 P_SEGMENT16 IN VARCHAR2,
39 P_SEGMENT17 IN VARCHAR2,
40 P_SEGMENT18 IN VARCHAR2,
41 P_SEGMENT19 IN VARCHAR2,
42 P_SEGMENT20 IN VARCHAR2,
43 P_SEGMENT21 IN VARCHAR2,
44 P_SEGMENT22 IN VARCHAR2,
45 P_SEGMENT23 IN VARCHAR2,
46 P_SEGMENT24 IN VARCHAR2,
47 P_SEGMENT25 IN VARCHAR2,
48 P_SEGMENT26 IN VARCHAR2,
49 P_SEGMENT27 IN VARCHAR2,
50 P_SEGMENT28 IN VARCHAR2,
51 P_SEGMENT29 IN VARCHAR2,
52 P_SEGMENT30 IN VARCHAR2,
53 P_LAST_UPDATE_DATE in DATE,
54 P_LAST_UPDATED_BY in NUMBER,
55 P_LAST_UPDATE_LOGIN in NUMBER,
56 P_CREATED_BY in NUMBER,
57 P_CREATION_DATE in DATE
58 );
59
60 PROCEDURE UPDATE_ROW
61 ( p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 p_return_status OUT NOCOPY VARCHAR2,
66 p_msg_count OUT NOCOPY NUMBER,
67 p_msg_data OUT NOCOPY VARCHAR2,
68 --
69 P_DISTRIBUTION_ID IN NUMBER,
70 P_POSITION_SET_GROUP_ID in NUMBER,
71 P_CHART_OF_ACCOUNTS_ID IN NUMBER,
72 P_EFFECTIVE_START_DATE IN DATE,
73 P_EFFECTIVE_END_DATE IN DATE,
74 P_DISTRIBUTION_PERCENT IN NUMBER,
75 P_CONCATENATED_SEGMENTS IN VARCHAR2,
76 P_CODE_COMBINATION_ID IN NUMBER,
77 P_DISTRIBUTION_SET_ID IN NUMBER,
78 P_SEGMENT1 IN VARCHAR2,
79 P_SEGMENT2 IN VARCHAR2,
80 P_SEGMENT3 IN VARCHAR2,
81 P_SEGMENT4 IN VARCHAR2,
82 P_SEGMENT5 IN VARCHAR2,
83 P_SEGMENT6 IN VARCHAR2,
84 P_SEGMENT7 IN VARCHAR2,
85 P_SEGMENT8 IN VARCHAR2,
86 P_SEGMENT9 IN VARCHAR2,
87 P_SEGMENT10 IN VARCHAR2,
88 P_SEGMENT11 IN VARCHAR2,
89 P_SEGMENT12 IN VARCHAR2,
90 P_SEGMENT13 IN VARCHAR2,
91 P_SEGMENT14 IN VARCHAR2,
92 P_SEGMENT15 IN VARCHAR2,
93 P_SEGMENT16 IN VARCHAR2,
94 P_SEGMENT17 IN VARCHAR2,
95 P_SEGMENT18 IN VARCHAR2,
96 P_SEGMENT19 IN VARCHAR2,
97 P_SEGMENT20 IN VARCHAR2,
98 P_SEGMENT21 IN VARCHAR2,
99 P_SEGMENT22 IN VARCHAR2,
100 P_SEGMENT23 IN VARCHAR2,
101 P_SEGMENT24 IN VARCHAR2,
102 P_SEGMENT25 IN VARCHAR2,
103 P_SEGMENT26 IN VARCHAR2,
104 P_SEGMENT27 IN VARCHAR2,
105 P_SEGMENT28 IN VARCHAR2,
106 P_SEGMENT29 IN VARCHAR2,
107 P_SEGMENT30 IN VARCHAR2,
108 P_LAST_UPDATE_DATE in DATE,
109 P_LAST_UPDATED_BY in NUMBER,
110 P_LAST_UPDATE_LOGIN in NUMBER
111 );
112
113
114 PROCEDURE DELETE_ROW
115 ( p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117 p_commit IN VARCHAR2 := FND_API.G_FALSE,
118 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119 p_return_status OUT NOCOPY VARCHAR2,
120 p_msg_count OUT NOCOPY NUMBER,
121 p_msg_data OUT NOCOPY VARCHAR2,
122 --
123 P_DISTRIBUTION_ID IN NUMBER,
124 P_POSITION_SET_GROUP_ID in NUMBER,
125 P_CHART_OF_ACCOUNTS_ID IN NUMBER,
126 P_EFFECTIVE_START_DATE IN DATE
127 );
128
129 PROCEDURE LOCK_ROW
130 ( p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
132 p_commit IN VARCHAR2 := FND_API.G_FALSE,
133 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 p_return_status OUT NOCOPY VARCHAR2,
135 p_msg_count OUT NOCOPY NUMBER,
136 p_msg_data OUT NOCOPY VARCHAR2,
137 --
138 p_row_locked OUT NOCOPY VARCHAR2,
139 --
140 P_DISTRIBUTION_ID IN NUMBER,
141 P_POSITION_SET_GROUP_ID in NUMBER,
142 P_CHART_OF_ACCOUNTS_ID IN NUMBER,
143 P_EFFECTIVE_START_DATE IN DATE,
144 P_EFFECTIVE_END_DATE IN DATE,
145 P_DISTRIBUTION_PERCENT IN NUMBER,
146 P_CONCATENATED_SEGMENTS IN VARCHAR2,
147 P_CODE_COMBINATION_ID IN NUMBER,
148 P_DISTRIBUTION_SET_ID IN NUMBER,
149 P_SEGMENT1 IN VARCHAR2,
150 P_SEGMENT2 IN VARCHAR2,
151 P_SEGMENT3 IN VARCHAR2,
152 P_SEGMENT4 IN VARCHAR2,
153 P_SEGMENT5 IN VARCHAR2,
154 P_SEGMENT6 IN VARCHAR2,
155 P_SEGMENT7 IN VARCHAR2,
156 P_SEGMENT8 IN VARCHAR2,
157 P_SEGMENT9 IN VARCHAR2,
158 P_SEGMENT10 IN VARCHAR2,
159 P_SEGMENT11 IN VARCHAR2,
160 P_SEGMENT12 IN VARCHAR2,
161 P_SEGMENT13 IN VARCHAR2,
162 P_SEGMENT14 IN VARCHAR2,
163 P_SEGMENT15 IN VARCHAR2,
164 P_SEGMENT16 IN VARCHAR2,
165 P_SEGMENT17 IN VARCHAR2,
166 P_SEGMENT18 IN VARCHAR2,
167 P_SEGMENT19 IN VARCHAR2,
168 P_SEGMENT20 IN VARCHAR2,
169 P_SEGMENT21 IN VARCHAR2,
170 P_SEGMENT22 IN VARCHAR2,
171 P_SEGMENT23 IN VARCHAR2,
172 P_SEGMENT24 IN VARCHAR2,
173 P_SEGMENT25 IN VARCHAR2,
174 P_SEGMENT26 IN VARCHAR2,
175 P_SEGMENT27 IN VARCHAR2,
176 P_SEGMENT28 IN VARCHAR2,
177 P_SEGMENT29 IN VARCHAR2,
178 P_SEGMENT30 IN VARCHAR2
179 );
180
181 PROCEDURE Check_Unique
182 (
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 p_return_status OUT NOCOPY VARCHAR2,
188 p_msg_count OUT NOCOPY NUMBER,
189 p_msg_data OUT NOCOPY VARCHAR2,
190 --
191 P_DISTRIBUTION_ID IN NUMBER,
192 P_POSITION_SET_GROUP_ID IN NUMBER,
193 P_CHART_OF_ACCOUNTS_ID IN NUMBER,
194 P_EFFECTIVE_START_DATE IN DATE,
195 P_EFFECTIVE_END_DATE IN DATE,
196 P_CODE_COMBINATION_ID IN NUMBER,
197 P_DISTRIBUTION_SET_ID IN NUMBER,
198 P_Return_Value_date IN OUT NOCOPY VARCHAR2,
199 P_Return_Value_ccid IN OUT NOCOPY VARCHAR2
200 );
201
202
203 END PSB_ELEMENT_DISTRIBUTIONS_PVT;