APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 1206: PROCEDURE CSI_T_TXN_LINE_DETAILS_MERGE(

1202: END;
1203: END IF;
1204: END CSI_T_PARTY_DETAILS_MERGE;
1205:
1206: PROCEDURE CSI_T_TXN_LINE_DETAILS_MERGE(
1207: p_entity_name IN VARCHAR2,
1208: p_from_id IN NUMBER,
1209: x_to_id OUT NOCOPY NUMBER,
1210: p_from_fk_id IN NUMBER,

Line 1222: from csi_t_txn_line_details

1218: v_install_location_type_code VARCHAR2(30) := 'HZ_PARTY_SITES';
1219:
1220: cursor c1 is
1221: select 1
1222: from csi_t_txn_line_details
1223: where ( location_id = p_from_fk_id and location_type_code = v_location_type_code )
1224: or ( install_location_id = p_from_fk_id and install_location_type_code = v_location_type_code )
1225: for update nowait;
1226:

Line 1228: l_api_name VARCHAR2(30) := 'CSI_T_TXN_LINE_DETAILS_MERGE';

1224: or ( install_location_id = p_from_fk_id and install_location_type_code = v_location_type_code )
1225: for update nowait;
1226:
1227: l_merge_reason_code VARCHAR2(30);
1228: l_api_name VARCHAR2(30) := 'CSI_T_TXN_LINE_DETAILS_MERGE';
1229: l_column_name VARCHAR2(30);
1230: l_count NUMBER(10) := 0;
1231: l_cp_audit_id NUMBER;
1232: v_transaction_type_id NUMBER;

Line 1243: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');

1239:
1240: RESOURCE_BUSY EXCEPTION;
1241: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1242: BEGIN
1243: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');
1244:
1245: x_return_status := FND_API.G_RET_STS_SUCCESS;
1246:
1247: select merge_reason_code

Line 1269: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_LINE_DETAILS', FALSE);

1265:
1266: IF p_from_fk_id <> p_to_fk_id then
1267: BEGIN
1268: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1269: arp_message.set_token('TABLE_NAME', 'CSI_T_TXN_LINE_DETAILS', FALSE);
1270: l_column_name := 'location_id';
1271:
1272: open c1;
1273: close c1;

Line 1275: update csi_t_txn_line_details

1271:
1272: open c1;
1273: close c1;
1274:
1275: update csi_t_txn_line_details
1276: set location_id = decode( location_id, p_from_fk_id, p_to_fk_id, location_id ),
1277: install_location_id = decode( install_location_id, p_from_fk_id, p_to_fk_id, install_location_id ),
1278: last_update_date = SYSDATE,
1279: last_updated_by = G_USER_ID,

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

1291: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || v_internal_party_message);
1292: x_return_status := FND_API.G_RET_STS_ERROR;
1293: raise;
1294: when resource_busy then
1295: arp_message.set_line(g_proc_name || '.' || l_api_name || '; Could not obtain lock for records in table ' || 'CSI_T_TXN_LINE_DETAILS for '||l_column_name ||' = '|| p_from_fk_id );
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: raise;
1298: when others then
1299: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1304: END CSI_T_TXN_LINE_DETAILS_MERGE;

1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: raise;
1302: END;
1303: END IF;
1304: END CSI_T_TXN_LINE_DETAILS_MERGE;
1305:
1306: END CSI_PARTY_MERGE_PKG;