APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_I_PARTIES

Line 296: PROCEDURE CSI_I_PARTIES_MERGE(

292: END IF;
293: END CSI_ITEM_INSTANCES_MERGE;
294:
295:
296: PROCEDURE CSI_I_PARTIES_MERGE(
297: p_entity_name IN VARCHAR2,
298: p_from_id IN NUMBER,
299: x_to_id OUT NOCOPY NUMBER,
300: p_from_fk_id IN NUMBER,

Line 312: from csi_i_parties

308: v_party_source_table VARCHAR2(30) := 'HZ_PARTIES';
309:
310: cursor c1 is
311: select 1
312: from csi_i_parties
313: where party_id = p_from_fk_id
314: and party_source_table = v_party_source_table
315: for update nowait;
316:

Line 318: l_api_name VARCHAR2(30) := 'CSI_I_PARTIES_MERGE';

314: and party_source_table = v_party_source_table
315: for update nowait;
316:
317: l_merge_reason_code VARCHAR2(30);
318: l_api_name VARCHAR2(30) := 'CSI_I_PARTIES_MERGE';
319: l_column_name VARCHAR2(30);
320: l_count NUMBER(10) := 0;
321: l_cp_audit_id NUMBER;
322: v_transaction_type_id NUMBER;

Line 336: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');

332:
333: RESOURCE_BUSY EXCEPTION;
334: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
335: BEGIN
336: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340: begin

Line 442: INSERT INTO csi_i_parties_h

438: End;
439:
440: /* insert record into history table */
441:
442: INSERT INTO csi_i_parties_h
443: (
444: instance_party_history_id,
445: instance_party_id,
446: transaction_id,

Line 459: SELECT csi_i_parties_h_s.nextval,

455: last_update_date,
456: last_update_login,
457: object_version_number
458: )
459: SELECT csi_i_parties_h_s.nextval,
460: cip.instance_party_id,
461: v_transaction_id,
462: v_party_source_table,
463: v_party_source_table,

Line 473: FROM csi_i_parties cip

469: arp_standard.profile.user_id,
470: sysdate,
471: arp_standard.profile.user_id,
472: 1
473: FROM csi_i_parties cip
474: WHERE cip.party_source_table = v_party_source_table
475: AND cip.party_id = p_from_fk_id;
476:
477: arp_message.set_Name('CSI', 'CSI_ROWS_INSERTED');

Line 485: arp_message.set_token('TABLE_NAME', 'CSI_I_PARTIES', FALSE);

481: v_error_message := 'Done with the insert of party history';
482: arp_message.set_line(v_error_message);
483:
484: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
485: arp_message.set_token('TABLE_NAME', 'CSI_I_PARTIES', FALSE);
486:
487: l_column_name := 'party_id';
488:
489: open c1;

Line 492: update csi_i_parties

488:
489: open c1;
490: close c1;
491:
492: update csi_i_parties
493: set party_id = p_to_fk_id,
494: last_update_date = SYSDATE,
495: last_updated_by = G_USER_ID,
496: last_update_login = G_LOGIN_ID

Line 515: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_I_PARTIES for '||l_column_name ||' = '|| p_from_fk_id );

511: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: raise;
514: when resource_busy then
515: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_I_PARTIES for '||l_column_name ||' = '|| p_from_fk_id );
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: raise;
518: when others then
519: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 524: END CSI_I_PARTIES_MERGE;

520: x_return_status := FND_API.G_RET_STS_ERROR;
521: raise;
522: END;
523: END IF;
524: END CSI_I_PARTIES_MERGE;
525:
526: PROCEDURE CSI_SYSTEMS_B_MERGE(
527: p_entity_name IN VARCHAR2,
528: p_from_id IN NUMBER,