[Home] [Help]
PACKAGE BODY: APPS.PSB_ACCT_POS_SET_LINE_L_PVT
Source
1 PACKAGE BODY PSB_Acct_Pos_Set_Line_L_PVT AS
2 /* $Header: PSBWSLLB.pls 120.2 2005/07/13 11:37:41 shtripat ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_Acct_Pos_Set_Line_L_PVT';
5
6
7
8 /*=========================================================================+
9 | PROCEDURE Lock_Row |
10 +=========================================================================*/
11
12 PROCEDURE Lock_Row
13 (
14 p_api_version IN NUMBER,
15 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16 p_commit IN VARCHAR2 := FND_API.G_FALSE,
17 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18 p_return_status OUT NOCOPY VARCHAR2,
19 p_msg_count OUT NOCOPY NUMBER,
20 p_msg_data OUT NOCOPY VARCHAR2,
21 --
22 p_Row_Id IN VARCHAR2,
23 p_Line_Sequence_Id IN NUMBER,
24 p_Account_Position_Set_Id IN NUMBER,
25 p_Description IN VARCHAR2,
26 p_Business_Group_Id IN NUMBER,
27 p_Attribute_Id IN NUMBER,
28 p_Include_Or_Exclude_Type IN VARCHAR2,
29 p_Segment1_Low IN VARCHAR2,
30 p_Segment2_Low IN VARCHAR2,
31 p_Segment3_Low IN VARCHAR2,
32 p_Segment4_Low IN VARCHAR2,
33 p_Segment5_Low IN VARCHAR2,
34 p_Segment6_Low IN VARCHAR2,
35 p_Segment7_Low IN VARCHAR2,
36 p_Segment8_Low IN VARCHAR2,
37 p_Segment9_Low IN VARCHAR2,
38 p_Segment10_Low IN VARCHAR2,
39 p_Segment11_Low IN VARCHAR2,
40 p_Segment12_Low IN VARCHAR2,
41 p_Segment13_Low IN VARCHAR2,
42 p_Segment14_Low IN VARCHAR2,
43 p_Segment15_Low IN VARCHAR2,
44 p_Segment16_Low IN VARCHAR2,
45 p_Segment17_Low IN VARCHAR2,
46 p_Segment18_Low IN VARCHAR2,
47 p_Segment19_Low IN VARCHAR2,
48 p_Segment20_Low IN VARCHAR2,
49 p_Segment21_Low IN VARCHAR2,
50 p_Segment22_Low IN VARCHAR2,
51 p_Segment23_Low IN VARCHAR2,
52 p_Segment24_Low IN VARCHAR2,
53 p_Segment25_Low IN VARCHAR2,
54 p_Segment26_Low IN VARCHAR2,
55 p_Segment27_Low IN VARCHAR2,
56 p_Segment28_Low IN VARCHAR2,
57 p_Segment29_Low IN VARCHAR2,
58 p_Segment30_Low IN VARCHAR2,
59 p_Segment1_High IN VARCHAR2,
60 p_Segment2_High IN VARCHAR2,
61 p_Segment3_High IN VARCHAR2,
62 p_Segment4_High IN VARCHAR2,
63 p_Segment5_High IN VARCHAR2,
64 p_Segment6_High IN VARCHAR2,
65 p_Segment7_High IN VARCHAR2,
66 p_Segment8_High IN VARCHAR2,
67 p_Segment9_High IN VARCHAR2,
68 p_Segment10_High IN VARCHAR2,
69 p_Segment11_High IN VARCHAR2,
70 p_Segment12_High IN VARCHAR2,
71 p_Segment13_High IN VARCHAR2,
72 p_Segment14_High IN VARCHAR2,
73 p_Segment15_High IN VARCHAR2,
74 p_Segment16_High IN VARCHAR2,
75 p_Segment17_High IN VARCHAR2,
76 p_Segment18_High IN VARCHAR2,
77 p_Segment19_High IN VARCHAR2,
78 p_Segment20_High IN VARCHAR2,
79 p_Segment21_High IN VARCHAR2,
80 p_Segment22_High IN VARCHAR2,
81 p_Segment23_High IN VARCHAR2,
82 p_Segment24_High IN VARCHAR2,
83 p_Segment25_High IN VARCHAR2,
84 p_Segment26_High IN VARCHAR2,
85 p_Segment27_High IN VARCHAR2,
86 p_Segment28_High IN VARCHAR2,
87 p_Segment29_High IN VARCHAR2,
88 p_Segment30_High IN VARCHAR2,
89 p_context IN VARCHAR2,
90 p_attribute1 IN VARCHAR2,
91 p_attribute2 IN VARCHAR2,
92 p_attribute3 IN VARCHAR2,
93 p_attribute4 IN VARCHAR2,
94 p_attribute5 IN VARCHAR2,
95 p_attribute6 IN VARCHAR2,
96 p_attribute7 IN VARCHAR2,
97 p_attribute8 IN VARCHAR2,
98 p_attribute9 IN VARCHAR2,
99 p_attribute10 IN VARCHAR2,
100 --
101 p_row_locked OUT NOCOPY VARCHAR2
102 )
103 IS
104 --
105 l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
106 --
107 BEGIN
108 --
109 SAVEPOINT Lock_Row_Pvt ;
110 --
111
112 PSB_ACCT_POSITION_SET_LINE_PVT.Lock_Row
113 (
114 p_api_version => p_api_version ,
115 p_init_msg_list => p_init_msg_list ,
116 p_commit => p_commit ,
117 p_validation_level => p_validation_level,
118 p_return_status => p_return_status,
119 p_msg_count => p_msg_count,
120 p_msg_data => p_msg_data,
121 --
122 p_Row_Id => p_Row_Id,
123 p_Line_Sequence_Id => p_Line_Sequence_Id,
124 p_Account_Position_Set_Id => p_Account_Position_Set_Id,
125 p_Description => p_Description,
126 p_Business_Group_Id => p_Business_Group_Id,
127 p_Attribute_Id => p_Attribute_Id,
128 p_Include_Or_Exclude_Type => p_Include_Or_Exclude_Type,
129 p_Segment1_Low => p_Segment1_Low,
130 p_Segment2_Low => p_Segment2_Low,
131 p_Segment3_Low => p_Segment3_Low,
132 p_Segment4_Low => p_Segment4_Low,
133 p_Segment5_Low => p_Segment5_Low,
134 p_Segment6_Low => p_Segment6_Low,
135 p_Segment7_Low => p_Segment7_Low,
136 p_Segment8_Low => p_Segment8_Low,
137 p_Segment9_Low => p_Segment9_Low,
138 p_Segment10_Low => p_Segment10_Low,
139 p_Segment11_Low => p_Segment11_Low,
140 p_Segment12_Low => p_Segment12_Low,
141 p_Segment13_Low => p_Segment13_Low,
142 p_Segment14_Low => p_Segment14_Low,
143 p_Segment15_Low => p_Segment15_Low,
144 p_Segment16_Low => p_Segment16_Low,
145 p_Segment17_Low => p_Segment17_Low,
146 p_Segment18_Low => p_Segment18_Low,
147 p_Segment19_Low => p_Segment19_Low,
148 p_Segment20_Low => p_Segment20_Low,
149 p_Segment21_Low => p_Segment21_Low,
150 p_Segment22_Low => p_Segment22_Low,
151 p_Segment23_Low => p_Segment23_Low,
152 p_Segment24_Low => p_Segment24_Low,
153 p_Segment25_Low => p_Segment25_Low,
154 p_Segment26_Low => p_Segment26_Low,
155 p_Segment27_Low => p_Segment27_Low,
156 p_Segment28_Low => p_Segment28_Low,
157 p_Segment29_Low => p_Segment29_Low,
158 p_Segment30_Low => p_Segment30_Low,
159 p_Segment1_High => p_Segment1_High,
160 p_Segment2_High => p_Segment2_High,
161 p_Segment3_High => p_Segment3_High,
162 p_Segment4_High => p_Segment4_High,
163 p_Segment5_High => p_Segment5_High,
164 p_Segment6_High => p_Segment6_High,
165 p_Segment7_High => p_Segment7_High,
166 p_Segment8_High => p_Segment8_High,
167 p_Segment9_High => p_Segment9_High,
168 p_Segment10_High => p_Segment10_High,
169 p_Segment11_High => p_Segment11_High,
170 p_Segment12_High => p_Segment12_High,
171 p_Segment13_High => p_Segment13_High,
172 p_Segment14_High => p_Segment14_High,
173 p_Segment15_High => p_Segment15_High,
174 p_Segment16_High => p_Segment16_High,
175 p_Segment17_High => p_Segment17_High,
176 p_Segment18_High => p_Segment18_High,
177 p_Segment19_High => p_Segment19_High,
178 p_Segment20_High => p_Segment20_High,
179 p_Segment21_High => p_Segment21_High,
180 p_Segment22_High => p_Segment22_High,
181 p_Segment23_High => p_Segment23_High,
182 p_Segment24_High => p_Segment24_High,
183 p_Segment25_High => p_Segment25_High,
184 p_Segment26_High => p_Segment26_High,
185 p_Segment27_High => p_Segment27_High,
186 p_Segment28_High => p_Segment28_High,
187 p_Segment29_High => p_Segment29_High,
188 p_Segment30_High => p_Segment30_High,
189 p_context => p_context,
190 p_attribute1 => p_attribute1,
191 p_attribute2 => p_attribute2,
192 p_attribute3 => p_attribute3,
193 p_attribute4 => p_attribute4,
194 p_attribute5 => p_attribute5,
195 p_attribute6 => p_attribute6,
196 p_attribute7 => p_attribute7,
197 p_attribute8 => p_attribute8,
198 p_attribute9 => p_attribute9,
199 p_attribute10 => p_attribute10,
200 --
201 p_row_locked => p_row_locked
202 );
203
204
205 EXCEPTION
206 --
207 WHEN OTHERS THEN
208 --
209 ROLLBACK TO Lock_Row_Pvt ;
210 --
211 p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212 --
213 IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
214 FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
215 l_api_name );
216 END if;
217 --
218 FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
219 p_data => p_msg_data );
220 --
221 END Lock_Row;
222 /*-------------------------------------------------------------------------*/
223
224
225 END PSB_Acct_Pos_Set_Line_L_PVT;