6263: SET last_vld_organization_id = l_instance_rec.vld_organization_id,
6264: active_end_date = null
6265: WHERE instance_id = l_instance_rec.instance_id;
6266:
6267: csi_process_txn_pvt.check_and_break_relation(
6268: p_instance_id => l_instance_rec.instance_id,
6269: p_csi_txn_rec => l_txn_rec,
6270: x_return_status => l_return_status);
6271:
9185: FROM csi_i_parties
9186: WHERE instance_id = l_instance_rec.instance_id
9187: AND relationship_type_code = 'OWNER';
9188:
9189: log(' csi_process_txn_pvt.check_and_break_relation');
9190:
9191: -- qualifieis for update
9192: csi_process_txn_pvt.check_and_break_relation(
9193: p_instance_id => l_instance_rec.instance_id,
9188:
9189: log(' csi_process_txn_pvt.check_and_break_relation');
9190:
9191: -- qualifieis for update
9192: csi_process_txn_pvt.check_and_break_relation(
9193: p_instance_id => l_instance_rec.instance_id,
9194: p_csi_txn_rec => l_txn_rec,
9195: x_return_status => l_return_status);
9196:
13469: IF l_instance_rec.instance_usage_code <> 'RETURNED' OR
13470: l_instance_rec.location_type_code <> 'INVENTORY'
13471: THEN
13472:
13473: csi_process_txn_pvt.check_and_break_relation(
13474: p_instance_id => l_instance_rec.instance_id,
13475: p_csi_txn_rec => l_txn_rec,
13476: x_return_status => l_return_status);
13477: