APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_T_TXN_SYSTEMS

Line 921: PROCEDURE CSI_T_TXN_SYSTEMS_MERGE(

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

Line 935: from csi_t_txn_systems

931: IS
932:
933: cursor c1 is
934: select 1
935: from csi_t_txn_systems
936: where install_site_use_id = p_from_fk_id
937: for update nowait;
938:
939: cursor c2 is

Line 941: from csi_t_txn_systems

937: for update nowait;
938:
939: cursor c2 is
940: select 1
941: from csi_t_txn_systems
942: where ship_to_contact_id = p_from_fk_id
943: or bill_to_contact_id = p_from_fk_id
944: or technical_contact_id = p_from_fk_id
945: or service_admin_contact_id = p_from_fk_id

Line 949: l_api_name VARCHAR2(30) := 'CSI_T_TXN_SYSTEMS_MERGE';

945: or service_admin_contact_id = p_from_fk_id
946: for update nowait;
947:
948: l_merge_reason_code VARCHAR2(30);
949: l_api_name VARCHAR2(30) := 'CSI_T_TXN_SYSTEMS_MERGE';
950: l_count NUMBER(10) := 0;
951: l_system_audit_id NUMBER;
952: l_column_name VARCHAR2(30);
953: v_no_of_rows NUMBER;

Line 963: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');

959: RESOURCE_BUSY EXCEPTION;
960: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
961:
962: BEGIN
963: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
964:
965: x_return_status := FND_API.G_RET_STS_SUCCESS;
966:
967: begin

Line 1013: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_SYSTEMS', FALSE);

1009:
1010: If p_parent_entity_name = 'HZ_PARTY_SITES' Then
1011:
1012: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1013: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_SYSTEMS', FALSE);
1014:
1015: l_column_name := 'install_site_use_id';
1016:
1017: open c1;

Line 1020: update csi_t_txn_systems

1016:
1017: open c1;
1018: close c1;
1019:
1020: update csi_t_txn_systems
1021: set install_site_use_id = p_to_fk_id,
1022: last_update_date = SYSDATE,
1023: last_updated_by = G_USER_ID,
1024: last_update_login = G_LOGIN_ID

Line 1035: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_SYSTEMS', FALSE);

1031:
1032: Elsif p_parent_entity_name = 'HZ_PARTIES' Then
1033:
1034: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1035: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_SYSTEMS', FALSE);
1036:
1037: l_column_name := 'contact_ids';
1038:
1039: open c2;

Line 1042: update csi_t_txn_systems

1038:
1039: open c2;
1040: close c2;
1041:
1042: update csi_t_txn_systems
1043: set bill_to_contact_id = decode(bill_to_contact_id, p_from_fk_id, p_to_fk_id, bill_to_contact_id ),
1044: ship_to_contact_id = decode(ship_to_contact_id, p_from_fk_id, p_to_fk_id, ship_to_contact_id ),
1045: technical_contact_id = decode(technical_contact_id, p_from_fk_id, p_to_fk_id, technical_contact_id ),
1046: service_admin_contact_id = decode(service_admin_contact_id,

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

1065: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' ||v_internal_party_message);
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: raise;
1068: when resource_busy then
1069: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_SYSTEMS for '||l_column_name ||' = '|| p_from_fk_id );
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: raise;
1072: when others then
1073: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1080: END CSI_T_TXN_SYSTEMS_MERGE;

1076: END;
1077:
1078: end if;
1079:
1080: END CSI_T_TXN_SYSTEMS_MERGE;
1081:
1082: PROCEDURE CSI_T_PARTY_DETAILS_MERGE(
1083: p_entity_name IN VARCHAR2,
1084: p_from_id IN NUMBER,