APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_SYSTEMS_B

Line 526: PROCEDURE CSI_SYSTEMS_B_MERGE(

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,
529: x_to_id OUT NOCOPY NUMBER,
530: p_from_fk_id IN NUMBER,

Line 539: from csi_systems_b

535: x_return_status OUT NOCOPY VARCHAR2)
536: IS
537: cursor c1 is
538: select 1
539: from csi_systems_b
540: where install_site_use_id = p_from_fk_id
541: for update nowait;
542:
543: cursor c2 is

Line 545: from csi_systems_b

541: for update nowait;
542:
543: cursor c2 is
544: select 1
545: from csi_systems_b
546: where ship_to_contact_id = p_from_fk_id
547: or bill_to_contact_id = p_from_fk_id
548: or technical_contact_id = p_from_fk_id
549: or service_admin_contact_id = p_from_fk_id

Line 554: l_api_name VARCHAR2(30) := 'CSI_SYSTEMS_B_MERGE';

550: for update nowait;
551:
552: v_source_transaction_type VARCHAR2(30) := 'PARTY_MERGE';
553: l_merge_reason_code VARCHAR2(30);
554: l_api_name VARCHAR2(30) := 'CSI_SYSTEMS_B_MERGE';
555: l_count NUMBER(10) := 0;
556: l_system_audit_id NUMBER;
557: l_column_name VARCHAR2(30);
558: v_transaction_type_id NUMBER;

Line 573: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');

569: RESOURCE_BUSY EXCEPTION;
570: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
571:
572: BEGIN
573: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
574:
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: begin

Line 708: FROM csi_systems_b csb

704: arp_standard.profile.user_id,
705: sysdate,
706: arp_standard.profile.user_id,
707: 1
708: FROM csi_systems_b csb
709: WHERE csb.install_site_use_id = p_from_fk_id;
710:
711: arp_message.set_Name('CSI', 'CSI_ROWS_INSERTED');
712:

Line 719: arp_message.set_token('TABLE_NAME', 'CSI_SYSTEMS_B', FALSE);

715: v_error_message := 'Done with the insert of systems history';
716: arp_message.set_line(v_error_message);
717:
718: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
719: arp_message.set_token('TABLE_NAME', 'CSI_SYSTEMS_B', FALSE);
720:
721: l_column_name := 'install_site_use_id';
722:
723: open c1;

Line 726: update csi_systems_b

722:
723: open c1;
724: close c1;
725:
726: update csi_systems_b
727: set install_site_use_id = p_to_fk_id,
728: last_update_date = SYSDATE,
729: last_updated_by = G_USER_ID,
730: last_update_login = G_LOGIN_ID

Line 781: FROM csi_systems_b csb

777: arp_standard.profile.user_id,
778: sysdate,
779: arp_standard.profile.user_id,
780: 1
781: FROM csi_systems_b csb
782: WHERE ship_to_contact_id = p_from_fk_id
783: OR bill_to_contact_id = p_from_fk_id
784: OR technical_contact_id = p_from_fk_id
785: OR service_admin_contact_id = p_from_fk_id ;

Line 795: arp_message.set_token('TABLE_NAME', 'CSI_SYSTEMS_B', FALSE);

791: v_error_message := 'Done with the insert of systems history';
792: arp_message.set_line(v_error_message);
793:
794: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
795: arp_message.set_token('TABLE_NAME', 'CSI_SYSTEMS_B', FALSE);
796:
797: l_column_name := 'contact_ids';
798:
799: open c2;

Line 805: update csi_systems_b

801:
802: /* Modified udpate statement to retain : ship_to_contact_id, bill_to_contact_id, technical_contact_id &
803: * service_admin_contact_id instead of nulling them out - Bug#6848272
804: */
805: update csi_systems_b
806: set ship_to_contact_id = decode( ship_to_contact_id, p_from_fk_id, p_to_fk_id, ship_to_contact_id ),
807: bill_to_contact_id = decode( bill_to_contact_id, p_from_fk_id, p_to_fk_id, bill_to_contact_id ),
808: technical_contact_id = decode( technical_contact_id, p_from_fk_id, p_to_fk_id, technical_contact_id ),
809: service_admin_contact_id = decode( service_admin_contact_id, p_from_fk_id, p_to_fk_id, service_admin_contact_id ),

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

831: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: raise;
834: when resource_busy then
835: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_SYSTEMS_B for '||l_column_name ||' = '|| p_from_fk_id );
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: raise;
838:
839: when others then

Line 845: END CSI_SYSTEMS_B_MERGE;

841: x_return_status := FND_API.G_RET_STS_ERROR;
842: raise;
843: END;
844: end if;
845: END CSI_SYSTEMS_B_MERGE;
846:
847: PROCEDURE CSI_T_TXN_SYSTEMS_MERGE(
848: p_entity_name IN VARCHAR2,
849: p_from_id IN NUMBER,