APPS.IBU_SR_UTIL dependencies on IBU_MULTI_PARTIES

Line 185: create_ibu_multi_parties (p_user_id,

181: l_party_id_type(i) := x_party_id1;
182: -- l_flag_type(i) := 'Y';
183: l_operation_type(i) := 'A';
184:
185: create_ibu_multi_parties (p_user_id,
186: l_party_id,
187: 'Y',
188: 'N',
189: NULL,

Line 207: create_ibu_multi_parties (p_user_id ,

203: l_party_id_type(i) := x_party_id1;
204: l_flag_type(i) := 'Y';
205: l_operation_type(i) := 'A';
206:
207: create_ibu_multi_parties (p_user_id ,
208: x_party_id1 ,
209: 'Y',
210: 'N',
211: NULL,

Line 268: PROCEDURE create_ibu_multi_parties(p_user_id IN NUMBER,

264: END check_relationship;
265:
266:
267:
268: PROCEDURE create_ibu_multi_parties(p_user_id IN NUMBER,
269: p_party_id IN NUMBER,
270: p_enable_flag IN VARCHAR2,
271: p_current_party IN VARCHAR2,
272: p_end_date IN DATE,

Line 285: INSERT INTO ibu_multi_parties(USER_ID,

281: AS
282:
283: BEGIN
284:
285: INSERT INTO ibu_multi_parties(USER_ID,
286: PARTY_ID,
287: ENABLE_FLAG,
288: CURRENT_PARTY,
289: END_DATE,

Line 311: END create_ibu_multi_parties;

307:
308: EXCEPTION
309: WHEN others THEN
310: x_insert_status := 'E';
311: END create_ibu_multi_parties;
312:
313:
314: PROCEDURE update_ibu_multi_parties(p_user_id IN NUMBER,
315: p_loggedin_user_id IN NUMBER,

Line 314: PROCEDURE update_ibu_multi_parties(p_user_id IN NUMBER,

310: x_insert_status := 'E';
311: END create_ibu_multi_parties;
312:
313:
314: PROCEDURE update_ibu_multi_parties(p_user_id IN NUMBER,
315: p_loggedin_user_id IN NUMBER,
316: p_party_id IN SYSTEM.IBU_NUM_TBL_TYPE,
317: p_enable_flag IN SYSTEM.IBU_VAR_3_TBL_TYPE,
318: x_update_status OUT NOCOPY VARCHAR2

Line 328: select ENABLE_FLAG into l_temp from ibu_multi_parties where party_id=p_party_id(i) and user_id=p_user_id;

324: l_flag VARCHAR2(1);
325: l_temp VARCHAR2(1);
326: BEGIN
327: FOR i IN p_party_id.FIRST .. p_party_id.LAST LOOP
328: select ENABLE_FLAG into l_temp from ibu_multi_parties where party_id=p_party_id(i) and user_id=p_user_id;
329: l_party_id1 := p_party_id(i);
330: l_flag := p_enable_flag(i);
331: IF l_temp <> l_flag THEN
332: UPDATE ibu_multi_parties

Line 332: UPDATE ibu_multi_parties

328: select ENABLE_FLAG into l_temp from ibu_multi_parties where party_id=p_party_id(i) and user_id=p_user_id;
329: l_party_id1 := p_party_id(i);
330: l_flag := p_enable_flag(i);
331: IF l_temp <> l_flag THEN
332: UPDATE ibu_multi_parties
333: SET ENABLE_FLAG = l_flag,last_update_date = SYSDATE,last_updated_by = p_loggedin_user_id,last_update_login = p_loggedin_user_id
334: WHERE USER_ID = p_user_id
335: AND PARTY_ID = l_party_id1;
336: END IF;

Line 344: END update_ibu_multi_parties;

340: WHEN OTHERS THEN
341: x_update_status := 'E';
342:
343:
344: END update_ibu_multi_parties;
345:
346: -----------------------------------------------------------------------------------
347: END IBU_SR_UTIL; -- Package Specification IBU_SR_UTIL