APPS.IBU_SR_UTIL dependencies on IBU_MULTI_PARTIES

Line 186: create_ibu_multi_parties (p_user_id,

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

Line 208: create_ibu_multi_parties (p_user_id ,

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

Line 269: PROCEDURE create_ibu_multi_parties(p_user_id IN NUMBER,

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

Line 286: INSERT INTO ibu_multi_parties(USER_ID,

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

Line 312: END create_ibu_multi_parties;

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

Line 315: PROCEDURE update_ibu_multi_parties(p_user_id IN NUMBER,

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

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

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

Line 333: UPDATE ibu_multi_parties

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

Line 344: END update_ibu_multi_parties;

340: EXCEPTION
341: WHEN OTHERS THEN
342: x_update_status := 'E';
343:
344: END update_ibu_multi_parties;
345:
346: /*added for 12.1.2 enhancement bug8245975*/
347: function return_primary(party_site_id IN NUMBER) return varchar2 is
348: l_phone varchar2(100);