APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_I_PARTIES

Line 361: PROCEDURE CSI_I_PARTIES_MERGE(

357: END IF;
358: END CSI_ITEM_INSTANCES_MERGE;
359:
360:
361: PROCEDURE CSI_I_PARTIES_MERGE(
362: p_entity_name IN VARCHAR2,
363: p_from_id IN NUMBER,
364: x_to_id OUT NOCOPY NUMBER,
365: p_from_fk_id IN NUMBER,

Line 377: from csi_i_parties

373: v_party_source_table VARCHAR2(30) := 'HZ_PARTIES';
374:
375: cursor c1 is
376: select 1
377: from csi_i_parties
378: where party_id = p_from_fk_id
379: and party_source_table = v_party_source_table
380: for update nowait;
381:

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

379: and party_source_table = v_party_source_table
380: for update nowait;
381:
382: l_merge_reason_code VARCHAR2(30);
383: l_api_name VARCHAR2(30) := 'CSI_I_PARTIES_MERGE';
384: l_column_name VARCHAR2(30);
385: l_count NUMBER(10) := 0;
386: l_cp_audit_id NUMBER;
387: v_transaction_type_id NUMBER;

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

397:
398: RESOURCE_BUSY EXCEPTION;
399: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
400: BEGIN
401: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
402:
403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');

399: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
400: BEGIN
401: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
402:
403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407: begin

Line 512: INSERT INTO csi_i_parties_h

508: End;
509:
510: /* insert record into history table */
511:
512: INSERT INTO csi_i_parties_h
513: (
514: instance_party_history_id,
515: instance_party_id,
516: transaction_id,

Line 529: SELECT csi_i_parties_h_s.nextval,

525: last_update_date,
526: last_update_login,
527: object_version_number
528: )
529: SELECT csi_i_parties_h_s.nextval,
530: cip.instance_party_id,
531: v_transaction_id,
532: v_party_source_table,
533: v_party_source_table,

Line 543: FROM csi_i_parties cip

539: fnd_global.user_id,
540: sysdate,
541: fnd_global.user_id,
542: 1
543: FROM csi_i_parties cip
544: WHERE cip.party_source_table = v_party_source_table
545: AND cip.party_id = p_from_fk_id;
546:
547: arp_message.set_Name('CSI', 'CSI_ROWS_INSERTED');

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

553:
554: csi_t_gen_utility_pvt.ADD('Party history row updated'|| v_no_of_rows);
555:
556: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
557: arp_message.set_token('TABLE_NAME', 'CSI_I_PARTIES', FALSE);
558:
559: l_column_name := 'party_id';
560:
561: open c1;

Line 564: update csi_i_parties

560:
561: open c1;
562: close c1;
563:
564: update csi_i_parties
565: set party_id = p_to_fk_id,
566: last_update_date = SYSDATE,
567: last_updated_by = G_USER_ID,
568: last_update_login = G_LOGIN_ID

Line 589: 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 );

585: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: raise;
588: when resource_busy then
589: 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 );
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: raise;
592: when others then
593: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 598: END CSI_I_PARTIES_MERGE;

594: x_return_status := FND_API.G_RET_STS_ERROR;
595: raise;
596: END;
597: END IF;
598: END CSI_I_PARTIES_MERGE;
599:
600: PROCEDURE CSI_SYSTEMS_B_MERGE(
601: p_entity_name IN VARCHAR2,
602: p_from_id IN NUMBER,