APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_SYSTEMS_B

Line 600: PROCEDURE CSI_SYSTEMS_B_MERGE(

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

Line 613: from csi_systems_b

609: x_return_status OUT NOCOPY VARCHAR2)
610: IS
611: cursor c1 is
612: select 1
613: from csi_systems_b
614: where install_site_use_id = p_from_fk_id
615: for update nowait;
616:
617: cursor c2 is

Line 619: from csi_systems_b

615: for update nowait;
616:
617: cursor c2 is
618: select 1
619: from csi_systems_b
620: where ship_to_contact_id = p_from_fk_id
621: or bill_to_contact_id = p_from_fk_id
622: or technical_contact_id = p_from_fk_id
623: or service_admin_contact_id = p_from_fk_id

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

624: for update nowait;
625:
626: v_source_transaction_type VARCHAR2(30) := 'PARTY_MERGE';
627: l_merge_reason_code VARCHAR2(30);
628: l_api_name VARCHAR2(30) := 'CSI_SYSTEMS_B_MERGE';
629: l_count NUMBER(10) := 0;
630: l_system_audit_id NUMBER;
631: l_column_name VARCHAR2(30);
632: v_transaction_type_id NUMBER;

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

643: RESOURCE_BUSY EXCEPTION;
644: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
645:
646: BEGIN
647: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
648:
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: begin

Line 782: FROM csi_systems_b csb

778: fnd_global.user_id,
779: sysdate,
780: fnd_global.user_id,
781: 1
782: FROM csi_systems_b csb
783: WHERE csb.install_site_use_id = p_from_fk_id;
784:
785: arp_message.set_Name('CSI', 'CSI_ROWS_INSERTED');
786:

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

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

Line 800: update csi_systems_b

796:
797: open c1;
798: close c1;
799:
800: update csi_systems_b
801: set install_site_use_id = p_to_fk_id,
802: last_update_date = SYSDATE,
803: last_updated_by = G_USER_ID,
804: last_update_login = G_LOGIN_ID

Line 855: FROM csi_systems_b csb

851: fnd_global.user_id,
852: sysdate,
853: fnd_global.user_id,
854: 1
855: FROM csi_systems_b csb
856: WHERE ship_to_contact_id = p_from_fk_id
857: OR bill_to_contact_id = p_from_fk_id
858: OR technical_contact_id = p_from_fk_id
859: OR service_admin_contact_id = p_from_fk_id ;

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

865: v_error_message := 'Done with the insert of systems history';
866: arp_message.set_line(v_error_message);
867:
868: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
869: arp_message.set_token('TABLE_NAME', 'CSI_SYSTEMS_B', FALSE);
870:
871: l_column_name := 'contact_ids';
872:
873: open c2;

Line 879: update csi_systems_b

875:
876: /* Modified udpate statement to retain : ship_to_contact_id, bill_to_contact_id, technical_contact_id and
877: * service_admin_contact_id instead of nulling them out - Bug#6848272
878: */
879: update csi_systems_b
880: set ship_to_contact_id = decode( ship_to_contact_id, p_from_fk_id, p_to_fk_id, ship_to_contact_id ),
881: bill_to_contact_id = decode( bill_to_contact_id, p_from_fk_id, p_to_fk_id, bill_to_contact_id ),
882: technical_contact_id = decode( technical_contact_id, p_from_fk_id, p_to_fk_id, technical_contact_id ),
883: service_admin_contact_id = decode( service_admin_contact_id, p_from_fk_id, p_to_fk_id, service_admin_contact_id ),

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

905: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_txn_type_not_found_msg);
906: x_return_status := FND_API.G_RET_STS_ERROR;
907: raise;
908: when resource_busy then
909: 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 );
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: raise;
912:
913: when others then

Line 919: END CSI_SYSTEMS_B_MERGE;

915: x_return_status := FND_API.G_RET_STS_ERROR;
916: raise;
917: END;
918: end if;
919: END CSI_SYSTEMS_B_MERGE;
920:
921: PROCEDURE CSI_T_TXN_SYSTEMS_MERGE(
922: p_entity_name IN VARCHAR2,
923: p_from_id IN NUMBER,